Database connectivity in asp.net with MS Access using C#

Question

Hi I am trying to create a login form in asp.net using MS access and C# code. Guide me in knowing the steps to solve the problem. kritika Rana

Satyapriya Nayak · Answer

http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd "> http://www.w3.org/1999/xhtml " > Untitled Page function Validate() { var UName=document.getElementById('TextBox_user_name'); var Password=document.getElementById('TextBox_password'); if((UName.value=='') || (Password.value=='')) { alert('UserName or Password should not be blank'); return false; } else { return true; } } using System; using System.Collections; 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.OleDb; namespace Connect_Msaccess_in_asp.net { public partial class WebForm4 : System.Web.UI.Page { OleDbConnection con; OleDbCommand com; string str; object obj; protected void btn_login_Click(object sender, EventArgs e) { con = new OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0; Data Source = D:\emp.mdb"); //con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\emp.accdb"); con.Open(); str = "select count(*) from login where UserName=@UserName and Password =@Password "; com = new OleDbCommand(str, con); com.CommandType = CommandType.Text; com.Parameters.AddWithValue("@UserName", TextBox_user_name.Text); com.Parameters.AddWithValue("@Password", TextBox_password.Text); obj = com.ExecuteScalar(); if ((int)(obj) != 0) { lb1.Text = "WELLCOME :: " + TextBox_user_name.Text; } else { lb1.Text = "Invalid user name and password"; } con.Close(); } } }