Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
5
Reply
How to make connection String from MS Access database
Mahendra Kumar
Jan 4 2018 12:00 AM
115
Reply
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)
{
}
}
What is going on here?
Thanks,
--Mahendra
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
5
)
Next Recommended Forum
how to search data from to db using start and and date in as
Dropdownlist in childgrid is not getting fired its event