page.aspx
<asp:TemplateField HeaderText="Maxmarks">
<ItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%=(TextBox1.Text) %>'></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
page.aspx.cs
protected void btnEnter_Click(object sender, EventArgs e)
{
string value=string.Empty;
foreach (GridViewRow row in grvTest.Rows)
{
TextBox txt = (TextBox)row.FindControl("txtTextBoxInGrid");
value.text=txt.text;
int i=save(value);
if(i>0)
{
ClientScript.RegisterClientScriptBlock(GetType(), "sas", "<script> alert('Inserted successfully');</script>", false);
}
else
{
ClientScript.RegisterClientScriptBlock(GetType(), "sas", "<script> alert('Insertion Unsuccessfully');</script>", false);
}
}
}
protected int save(string value)
{
bll obj=new bll();
int i=obj.insert(value);
return i;
}
BLL
protected int insert(string value)
{
dal ob=new dal();
int i=ob.insertion(value);
return i;
}
DAL
protected int insertion(string value)
{
SqlConnection con=new SqlConnection("datasource;inital catalog;user id;password");
SqlCommand cmd= SqlCommand("Stored Procedure name",con);
cmd.CommandType=CommandType.StoredProcedure;
cmd.Parameters.add("@TextFieldvalue", SqlDbType.VarChar);
con.Open();
int i= cmd.ExecuteNonQuery();
sqlConn.Close();
return i;
}
stored procedure
create procedure procedurename
@TextFieldvalue varchar(50);
as
begin
Insert into tablename (name)
Values(@TextFieldvalue)
end