• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Database Connectivity with C#.NET using ADO.NET

Database Connectivity with C#.NET using ADO.NET

Database Connectivity with C#.NET using ADO.NET

Rate Database Connectivity with C#.NET using ADO.NET

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

		{
			//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 ();
		}