How to make connection String from MS Access database in asp.net
I am using following code
protected void btnAccessDataBase_Click(object sender, EventArgs e)
{
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\Mahendra\Student.mdb; User id=admin;Password=password;";
string sqlqry = "Insert into tblStudent(FirstName,LastName)Values('" + txtFirstName.Text + "','" + txtLastName.Text + "')";
OleDbCommand cmd = new OleDbCommand(sqlqry, conn);
conn.Open();
int a = cmd.ExecuteNonQuery();
conn.Close();
if (a > 0)
{
}
}
{
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\Mahendra\Student.mdb; User id=admin;Password=password;";
string sqlqry = "Insert into tblStudent(FirstName,LastName)Values('" + txtFirstName.Text + "','" + txtLastName.Text + "')";
OleDbCommand cmd = new OleDbCommand(sqlqry, conn);
conn.Open();
int a = cmd.ExecuteNonQuery();
conn.Close();
if (a > 0)
{
}
}
What is going on here?
Thanks,
--Mahendra
Thanks,
--Mahendra

Mahendra KumarPosted Sep 30, 2018, 10:51 PM
stephen howardPosted Jan 9, 2018, 6:36 PM
Laxmidhar SahooPosted Jan 5, 2018, 2:19 AM
Mahendra KumarPosted Jan 4, 2018, 1:59 AM
Laxmidhar SahooPosted Jan 4, 2018, 1:11 AM