What is the problem in connection string of my program?

Question

What is the problem of connection string that can not connect to the access database please,Guide me. public DataTable ShowData(string s1) { OleDbConnection CN = new OleDbConnection(); CN.ConnectionString = 'provider = microsoft.Ace.oledb.12.0; Data source = D:\Database 10.accdb'; CN.Open(); OleDbCommand CMT = new OleDbCommand(s1, CN); OleDbDataReader da = CMT.ExecuteReader(); DataTable DT = new DataTable(); DT.Load(da); CN.Close(); return DT; }

Akhil Mittal · Answer

Provide user id and password if your db requires so.

Joe Wilson · Answer

I changed the folder of connection string but it didn't solved. by the way , I want to use this code to administration form to confirm user name and password so are you sure your code can be used instead of my code.

Joe Wilson · Answer

I don't get what your answer was about.

Joe Wilson · Answer

Compiler can't access to the access database Does it any problem in my connection string.

Joe Wilson · Answer

This is my code of user id and password code in other windows form. private void Acceptbtn_Click(object sender, EventArgs e) { Connection.connectionString = @"provider = microsoft.Ace.oledb.12.0; Data source = D:\Database 10.accdb"; Connection d1 = new Connection(); bool b = d1.IsExist("select * from Administration where Student_Number = '" + textBox3.Text + "' and Student_ID = '" + textBox2.Text + "'"); if (b) { this.Hide(); Form1 m1 = new Form1(); m1.ShowDialog(); } else lblInfo.Text = "Not Exist !"; }

Shweta Lodha · Answer

What error are you getting ?

Sunny Shaikh · Answer

private void Form1_Load(object sender, EventArgs e) { string cString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Database10.accdb; Persist Security Info=False;"; using (OleDbConnection cn = new OleDbConnection(cString)) { OleDbDataAdapter da = new OleDbDataAdapter("select * from Administration", cn); DataTable dt = new DataTable(); da.Fill(dt); cn.Open(); dataGridView1.DataSource = dt; } } other wise you insert your "accdb" file in a folder and change your connection string. D:\New folder\Database10.accdb

Sagar Pardeshi · Answer

web.config ;Initial Catalog=xyz;Persist Security Info=True;User ID= ;Password= ;" /> login.aspx string connStr = ConfigurationManager.ConnectionStrings["xyz"].ToString(); OleDbConnection conn = new OleDbConnection(connStr); conn.Open();

What is the problem in connection string of my program?

Answers (8)