Sql Server Get table data (.csv) excuting bat file

How To get sql server Table all records in Csv file by excuting .bat file in Client machine

sample Bat file

1)Open Notepad

2)SQLCMD -S .\SQLEXPRESS -d DatabaseName -E -Q "select * from tableName" -o "FileName.csv" -h-1 -s"," -w 700

3)save as .bat File

Export Excel From DataGrid using C#

Hi Guys.,
Using c# we need to Export To Excel from datagrid .Following Code will help For you


sample Code:

// create the DataGrid and perform the databinding
System.Web.UI.WebControls.DataGrid grid = new System.Web.UI.WebControls.DataGrid();
grid.HeaderStyle.Font.Bold = true;

DataSet ds = new DataSet();
ds.ReadXml("File Location");
grid.DataSource = ds.Tables[0];
//grid.DataMember = data.Stats.TableName;

grid.DataBind();

// render the DataGrid control to a file
using(StreamWriter sw = new StreamWriter(textBox1.Text))
{
using(HtmlTextWriter hw = new HtmlTextWriter(sw))
{
grid.RenderControl(hw);
}
}
}