How do i access individual cell records in database in access, for my login form as part of my project

Question

i am developing a system that requires that i access the rows of data in my access 2007 database(already saved user name and password) and compare it with data in a text box(txtUsername and txtPassword) to check and see if they are the same.
Thank you!

Satyapriya Nayak · Answer

Hi Bless, Perhaves you need to create a login page. Here is the code for windows application. using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace Login_page_Msaccess { public partial class Form1 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"]; OleDbCommand com; string str; object obj = null; public Form1() { InitializeComponent(); } private void btn_login_Click(object sender, EventArgs e) { OleDbConnection con = new OleDbConnection(ConnectionString); 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(); } } } Here is the code for web application. Untitled Page Width="100px" BackColor="#FFFF66" ForeColor="#FF3300"> Width="100px" BackColor="#FFFF66" ForeColor="#FF3300"> TextMode="Password" Width="100px"> BackColor="#CCFF99" onclick="btn_login_Click" /> 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.SqlClient; namespace login_using_parameter { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; string str = null; SqlCommand com; protected void btn_login_Click(object sender, EventArgs e) { object obj = null; SqlConnection con = new SqlConnection(strConnString); con.Open(); str = "select count(*) from login where UserName=@UserName and Password =@Password"; com = new SqlCommand(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(); } } } Thanks

How do i access individual cell records in database in access, for my login form as part of my project

Answers (1)