Add Edit Delete In Access Using ASP.NET

Utils Class:

public static string GetConnString()

{

  return WebConfigurationManager.ConnectionStrings["myConnStr"].ConnectionString;

}

INSERT

string ConnString = Utils.GetConnString();

string SqlString = "Insert Into Contacts (FirstName, LastName) Values (?,?)";

using (OleDbConnection conn = new OleDbConnection(ConnString))

{

  using (OleDbCommand cmd = new OleDbCommand(SqlString, conn))

  {

    cmd.CommandType = CommandType.Text;

    cmd.Parameters.AddWithValue("FirstName", txtFirstName.Text);

    cmd.Parameters.AddWithValue("LastName", txtLastName.Text);

    conn.Open();

    cmd.ExecuteNonQuery();

  }

}

UPDATE

string ConnString = Utils.GetConnString();

string SqlString = "Update Contacts Set FirstName = ?, LastName = ?";

using (OleDbConnection conn = new OleDbConnection(ConnString))

{

  using (OleDbCommand cmd = new OleDbCommand(SqlString, conn))

  {

    cmd.CommandType = CommandType.Text;

    cmd.Parameters.AddWithValue("FirstName", txtFirstName.Text);

    cmd.Parameters.AddWithValue("LastName", txtLastName.Text);

    conn.Open();

    cmd.ExecuteNonQuery();

  }

}

DELETE

string ConnString = Utils.GetConnString();

string SqlString = "Delete * From Contacts Where FirstName = ? And LastName = ?";

using (OleDbConnection conn = new OleDbConnection(ConnString))

{

  using (OleDbCommand cmd = new OleDbCommand(SqlString, conn))

  {

    cmd.CommandType = CommandType.Text;

    cmd.Parameters.AddWithValue("FirstName", txtFirstName.Text);

    cmd.Parameters.AddWithValue("LastName", txtLastName.Text);

    conn.Open();

    cmd.ExecuteNonQuery();

  }

}

SELECT

string ConnString = Utils.GetConnString();

string SqlString = "Select * From Contacts Where FirstName = ? And LastName = ?";

using (OleDbConnection conn = new OleDbConnection(ConnString))

{

  using (OleDbCommand cmd = new OleDbCommand(SqlString, conn))

  {

    cmd.CommandType = CommandType.Text;

    cmd.Parameters.AddWithValue("FirstName", txtFirstName.Text);

    cmd.Parameters.AddWithValue("LastName", txtLastName.Text);

    conn.Open();

    using (OleDbDataReader reader = cmd.ExecuteReader())

    {

      while (reader.Read())

      {

        Response.Write(reader["FirstName"].ToString() + " " + reader["LastName"].ToString());

      }

    }

  }

}

Store Procedure

string ConnString = Utils.GetConnString();

string SqlString = "AddContact";

using (OleDbConnection conn = new OleDbConnection(ConnString))

{

  using (OleDbCommand cmd = new OleDbCommand(SqlString, conn))

  {

    cmd.CommandType = CommandType.StoredProcedure;

    cmd.Parameters.AddWithValue("FirstName", txtFirstName.Text);

    cmd.Parameters.AddWithValue("LastName", txtLastName.Text);

    conn.Open();

    cmd.ExecuteNonQuery();

  }

}