Refer this code
HTML
<table border="0" cellpadding="0" cellspacing="0" width="500">
<tr>
<td>
User Name
</td>
<td>
<asp:TextBox ID="txtUserName" runat="server" />
</td>
</tr>
<tr>
<td>
Password
</td>
<td>
<asp:TextBox ID="txtPassword" runat="server" TextMode="Password" />
</td>
</tr>
<tr>
<td colspan="1">
<asp:Label ID="lblMessage" Text=" " runat="server" />
</td>
</tr>
<tr>
<td>
</td>
<td>
<asp:Button runat="server" Text="Insert" OnClick="Insert" />
</td>
</tr>
</table>
Namespace
using System.Configuration;
using System.Data.SqlClient;
C#
protected void Insert(object sender, EventArgs e)
{
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO tblLogins(UserName,Password) VALUES(@UserName,@Password)", con))
{
con.Open();
cmd.Parameters.AddWithValue("@UserName", this.txtUserName.Text.Trim());
cmd.Parameters.AddWithValue("@Password", this.txtPassword.Text.Trim());
int k = cmd.ExecuteNonQuery();
if (k > 0)
{
lblMessage.Text = "Record Inserted";
}
con.Close();
}
}
}
SQL
CREATE TABLE [dbo].[tblLogins](
[Id] [int] IDENTITY(1,1) NOT NULL,
[UserName] [varchar](50) NOT NULL,
[Password] [nvarchar](100) NOT NULL
) ON [PRIMARY]
GO
Screemshot