Ask a Question related to ASP.NET Data Grid Control, Design and Development.
-
Thiyagarajan Natarajan #1
store the value of datagrid to database
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
Thiyagarajan Natarajan Guest
-
Displaying Chinese Character store in MySQL Database
Hi, is there anyone who know how to display chinese character store at MySQL database? I can display it correctly when using MS Access database.... -
Store in a database + create reports?
Questionnaire study 1. I wish to build a questionnaire with 14 questions where the user can answer Yes or No each question. 2. Then I would... -
store and retrieve flash in and from database
Hi all, i stored an uploaded flash-file in a MS-SQL database. Now i want to retrieve this file from my database in ASP.NET, but I don't know how to... -
store info in database.
Hi! I have a delicatg problem.... I have made a registration form for adding my friends information in a database. The problem is that I want to... -
Access database from store procedure
Hi All, i need your help, my problem like this, how to get data that will displayed in table rows from store procedure..as example in col 1 row 1 i...



Reply With Quote

