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

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.


<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="login_using_parameter._Default" %>





 


 

 

 

    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