DataSet Delete : DataSet : Database C# Source Code

DataSet Delete

    


using System;
using System.Collections.Generic;
using System.Text;

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

class Program {
    static void Main(string[] args) {
        DataSet theCarsInventory = new DataSet();
        SqlConnection cn = new SqlConnection("server=(local);User ID=sa;Pwd=;database=Cars");
        SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM Inventory", cn);
        SqlCommandBuilder invBuilder = new SqlCommandBuilder(da);
        da.Fill(theCarsInventory, "Inventory");
        PrintDataSet(theCarsInventory);
        try {
            theCarsInventory.Tables["Inventory"].Rows[1].Delete();
            da.Update(theCarsInventory, "Inventory");
        } catch (Exception e) {
            Console.WriteLine(e.Message);
        }
        theCarsInventory = new DataSet();
        da.Fill(theCarsInventory, "Inventory");
        PrintDataSet(theCarsInventory);
    }
    static void PrintDataSet(DataSet ds) {
        Console.WriteLine("Tables in '{0}' DataSet.\n", ds.DataSetName);
        foreach (DataTable dt in ds.Tables) {
            Console.WriteLine("{0} Table.\n", dt.TableName);
            for (int curCol = 0; curCol < dt.Columns.Count; curCol++) {
                Console.Write(dt.Columns[curCol].ColumnName.Trim() + "\t");
            }
            for (int curRow = 0; curRow < dt.Rows.Count; curRow++) {
                for (int curCol = 0; curCol < dt.Columns.Count; curCol++) {
                    Console.Write(dt.Rows[curRow][curCol].ToString().Trim() + "\t");
                }
                Console.WriteLine();
            }
        }
    }
}


           
       
    
   
  
   

Related in same category :
• Print DataSet out
• Finding Data
• How to perform a SELECT statement and store the returned rows in a DataSet object
• Populate a DataSet object using a SELECT statement
• Populate a DataSet object with multiple DataTable objects
• Populate a DataSet with multiple DataTable objects using multiple SELECT statements
• Use the Merge() method
• For each row in DataSet, reference the column data by column name
• DataSet Read
• ReadXml
• Open the XML file and read into a DataSet
• Populate a DataSet object with a range of rows from a SELECT statement
• Using Datasets
• Using Multi Tabled Datasets
• Read data from DataSet