<asp:TextBox ID="txt_sal" runat="server"></asp:TextBox><br />

</div>

<asp:Button ID="btn_insert" runat="server" onclick="btn_insert_Click"

Text="Insert Data" /><br />

<asp:Label ID="Label4" runat="server"></asp:Label>

</form>

</body>

</html>

Default.aspx.cs code

using System;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

string str;

SqlCommand com;

int count;

protected void Page_Load(object sender, EventArgs e)

{

SqlConnection con = new SqlConnection(strConnString);

str = "select count(*) from employee";

com = new SqlCommand(str, con);

con.Open();

count = Convert.ToInt16(com.ExecuteScalar()) + 1;

txt_empid.Text = "E00" + count;

con.Close();

}

protected void btn_insert_Click(object sender, EventArgs e)

{

SqlConnection con = new SqlConnection(strConnString);

con.Open();

str = "insert into employee values('" + txt_empid.Text.Trim() + "','" + txt_empname.Text.Trim() + "'," + txt_sal.Text.Trim() + ")";

com = new SqlCommand(str, con);

com.ExecuteNonQuery();

con.Close();

Label4.Text = "Records successfully Inserted";

}

}

Thanks for reading