I use this code:
in my project but it doesn't work to me.
How can I modify my code according to this code?
this is my GridView Code:
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3"
DataSourceID="SqlDataSrcAddMark" HorizontalAlign="Center" Font-Names="Tahoma" Width="572px">
<Columns>
<asp:BoundField DataField="ExamAttendanceTypeId" HeaderText="وضعیت حضور" SortExpression="ExamAttendanceTypeId" HeaderStyle-CssClass="Header-center">
<HeaderStyle CssClass="Header-center"></HeaderStyle>
</asp:BoundField>
<asp:TemplateField HeaderText="نمره" SortExpression="Mark">
<ItemTemplate>
<asp:Label ID="lbl_Text1" runat="server" Text='<%# Bind("Mark") %>'></asp:Label>
<asp:TextBox ID="txt_Text1" runat="server" Text='<%# Bind("Mark") %>' CssClass="hideControl"
AutoPostBack="true" OnTextChanged="Change"></asp:TextBox>
</ItemTemplate>
<HeaderStyle CssClass="Header-center" />
</asp:TemplateField>
<asp:BoundField DataField="FirstName" HeaderText="نام خانوادگی" SortExpression="FirstName" HeaderStyle-CssClass="Header-center">
<HeaderStyle CssClass="Header-center"></HeaderStyle>
</asp:BoundField>
<asp:BoundField DataField="LastName" HeaderText="نام" SortExpression="LastName" HeaderStyle-CssClass="Header-center">
<HeaderStyle CssClass="Header-center"></HeaderStyle>
</asp:BoundField>
<asp:BoundField DataField="SubjectStudyLessonCourseId" HeaderText="-----" SortExpression="SubjectStudyLessonCourseId" HeaderStyle-CssClass="Header-center">
<HeaderStyle CssClass="Header-center"></HeaderStyle>
</asp:BoundField>
</Columns>
<FooterStyle BackColor="White" ForeColor="#000066" />
<HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
<RowStyle ForeColor="#000066" />
<SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
<SortedAscendingCellStyle BackColor="#F1F1F1" />
<SortedAscendingHeaderStyle BackColor="#007DBB" />
<SortedDescendingCellStyle BackColor="#CAC9C9" />
<SortedDescendingHeaderStyle BackColor="#00547E" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSrcAddMark" runat="server" ConnectionString="<%$ ConnectionStrings:KDUIS-v1ConnectionString %>" SelectCommand="AttendanceList" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:ControlParameter ControlID="SubjectStudyLessonCourseId" Name="CourseId" PropertyName="Text" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
protected void Change(object sender, EventArgs e)
{
TextBox txtMark = sender as TextBox;
GridViewRow row = (GridViewRow)txtMark.NamingContainer;
string query = "UPDATE EDU_Student_Course_Registration SET Mark = @Mark WHERE SubjectStudyLessonCourseId = @SubjectStudyLessonCourseId";
string constr = ConfigurationManager.ConnectionStrings["KDUIS-v1ConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand(query, con))
{
cmd.Parameters.AddWithValue("@Mark", txtMark.Text);
cmd.Parameters.AddWithValue("@SubjectStudyLessonCourseId", row.Cells[4].Text);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}