Listbox

Question

LisBbox items values download to Excel Sheet in asp.net c#

Ashok Yadav · Answer

protected void btnExportfromDt_Click(object sender EventArgs e) { DataTable dtplants = new DataTable(); dtplants.Columns.Add(Plants); foreach (ListItem li in lbxPlants.Items) { DataRow drplants = dtplants.NewRow(); drplants[0] = li.Value; dtplants.Rows.Add(drplants); } string strFilename = EmpDetails.xls; UploadDataTableToExcel( dtplants  strFilename); } protected void UploadDataTableToExcel(DataTable dtEmpstring filename) { string attachment = attachment; filename=+filename; Response.ClearContent(); Response.AddHeader(content-disposition attachment); Response.ContentType = application/vnd.ms-excel; string tab = string.Empty; foreach (DataColumn dtcol in dtEmp.Columns) { Response.Write(tab + dtcol.ColumnName); tab = 	; } Response.Write(
); foreach (DataRow dr in dtEmp.Rows) { tab = ; for (int j = 0; j { Response.Write(tab + Convert.ToString(dr[j])); tab = 	; } Response.Write(
); } Response.End(); }