Hi ,
I having the issue when export excel in csv format when get the chines characters from the data base. if anyone knows suggest me wth sample code . i share my code .
protected void ExportCSV(object sender, EventArgs e)
{
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (MySqlConnection con = new MySqlConnection(constr))
{
//using (MySqlCommand cmd = new MySqlCommand("SELECT * FROM che.Customers"))
using (MySqlCommand cmd = new MySqlCommand("select I.Barcode, I.InventoryName, I.Description ,C.CategoryID,I.Price,I.Price2,I.Price3,I.Price4,I.onhand as Stock,ic.Unitcost,i.NoPriceShift,I.Group1,I.Group2,I.Group3,I.Group4,I.Group5,I.StockCode,I.Unit,I.CommissionPercent1,I.CommissionPercent2,I.CommissionPercent3,I.CommissionAmount1,I.CommissionAmount2,I.ERPItemCode1,I.ERPItemCode2,I.ERPItemDesc,I.Imagepath,sum(pquantity-(CutQuantity+RetailQty))as OnHand from da1.inventory as I join da1.inventorycategories as c ON I.Categoryid=c.categoryid join da1.inventorycostaverage ic on ic.inventoryid=i.inventoryid group by i.inventoryid ;"))
{
using (MySqlDataAdapter sda = new MySqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
//Build the CSV file data as a Comma separated string.
string csv = string.Empty;
foreach (DataColumn column in dt.Columns)
{
//Add the Header row for CSV file.
csv += column.ColumnName + ',';
}
//Add new line.
csv += "\r\n";
foreach (DataRow row in dt.Rows)
{
foreach (DataColumn column in dt.Columns)
{
//Add the Data rows.
csv += row[column.ColumnName].ToString().Replace(",", ";") + ',';
}
//Add new line.
csv += "\r\n";
}
//Download the CSV file.
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=SqlExport.csv");
Response.Charset = "";
Response.ContentType = "application/text";
Response.Output.Write(csv);
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.Flush();
Response.End();
}
}
}
}
}