protected void btnImport_Click(object sender, EventArgs e) { string[] lstdata = hdnHeaderRank.Value.Split(':'); List <string> lstColumnNames = (List <string>)Session["ColumnNames"]; foreach (GridViewRow gridRow in lstLeadsData.Rows) { List <string> lstCellColumns = new List <string>(); List <string> lstCellParameters = new List <string>(); List <string> lstCellValues = new List <string>(); for (int a = 0; a < lstLeadsData.HeaderRow.Cells.Count; a++) { lstCellColumns.Add(lstdata[a]); lstCellParameters.Add("@" + lstdata[a]); lstCellValues.Add(gridRow.Cells[a].Text); } string columns = string.Join(",", lstCellColumns); string values = string.Join(",", lstCellParameters); msSqlHelper.InsertData(txtConnectionString.Text, drpTables.SelectedItem.Text, columns, values, lstCellParameters, lstCellValues); } }