Mega Code Archive

 

Categories / C# / ADO Database

 

Finding Data

using System; using System.Data; using System.Data.SqlClient;  using System.Collections.Generic; using System.Text; class Program {     static void Main(string[] args) {         SqlConnection thisConnection = new SqlConnection(              @"Server=(local)\sqlexpress;Integrated Security=True;" +              "Database=northwind");         SqlDataAdapter thisAdapter = new SqlDataAdapter("SELECT CustomerID, CompanyName FROM Customers", thisConnection);         SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter);         DataSet thisDataSet = new DataSet();         thisAdapter.Fill(thisDataSet, "Customers");         Console.WriteLine("# rows before change: {0}",thisDataSet.Tables["Customers"].Rows.Count);         DataColumn[] keys = new DataColumn[1];         keys[0] = thisDataSet.Tables["Customers"].Columns["CustomerID"];         thisDataSet.Tables["Customers"].PrimaryKey = keys;         DataRow findRow = thisDataSet.Tables["Customers"].Rows.Find("AAA");         if (findRow == null) {             DataRow thisRow = thisDataSet.Tables["Customers"].NewRow();             thisRow["CustomerID"] = "AAA";             thisRow["CompanyName"] = "AAA Ltd.";             thisDataSet.Tables["Customers"].Rows.Add(thisRow);             if ((findRow = thisDataSet.Tables["Customers"].Rows.Find("AAA")) != null) {                 Console.WriteLine("added");             }         } else {             Console.WriteLine("AAA already present in database");         }         thisAdapter.Update(thisDataSet, "Customers");         Console.WriteLine("# rows after change: {0}",thisDataSet.Tables["Customers"].Rows.Count);         thisConnection.Close();     } }