Reply to thread

Message: [QUOTE="Thiyagarajan Natarajan, post: 4265733"] Hi all! I am getting the data from datagrid. and i have to store in database by cliking the save button. private void imgbtnSave_Click(object sender, System.Web.UI. ImageClickEventArgs e) { StringBuilder sbQuery = new StringBuilder(""); sbQuery.Append("insert into CT_Customers(Module,subModule,Version)values") foreach(DataGridItem dgi in this.dgModule.Items) { sbQuery.Append("'"+ dgi.Cells[1].Text.ToString().Trim().Replace("'","''")+"', "); sbQuery.Append("'"+ dgi.Cells[2].Text.ToString().Trim().Replace("'","''") +"',"); sbQuery.Append("'"+ dgi.Cells[3].Text.ToString().Trim().Replace("'","''")+"', "); } } SQLHelper.ExecuteNonQuery(sbQuery.ToString()); but it doesn't go to even foreach loop while debugging. can anybody help me please?? thanks all [/QUOTE]