how to update data in multiple gridviews in 1 page

See more:

C#

ASP.NET

Hi guys,

i manage to update data for the 1st gridview.but when i add the 2nd gridview on the page it turn to failed.seems like the code succeed to only 1 gridview..

protected void UpdateRecord(object sender, GridViewUpdateEventArgs e)
    {
        string connectionString = ConfigurationManager.ConnectionStrings["ConnectionString3"].ConnectionString;
        SqlConnection myConnection = new SqlConnection(connectionString);
        string query = "UPDATE signals_comm_failure SET report=@report, react_delay=@react_delay, responsibility=@responsibility, actions=@actions WHERE date = '" + TextBox1.Text + "' and id =1";
        SqlCommand com = new SqlCommand(query, myConnection);
        //myConnection.Open();

        GridViewRow row = (GridViewRow)kvdt_ridt.Rows[e.RowIndex];
        TextBox report = (TextBox)row.FindControl("report");
        TextBox react_delay = (TextBox)row.FindControl("react_delay");
        TextBox responsibility = (TextBox)row.FindControl("responsibility");
        TextBox actions = (TextBox)row.FindControl("actions");

        com.Parameters.Add("@report", SqlDbType.VarChar).Value = report.Text.Trim();
        com.Parameters.Add("@react_delay", SqlDbType.VarChar,50).Value = react_delay.Text.Trim();
        com.Parameters.Add("@responsibility", SqlDbType.VarChar,50).Value = responsibility.Text.Trim();
        com.Parameters.Add("@actions", SqlDbType.VarChar).Value = actions.Text.Trim();

        try
        {
            myConnection.Open();
            com.ExecuteNonQuery();
            myConnection.Close();
            lblMessage.Text = "Record Updated Successfully.";
            // Refresh the data
            kvdt_ridt.EditIndex = -1;
            BindData1();

        }

        catch (SqlException ee)
        {
            lblMessage.Text = ee.Message;
        }

        string query2 = "UPDATE signals_comm_failure SET report=@report, cause=@cause, responsibility=@responsibility, actions=@actions WHERE date = '" + TextBox1.Text + "' and id =2";
        SqlCommand com2 = new SqlCommand(query, myConnection);

        GridViewRow row2 = (GridViewRow)outside_dt.Rows[e.RowIndex];
        TextBox report2 = (TextBox)row.FindControl("report2");
        TextBox cause2 = (TextBox)row.FindControl("cause2");
        TextBox responsibility2 = (TextBox)row.FindControl("responsibility2");
        TextBox actions2 = (TextBox)row.FindControl("actions2");

        com.Parameters.Add("@report", SqlDbType.VarChar).Value = report.Text.Trim();
        com.Parameters.Add("@cause", SqlDbType.VarChar).Value = react_delay.Text.Trim();
        com.Parameters.Add("@responsibility", SqlDbType.VarChar, 50).Value = responsibility.Text.Trim();
        com.Parameters.Add("@actions", SqlDbType.VarChar).Value = actions.Text.Trim();

        try
        {
            myConnection.Open();
            com2.ExecuteNonQuery();
            myConnection.Close();
            lblMessage2.Text = "Record Updated Successfully.";
            // Refresh the data
            outside_dt.EditIndex = -1;
            BindData2();
        }

        catch (SqlException ee)
        {
            lblMessage2.Text = ee.Message;
        }
    } 

<asp:Panel ID="Panel1" runat="server" BorderColor="#006699" BorderWidth="1px" 
                    Visible="False">
                    <asp:Label ID="Label1" runat="server" ForeColor="Black" 
                        Text="1. Signals & Communication Failure (KVDT & RIDT)">
                    <br />
                    <br />
                    <asp:GridView ID="kvdt_ridt" runat="server" AutoGenerateColumns="false" 
                        AllowPaging="True" AllowSorting="True" OnRowEditing="EditRecord"

                OnRowCancelingEdit="CancelRecord" OnRowUpdating="UpdateRecord" CellPadding="4"

                HeaderStyle-HorizontalAlign="left" AutoGenerateEditButton="True" >
                        
                    <columns>
                    
                        <asp:TemplateField HeaderText="Location & Date">
                            <itemtemplate>
                                <asp:Label ID="Label1" runat="server" Text='<%# Eval("origin") %>' >
                                <asp:Label ID="Label2" runat="server" Text='<%# Eval("date","{0:d}") %>'>
                            </itemtemplate>
                        
                        <asp:TemplateField HeaderText="Report">
                        <itemtemplate>
                        <asp:Label ID="Label2" runat="server" Text='<%# Eval("report") %>'></itemtemplate>
                        <edititemtemplate>
                            <asp:TextBox ID="report" runat="server" TextMode="MultiLine" Text='<%# Eval("report") %>'>
                            </edititemtemplate>
                        

                        <asp:TemplateField HeaderText="Reactionary Delay">
                        <itemtemplate>
                        <asp:Label ID="Label4" runat="server" Text='<%# Eval("react_delay") %>'>
                        
                        </itemtemplate>
                        <edititemtemplate>
                        <asp:TextBox ID="react_delay" runat="server" Text='<%# Eval("react_delay") %>'> >
                        </edititemtemplate>
                        
                        <asp:TemplateField HeaderText="Responsibility">
                        <itemtemplate>
                        <asp:Label ID="Label5" runat="server" Text='<%# Eval("responsibility") %>'>
                        
                        </itemtemplate>
                        <edititemtemplate>
                        <asp:TextBox ID="responsibility" runat="server" Text='<%# Eval("responsibility") %>'> >
                        </edititemtemplate>

                        <asp:TemplateField HeaderText="Action">
                        <itemtemplate>
                        <asp:Label ID="Label6" runat="server" Text='<%# Eval("actions") %>'>
                        
                        </itemtemplate>
                        <edititemtemplate>
                        <asp:TextBox ID="actions" runat="server" TextMode="MultiLine" Text='<%# Eval("actions") %>'>
                        </edititemtemplate>
                        
                     </columns>
                        <HeaderStyle HorizontalAlign="Left" />
                    
                    <asp:Label ID="lblMessage" runat="server">
                    <br />
                <br />

                <asp:Panel ID="Panel2" runat="server" BorderColor="#006699" BorderWidth="1px" 
                    Visible="False">
                    <asp:Label ID="Label2" runat="server" 
                        Text="2. Signals & Communication Failure (Outside DT)" ForeColor="Black">
                    <br />
                    <br />
                    <asp:GridView ID = "outside_dt" runat="server" AutoGenerateColumns="false" 
                        AllowPaging="True" AllowSorting="True" OnRowEditing="EditRecord"

                OnRowCancelingEdit="CancelRecord" OnRowUpdating="UpdateRecord" CellPadding="4"

                HeaderStyle-HorizontalAlign="left" AutoGenerateEditButton="True">
                    <columns>
                    
                    <asp:TemplateField HeaderText="Location & Date">
                    <itemtemplate>
                    <asp:Label ID="Label1" runat="server" Text='<%# Eval("origin") %>'>
                    <asp:Label ID="Label2" runat="server" Text='<%# Eval("date","{0:d}") %>'>
                    </itemtemplate>

                    <asp:TemplateField HeaderText="Report">
                        <itemtemplate>
                        <asp:Label ID="Label3" runat="server" Text='<%# Eval("report") %>'></itemtemplate>
                        <edititemtemplate>
                            <asp:TextBox ID="report2" runat="server" TextMode="MultiLine" Text='<%# Eval("report") %>'>
                            </edititemtemplate>
                        
                        <asp:TemplateField HeaderText="Cause">
                        <itemtemplate>
                        <asp:Label ID="Label4" runat="server" Text='<%# Eval("cause") %>'>
                        
                        </itemtemplate>
                        <edititemtemplate>
                        <asp:TextBox ID="cause2" runat="server" Text='<%# Eval("cause") %>'> >
                        </edititemtemplate>
                        
                        <asp:TemplateField HeaderText="Responsibility">
                        <itemtemplate>
                        <asp:Label ID="Label5" runat="server" Text='<%# Eval("responsibility") %>'>
                        
                        </itemtemplate>
                        <edititemtemplate>
                        <asp:TextBox ID="responsibility2" runat="server" Text='<%# Eval("responsibility") %>'> >
                        </edititemtemplate>
                        
                        <asp:TemplateField HeaderText="Action">
                        <itemtemplate>
                        <asp:Label ID="Label6" runat="server" Text='<%# Eval("actions") %>'>
                        
                        </itemtemplate>
                        <edititemtemplate>
                        <asp:TextBox ID="actions2" runat="server" TextMode="MultiLine" Text='<%# Eval("actions") %>'>
                        </edititemtemplate>
                        
                    </columns>
                    
                    <asp:Label ID = "lblMessage2" runat="server">