INSERT.aspx
<%@ Page Language="C#" AutoEventWireup="true"
CodeFile="Insert.aspx.cs" Inherits="Insert" %>
<!DOCTYPE
html>
<html
xmlns="http://www.w3.org/1999/xhtml">
<head
runat="server">
<title></title>
<style type="text/css">
.auto-style1 {
width: 100%;
}
.auto-style2 {
width: 98px;
}
</style>
</head>
<body>
<form id="form1"
runat="server">
<table
class="auto-style1">
<tr>
<td class="auto-style2">ID</td>
<td>
<asp:TextBox
ID="TextBox1" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td
class="auto-style2">Name</td>
<td>
<asp:TextBox
ID="TextBox2" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td
class="auto-style2">Address</td>
<td>
<asp:TextBox
ID="TextBox3" runat="server"></asp:TextBox>
</td>
</tr>
</table>
<br />
<asp:Button ID="Button1"
runat="server" OnClick="Button1_Click"
Text="Insert" />
<br />
<asp:GridView
ID="GridView1" runat="server">
</asp:GridView>
</form>
</body>
</html>
INSERT.ASPX.CS
using System;
using
System.Collections.Generic;
using
System.Linq;
using
System.Web;
using
System.Web.UI;
using
System.Web.UI.WebControls;
using
System.Data.SqlClient;
using System.Data;
public partial
class Insert : System.Web.UI.Page
{
SqlConnection conn = new
SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=D:\Program OF
Asp.net\WebSite2\App_Data\Database.mdf;Integrated Security=True");
SqlCommand cmd; //for insert update delete.
SqlDataAdapter adp;
DataTable dt;
public void disp_emp() // create Function and
define it.
{ // Or manualy you can
write it.
conn.Open();
adp = new SqlDataAdapter("select *
from emp", conn);
dt = new DataTable();
adp.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
conn.Close();
}
protected void Page_Load(object sender,
EventArgs e)
{
disp_emp(); //define class.
}
protected void Button1_Click(object sender,
EventArgs e)
{
conn.Open();
cmd = new SqlCommand("insert into
emp values('" + TextBox1.Text + "','" + TextBox2.Text +
"','" + TextBox3.Text + "')", conn);
cmd.ExecuteNonQuery();
conn.Close();
disp_emp(); //define class.
}
}