B bla Mar 20, 2007 #1 How to connect to database in .NET 3.0 There is no binding source and datasets in toolbox.
H HackerisNewKnight Mar 20, 2007 #2 Hi, maybe this hepls you: OleDbConnection connection = new OleDbConnection(); connection.ConnectionString = connectionString; connection.Open(); OleDbCommand cmd = new OleDbCommand(); String query; query = "select * from typetable"; cmd.CommandText = query; cmd.Connection = connection; cmd.ExecuteNonQuery(); OleDbDataReader rdr = cmd.ExecuteReader(); //Keep reading records in the forward direction while (rdr.Read()) { MessageBox(rdr[1].ToString()); }
Hi, maybe this hepls you: OleDbConnection connection = new OleDbConnection(); connection.ConnectionString = connectionString; connection.Open(); OleDbCommand cmd = new OleDbCommand(); String query; query = "select * from typetable"; cmd.CommandText = query; cmd.Connection = connection; cmd.ExecuteNonQuery(); OleDbDataReader rdr = cmd.ExecuteReader(); //Keep reading records in the forward direction while (rdr.Read()) { MessageBox(rdr[1].ToString()); }
R RobinS Mar 23, 2007 #3 Create them in code. BindingSource myBindingSource = new BindingSource(); Robin S.