Hi sg0176,
I have made one sample that full-fill your requirement.
HTML
<div>
<asp:ScriptManager ID="scriptManager" runat="server">
</asp:ScriptManager>
<asp:UpdatePanel runat="server" ID="upMain" UpdateMode="Conditional" ChildrenAsTriggers="true">
<ContentTemplate>
<table>
<tr>
<td>
Name:
</td>
<td>
<asp:TextBox runat="server" ID="txtName" />
</td>
</tr>
<tr>
<td>
Age:
</td>
<td>
<asp:TextBox runat="server" ID="txtAge" />
</td>
</tr>
</table>
<br />
<asp:LinkButton ID="lnkSubmit" runat="server" OnClick="lnkSubmit_Click">Save</asp:LinkButton>
<br />
<br />
<asp:GridView runat="server" ID="gvDetails" AutoGenerateColumns="false">
<Columns>
<asp:BoundField DataField="NAME" HeaderText="Name" />
<asp:BoundField DataField="AGE" HeaderText="Age" />
</Columns>
</asp:GridView>
</ContentTemplate>
<Triggers>
<asp:AsyncPostBackTrigger ControlID="lnkSubmit" EventName="Click" />
</Triggers>
</asp:UpdatePanel>
</div>
Code
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.GetDetails();
}
}
private void GetDetails()
{
string constr = ConfigurationManager.ConnectionStrings["conString"].ToString();
using (SqlConnection con = new SqlConnection(constr))
{
con.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "SELECT * FROM MYTEST";
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
this.gvDetails.DataSource = dt;
this.gvDetails.DataBind();
con.Close();
}
}
}
protected void lnkSubmit_Click(object sender, EventArgs e)
{
string constr = ConfigurationManager.ConnectionStrings["conString"].ToString();
using (SqlConnection con = new SqlConnection(constr))
{
con.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "INSERT INTO MYTEST VALUES (@Name,@Age)";
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Name", txtName.Text);
cmd.Parameters.AddWithValue("@Age", txtAge.Text);
cmd.ExecuteNonQuery();
con.Close();
}
}
txtName.Text = string.Empty;
txtAge.Text = string.Empty;
this.GetDetails();
}
Screenshot
