Csharp/C Sharp by API/System.Data/DataTable

DataTable.Columns

<source lang="csharp"> using System; using System.Data; using System.Data.SqlClient; class PopDataset {

  static void Main()
  {
     string connString = "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI";
     string sql = @"select * from employee";
     SqlConnection conn = new SqlConnection(connString);
     try
     {
        conn.Open();
        SqlDataAdapter da = new SqlDataAdapter(sql, conn);
        DataSet ds = new DataSet();    
        da.Fill(ds, "employee");
        DataTable dt = ds.Tables["employee"];
        foreach (DataRow row in dt.Rows)
        {
           foreach (DataColumn col in dt.Columns)
              Console.WriteLine(row[col]);
           Console.WriteLine("".PadLeft(20, "="));
        }
     }
     catch(Exception e)
     {
        Console.WriteLine("Error: " + e);
     }
     finally
     {
        conn.Close();
     }
  }  

}

 </source>

DataTable.Columns.Add

<source lang="csharp">

using System; using System.Data; using System.Data.SqlClient;

   public class CreatingDataTablesandPopulatingThem
   {
       static void Main(string[] args)
       {
           SqlConnection MyConnection = new SqlConnection(@"Data Source=(local); Initial Catalog = CaseManager; Integrated Security=true");
           SqlDataAdapter MyAdapter = new SqlDataAdapter("SELECT * FROM CaseInfo", MyConnection);
           DataSet MyDataSet = new DataSet();
           //Create a new DataTable
           DataTable MyTable2 = MyDataSet.Tables.Add("My2ndTable");
           //Adding Columns and Rows
           DataColumn myColumn = new DataColumn();
           myColumn.DataType = System.Type.GetType("System.Decimal");
           myColumn.AllowDBNull = false;
           myColumn.Caption = "Price";
           myColumn.ColumnName = "Price";
           myColumn.DefaultValue = 25;
           // Add the column to the table. 
           MyTable2.Columns.Add(myColumn);
           // Add 10 rows and set values. 
           DataRow myRow;
           for (int i = 0; i < 10; i++)
           {
               myRow = MyTable2.NewRow();
               myRow[0] = i + 1;
               // Be sure to add the new row to the DataRowCollection. 
               MyTable2.Rows.Add(myRow);
           }
           SqlCommandBuilder Builder = new SqlCommandBuilder(MyAdapter);
           MyAdapter.Update(MyDataSet, "My2ndTable");
       }
   }
  
   
 </source>

DataTable.MinimumCapacity

<source lang="csharp"> using System; using System.Drawing; using System.Collections; using System.Data; using System.ruponentModel; using System.Windows.Forms; public class GridBind : System.Windows.Forms.Form {

   private System.Windows.Forms.DataGrid dataGrid1 = new System.Windows.Forms.DataGrid ();
   private DataSet dataset = new DataSet("ContactData");
   public GridBind()
   {
       dataGrid1.BeginInit ();
       dataGrid1.Location = new System.Drawing.Point (8, 16);
       dataGrid1.Size = new System.Drawing.Size (472, 224);
       dataGrid1.DataMember = "";
       this.AutoScaleBaseSize = new System.Drawing.Size (5, 13);
       this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.Fixed3D;
       this.ClientSize = new System.Drawing.Size (486, 251);
       this.Controls.Add (this.dataGrid1);
       dataGrid1.EndInit ();
       DataTable t=new DataTable("Contacts");
       t.Columns.Add("First",typeof(System.String));
       t.Columns.Add("Name",typeof(System.String));
       t.Columns.Add("Company",typeof(System.String));
       t.Columns.Add("Title",typeof(System.String));
       t.Columns.Add("Phone",typeof(System.String));
       t.MinimumCapacity=100;
       dataset.Tables.Add(t);
       this.dataGrid1.SetDataBinding(dataset.Tables["Contacts"],"");
   }
   static void Main()
   {
       Application.Run(new GridBind());
   }

}

 </source>

DataTable.NewRow()

<source lang="csharp">

using System; using System.Data; using System.Data.SqlClient;

   public class CreatingDataTablesandPopulatingThem
   {
       static void Main(string[] args)
       {
           SqlConnection MyConnection = new SqlConnection(@"Data Source=(local); Initial Catalog = CaseManager; Integrated Security=true");
           SqlDataAdapter MyAdapter = new SqlDataAdapter("SELECT * FROM CaseInfo", MyConnection);
           DataSet MyDataSet = new DataSet();
           //Create a new DataTable
           DataTable MyTable2 = MyDataSet.Tables.Add("My2ndTable");
           //Adding Columns and Rows
           DataColumn myColumn = new DataColumn();
           myColumn.DataType = System.Type.GetType("System.Decimal");
           myColumn.AllowDBNull = false;
           myColumn.Caption = "Price";
           myColumn.ColumnName = "Price";
           myColumn.DefaultValue = 25;
           // Add the column to the table. 
           MyTable2.Columns.Add(myColumn);
           // Add 10 rows and set values. 
           DataRow myRow;
           for (int i = 0; i < 10; i++)
           {
               myRow = MyTable2.NewRow();
               myRow[0] = i + 1;
               // Be sure to add the new row to the DataRowCollection. 
               MyTable2.Rows.Add(myRow);
           }
           SqlCommandBuilder Builder = new SqlCommandBuilder(MyAdapter);
           MyAdapter.Update(MyDataSet, "My2ndTable");
       }
   }
  
   
 </source>

DataTable.Rows

<source lang="csharp"> using System; using System.IO; using System.Data; public class MainClass {

   static void Main(string[] args) {
       if (args.Length != 1)
           return;
       FileStream fs = new FileStream(args[0], FileMode.Open);
       DataSet ds = new DataSet();
       ds.ReadXml(fs);
       // Use a DataTable to display the members.
       DataTable mt = ds.Tables["member"];
       for (int row = 0; row < mt.Rows.Count; row++) {
           for (int col = 0; col < mt.Columns.Count - 1; col++) {
               Console.WriteLine("{0,-10}{1}",
                   mt.Columns[col].Caption,
                   mt.Rows[row][col].ToString().Trim());
           }
           Console.WriteLine();
       }
       fs.Close();
   }

}

 </source>

DataTable.Rows.Add

<source lang="csharp">

using System; using System.Data; using System.Data.SqlClient;

   public class CreatingDataTablesandPopulatingThem
   {
       static void Main(string[] args)
       {
           SqlConnection MyConnection = new SqlConnection(@"Data Source=(local); Initial Catalog = CaseManager; Integrated Security=true");
           SqlDataAdapter MyAdapter = new SqlDataAdapter("SELECT * FROM CaseInfo", MyConnection);
           DataSet MyDataSet = new DataSet();
           //Create a new DataTable
           DataTable MyTable2 = MyDataSet.Tables.Add("My2ndTable");
           //Adding Columns and Rows
           DataColumn myColumn = new DataColumn();
           myColumn.DataType = System.Type.GetType("System.Decimal");
           myColumn.AllowDBNull = false;
           myColumn.Caption = "Price";
           myColumn.ColumnName = "Price";
           myColumn.DefaultValue = 25;
           // Add the column to the table. 
           MyTable2.Columns.Add(myColumn);
           // Add 10 rows and set values. 
           DataRow myRow;
           for (int i = 0; i < 10; i++)
           {
               myRow = MyTable2.NewRow();
               myRow[0] = i + 1;
               // Be sure to add the new row to the DataRowCollection. 
               MyTable2.Rows.Add(myRow);
           }
           SqlCommandBuilder Builder = new SqlCommandBuilder(MyAdapter);
           MyAdapter.Update(MyDataSet, "My2ndTable");
       }
   }
  
   
 </source>