Csharp/C Sharp by API/System.Data.SqlClient/SqlCommandBuilder

new SqlCommandBuilder

 


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");
        }
    }