Edit StringBuilder Table

Question

HI all i have binded data from database into a stringbulider table. Is it possible to edit the stringbuilder table. If yes how can we do that. Plz help.

John Penn · Answer

Can you post your code? I'm not sure what you mean by stringbuilder table.

Pradeep Chandraker · Answer

Ok. Now I understood. Instead of using html table you need to use asp.net datagrid to provide edit functionality. Please go through below link for more details on how to implement edit/update/ delete functionality in datagrid. http://www.c-sharpcorner.com/UploadFile/rahul4_saxena/BasicoperationsofDataGrid05022007081224AM/BasicoperationsofDataGrid.aspx http://www.c-sharpcorner.com/UploadFile/lcamlibel/datagridwebcontrol02122007040915AM/datagridwebcontrol.aspx http://www.codeproject.com/KB/aspnet/Edit_and_Delete_Data.aspx

Ruchi R · Answer

thanks for your reply. The above code binds the data from a database into a table. Now what i need to do is: there will be one edit button on a form. If a user check on a checkbox in table and Click on a edit button he should be able to edit the respective data. Could you provide me a sample code if possible.

Pradeep Chandraker · Answer

You can insert new string or replace existing string in StringBuilder. But for your requirement there is only one way to edit StringBuilder which is re-create new StringBuilder with new value. Also can you explain little bit more on what exactly you want to do. I see you are assigning StringBuilder variable ShowDetails into session but wanted to know what exactly you want to edit it will be good if you can provide some scenario.

Ruchi R · Answer

Here is my code for binding data in a stringbulider. The given below code binds data in a table. Now i need to edit those data when required. How is it possible to do? protected void bindData() { StringBuilder ShowDetails = new StringBuilder(); divShow.Style.Add(display none); string myquery = select sId sEmpName dtYear dtMonth sSalary from tblSalarySheet where sStatus='A' and dtYear='+ ddListYear.SelectedItem.Text +' and dtMonth='+ ddlistMonth.SelectedItem.Text +'; int rowNum = 1; string conn = ConfigurationSettings.AppSettings[SqlConn]; SqlConnection MyConn = new SqlConnection(conn); SqlCommand cmd = new SqlCommand(myquery MyConn); SqlDataReader reader; try { MyConn.Open(); reader = cmd.ExecuteReader(); if (reader.HasRows) { divShow.Style.Add(display block); rowNum = 1; while (reader.Read()) { if (rowNum % 2 == 0) ShowDetails.Append( ); else ShowDetails.Append( ); ShowDetails.Append( ); ShowDetails.Append(  + reader[sId].ToString().Trim() +  ); ShowDetails.Append(  + reader[sEmpName].ToString().Trim() +  ); ShowDetails.Append(  + reader[dtYear].ToString().Trim() +  ); ShowDetails.Append(  + reader[dtMonth].ToString().Trim() +  ); ShowDetails.Append(  + reader[sSalary].ToString().Trim() +  );  ); rowNum++; ShowDetails.Append( ); } Session[sID] = ShowDetails.ToString(); } else { divShow.Style.Add(display none); } reader.Close(); } catch { } finally { MyConn.Close(); cmd.Dispose(); } }

Pradeep Chandraker · Answer

Can you provide more details on you problem? the code sample will really help?