Edit StringBuilder Table

Ruchi R

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.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pradeep Chandraker15y ago
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
0
Ruchi R15y ago
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.
0
Pradeep Chandraker15y ago
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.

0
Ruchi R15y ago
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();
        }
    }
0
Pradeep Chandraker15y ago
Can you provide more details on you problem? the code sample will really help?
0
Guest User15y ago
Can you post your code? I'm not sure what you mean by "stringbuilder table".
0