{"id":12400,"date":"2025-06-11T13:54:32","date_gmt":"2025-06-11T13:54:32","guid":{"rendered":"https:\/\/guidance24.in\/?p=12400"},"modified":"2025-06-11T13:54:32","modified_gmt":"2025-06-11T13:54:32","slug":"connect-your-login-page-with-a-sql-server-database-in-asp-net-web-forms-c","status":"publish","type":"post","link":"https:\/\/guidance24.in\/?p=12400","title":{"rendered":"Connect your login page with a SQL Server database in ASP.NET Web Forms (C#)"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">\u2705 Step-by-Step: Login with SQL Server Database<\/h2>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udd39 1. <strong>Create a Database Table<\/strong><\/h3>\n\n\n\n<p>In SQL Server, create a table to store login credentials:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sqlCopyEdit<code>CREATE TABLE AdminLogin (\n    ID INT PRIMARY KEY IDENTITY,\n    Username NVARCHAR(50),\n    Password NVARCHAR(50) -- In real apps, use hashed passwords\n);\n<\/code><\/pre>\n\n\n\n<p>\ud83d\udccc <strong>Insert a sample record:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sqlCopyEdit<code>INSERT INTO AdminLogin (Username, Password)\nVALUES ('admin', '123456');\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udd39 2. <strong>Add Connection String in <code>Web.config<\/code><\/strong><\/h3>\n\n\n\n<p>In your ASP.NET project\u2019s <code>Web.config<\/code>, add this inside <code>&lt;configuration&gt;<\/code>:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">xmlCopyEdit<code>&lt;connectionStrings&gt;\n  &lt;add name=\"conns\" connectionString=\"Data Source=.\\SQLEXPRESS;Initial Catalog=YourDatabaseName;Integrated Security=True\" providerName=\"System.Data.SqlClient\" \/&gt;\n&lt;\/connectionStrings&gt;\n<\/code><\/pre>\n\n\n\n<p>\ud83d\udccc Replace <code>YourDatabaseName<\/code> with your actual DB name.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udd39 3. <strong>Update Your Login Page Code<\/strong><\/h3>\n\n\n\n<p>Replace the dummy check in your <code>btnLogin_Click<\/code> with actual database validation:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">csharpCopyEdit<code>using System;\nusing System.Data;\nusing System.Data.SqlClient;\nusing System.Configuration;\n\npublic partial class admin_Login : System.Web.UI.Page\n{\n    protected void Page_Load(object sender, EventArgs e) { }\n\n    protected void btnLogin_Click(object sender, EventArgs e)\n    {\n        string username = txtUsername.Text.Trim();\n        string password = txtPassword.Text.Trim();\n\n        string connStr = ConfigurationManager.ConnectionStrings[\"conns\"].ConnectionString;\n\n        using (SqlConnection conn = new SqlConnection(connStr))\n        {\n            string query = \"SELECT COUNT(*) FROM AdminLogin WHERE Username = @Username AND Password = @Password\";\n            SqlCommand cmd = new SqlCommand(query, conn);\n            cmd.Parameters.AddWithValue(\"@Username\", username);\n            cmd.Parameters.AddWithValue(\"@Password\", password);\n\n            conn.Open();\n            int count = Convert.ToInt32(cmd.ExecuteScalar());\n\n            if (count == 1)\n            {\n                lblMessage.Text = \"Login successful!\";\n                lblMessage.CssClass = \"text-success\";\n                Response.Redirect(\"Dashboard.aspx\");\n            }\n            else\n            {\n                lblMessage.Text = \"Invalid username or password!\";\n                lblMessage.CssClass = \"text-danger\";\n            }\n        }\n    }\n}\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83d\udd10 Optional Security Recommendations<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u2705 Use <strong>hashed passwords<\/strong> (e.g., SHA256 or bcrypt) instead of plain text<\/li>\n\n\n\n<li>\u2705 Always use <strong>parameterized queries<\/strong> (as shown) to prevent SQL Injection<\/li>\n\n\n\n<li>\u2705 Manage sessions after login for secure access<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">\ud83e\uddea Testing Tips<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Make sure the database table and data exist<\/li>\n\n\n\n<li>Double-check the connection string in <code>Web.config<\/code><\/li>\n\n\n\n<li>Test with correct and incorrect credentials<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u2705 Step-by-Step: Login with SQL Server Database \ud83d\udd39 1. Create a Database Table In SQL Server, create a table to store login credentials: sqlCopyEditCREATE TABLE AdminLogin ( ID INT PRIMARY KEY IDENTITY, Username NVARCHAR(50), Password NVARCHAR(50) &#8212; In real apps, use hashed passwords ); \ud83d\udccc Insert a sample record: sqlCopyEditINSERT INTO AdminLogin (Username, Password) VALUES (&#8216;admin&#8217;, &#8216;123456&#8217;); \ud83d\udd39 2. Add Connection String in Web.config In your ASP.NET project\u2019s Web.config, add this inside &lt;configuration&gt;: xmlCopyEdit&lt;connectionStrings&gt; &lt;add name=&#8221;conns&#8221; connectionString=&#8221;Data Source=.\\SQLEXPRESS;Initial Catalog=YourDatabaseName;Integrated Security=True&#8221; providerName=&#8221;System.Data.SqlClient&#8221; \/&gt; &lt;\/connectionStrings&gt; \ud83d\udccc Replace YourDatabaseName with your actual DB name. \ud83d\udd39 3. Update Your Login Page Code Replace the&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[52,35],"tags":[],"class_list":["post-12400","post","type-post","status-publish","format-standard","hentry","category-asp-net","category-programming-basics"],"rttpg_featured_image_url":null,"rttpg_author":{"display_name":"admin","author_link":"https:\/\/guidance24.in\/?author=1"},"rttpg_comment":6,"rttpg_category":"<a href=\"https:\/\/guidance24.in\/?cat=52\" rel=\"category\">ASP.NET<\/a> <a href=\"https:\/\/guidance24.in\/?cat=35\" rel=\"category\">Programming Basics<\/a>","rttpg_excerpt":"\u2705 Step-by-Step: Login with SQL Server Database \ud83d\udd39 1. Create a Database Table In SQL Server, create a table to store login credentials: sqlCopyEditCREATE TABLE AdminLogin ( ID INT PRIMARY KEY IDENTITY, Username NVARCHAR(50), Password NVARCHAR(50) -- In real apps, use hashed passwords ); \ud83d\udccc Insert a sample record: sqlCopyEditINSERT INTO AdminLogin (Username, Password) VALUES&hellip;","_links":{"self":[{"href":"https:\/\/guidance24.in\/index.php?rest_route=\/wp\/v2\/posts\/12400","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/guidance24.in\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/guidance24.in\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/guidance24.in\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/guidance24.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12400"}],"version-history":[{"count":1,"href":"https:\/\/guidance24.in\/index.php?rest_route=\/wp\/v2\/posts\/12400\/revisions"}],"predecessor-version":[{"id":12401,"href":"https:\/\/guidance24.in\/index.php?rest_route=\/wp\/v2\/posts\/12400\/revisions\/12401"}],"wp:attachment":[{"href":"https:\/\/guidance24.in\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12400"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/guidance24.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12400"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/guidance24.in\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}