I just downloaded and installed C sharp for 2010
The connection to the database via the DataAdapter and then to the DataSet does not work. I am trying to tie the db to the textboxs on the form and then navigate the db with buttons like next prev etc.
System.Data.SqlClient.SqlConnection con; DataSet ds1; private void Form1XXXLoad(object sender, EventArgs e) con = new System.Data.SqlClient.SqlConnection(); con.ConnectionString = "Data Source=.\\SQLEXPRESS; AttachDBFilename=C:\\MyWorkers.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"; con.Open(); MessageBox.Show("Database Open"); con.Close(); MessageBox.Show("Database Closed"); con.Dispose(); string sql = "SELECT * From tblFriends"; da = new System.DataSqlClient.SqlDataAdapter(sql, con);
it just does not work, I am not looking for anyone to fix the code, JUST point out some place on the net I can get a GOOD idea about how to implement my objective. Thanks