Hi,
There is a Header record with a Gridview that is for Detail records of the Header one.
Here is the Gridview
<asp:GridView ID="GridView1" runat="server" Width = "550px"
AutoGenerateColumns = "false" Font-Names = "Arial"
Font-Size = "11pt" AlternatingRowStyle-BackCo
<div class="first last">lor = "#C2D69B"
HeaderStyle-BackColor = "green" AllowPaging ="true"
ShowFooter = "true" OnPageIndexChanging="GridView1_PageIndexChanging"
OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowEditing="GridView1_RowEditing"
OnRowUpdating="GridView1_RowUpdating" PageSize = "10">
<Columns>
<asp:TemplateField ItemStyle-Width ="70px" HeaderText="Rec ID">
<ItemTemplate>
<asp:Label ID="lblintid" runat="server" Text='<%# Eval("Rec_ID")%>'>
</asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtintid" runat="server" Text='<%# Eval("Rec_ID")%>' ></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField ItemStyle-Width = "100px" HeaderText = "Description">
<ItemTemplate>
<asp:Label ID="lblflddesc" runat="server"
Text='<%# Eval("Rec_desc")%>'>
</asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtflddesc" runat="server"
Text='<%# Eval("Rec_desc")%>'>
</asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtflddesc" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField ItemStyle-Width = "150px" HeaderText = "Change Date">
<ItemTemplate>
<asp:Label ID="lblchangedate" runat="server"
Text='<%# Eval("change_date")%>'>
</asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="txtchangedate" runat="server"
Text='<%# Eval("change_date")%>' >
</asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtchangedate" runat="server"></asp:TextBox>
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:LinkButton ID="lnkRemove" runat="server" CommandArgument='<%# Eval("txtflddesc")%>'
OnclientClick="return confirm('Do you want to delete the record?')" Text="Delete"
OnClick="DeleteRec" ></asp:LinkButton>
</ItemTemplate>
<FooterTemplate>
<asp:Button ID="btnAdd" runat="server" Text="Add" OnClick="AddNewRec" />
</FooterTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
Upon saving the Header record, I have tried to also run this event below
private void BindData()
{
int user_id = Convert.ToInt16(lb_userid.Text);
string strQuery = "select user_id,rec_id,rec_desc,change_date" +
" from tab3 where user_id=@user_id";
SqlCommand cmd = new SqlCommand(strQuery);
cmd.Parameters.Add("@user_id", SqlDbType.Int).Value = user_id;
GridView1.DataSource = GetData(cmd);
GridView1.DataBind();
}
How to enhance the codes of Gridview to allow data input for the Detail record by this Gridview, after I've saved the header record?