by Aamir Rashid & Humayun Ather Siddiqui (1 Submission)
Category: Databases/Data Access/DAO/ADO
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Tue 8th July 2003
Date Added: Mon 8th February 2021
Rating: 
(1 Votes)
Database Connectivity with C#.NET using ADO.NET
VBcoders
{
//Connection - Command - Adapter - Dataset
string ConStr = "Provider=Microsoft.Jet.OleDB.4.0; Data Source = e:\\vs\\WindowsApplication3\\Employee.mdb";
OleDbConnection Conn = new OleDbConnection(ConStr);
Conn.Open ();
OleDbCommand Cmd = new OleDbCommand("Select * from Users",Conn);
OleDbDataAdapter dAdapter = new OleDbDataAdapter(Cmd);
DataSet dDataSet = new DataSet();
dAdapter.Fill(dDataSet, "User Information");
dataGrid1.DataSource = dDataSet;
//Adding aditional table to Dataset
Cmd.CommandText = "Select * from Table1";
dAdapter.Fill(dDataSet, "Table1 Information");
dataGrid1.DataSource = dDataSet;
// Working with Each Row of a Table in Dataset
foreach(DataRow row in dDataSet.Tables["Table1 Information"].Rows)
listBox1.Items.Add (row[0]);
// Adding new Table in Dataset
DataTable NewTable = new DataTable("MyNewTable");
NewTable.Columns.Add (new DataColumn("Field1", typeof(int)));
NewTable.Columns.Add (new DataColumn("Field2", typeof(string)));
dDataSet.Tables.Add (NewTable);
// Adding New Records
// Method 1
DataRow AddNewRow = dDataSet.Tables["MyNewTable"].NewRow ();
AddNewRow["Field1"] = 999;
AddNewRow["Field2"]="Test";
dDataSet.Tables["MyNewTable"].Rows.Add(AddNewRow);
// Method 2
DataRow AddNewRow1 = dDataSet.Tables["MyNewTable"].Rows.Add (new Object [] {999, "test"});
// Update Database
//dAdapter.Update(dDataSet, "MyNewTable");
// Closing Connection
Conn.Close ();
}
