蜗牛—C#程设之DataAdapter对象

来源：互联网发布：cocos2d x js 编辑：程序博客网时间：2024/06/16 09:09

使用DataAdapter和DataSet来读取数据表JBQK中的数据

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.SqlClient;using System.Data;namespace shiyan11{    class Program    {        static void Main(string[] args)        {            string strCon = @"Data Source = .\SQLEXPRESS;Initial Catalog=TestDB;Integrated Security=True;";            SqlConnection sqlCon = new SqlConnection(strCon);            try            {                sqlCon.Open();                string sqlStr = @"select No,Name,Grade from JBQK";                SqlCommand sqlCmd = new SqlCommand(sqlStr, sqlCon);                SqlDataAdapter sda = new SqlDataAdapter(sqlCmd);                  DataSet ds = new DataSet();                sda.Fill(ds);    //填充数据集,实质是填充ds中的第0个表                string sltResult = "";                DataTable dt = ds.Tables[0];                Console.WriteLine("基本情况数据表查询结果如下:");                for (int i = 0; i < dt.Rows.Count;i++ ) {                    //逐行读取，每行通过字段名或者索引来访问                       sltResult += "第" + (i + 1) + "记录：" + dt.Rows[i][0].ToString() + "\t"                         + dt.Rows[i]["Name"].ToString() + dt.Rows[i][2].ToString() + "\n";                }                Console.WriteLine(sltResult);            }            catch (Exception e)             {                Console.WriteLine("失败！！");            }            sqlCon.Close();            Console.Read();                                }    }}

删除JBQK表中的第一条数据

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.SqlClient;using System.Data;namespace shiyan11{    class Program    {        static void Main(string[] args)        {            string strCon = @"Data Source = .\SQLEXPRESS;Initial Catalog=TestDB;Integrated Security=True;";            SqlConnection sqlCon = new SqlConnection(strCon);            try            {                sqlCon.Open();                string sqlStr = @"select No,Name,Grade from JBQK";                SqlCommand sqlCmd = new SqlCommand(sqlStr, sqlCon);                SqlDataAdapter sda = new SqlDataAdapter(sqlCmd);                  DataSet ds = new DataSet();                sda.Fill(ds);    //填充数据集,实质是填充ds中的第0个表                string sltResult = "";                                //----------------------------------------------                //以sda为参数来初始化SqlCommandBuilder实力                SqlCommandBuilder scb = new SqlCommandBuilder(sda);                //删除DataSet中数据表JBQK中的第一行数据                ds.Tables[0].Rows[0].Delete();                //调用Update方法,以DataSet中的数据更新数据库                sda.Update(ds, ds.Tables[0].ToString());                ds.Tables[0].AcceptChanges();                //----------------------------------------------                DataTable dt = ds.Tables[0];                Console.WriteLine("基本情况数据表查询结果如下:");                for (int i = 0; i < dt.Rows.Count;i++ ) {                    //逐行读取，每行通过字段名或者索引来访问                       sltResult += "第" + (i + 1) + "记录：" + dt.Rows[i][0].ToString() + "\t"                         + dt.Rows[i]["Name"].ToString() + dt.Rows[i][2].ToString() + "\n";                }                Console.WriteLine(sltResult);            }            catch (Exception e)             {                Console.WriteLine(e.ToString());            }            sqlCon.Close();            Console.Read();                                }    }}

0 0