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