ADO.NET基础

最新推荐文章于 2024-10-22 16:53:35 发布

lchj007

最新推荐文章于 2024-10-22 16:53:35 发布

阅读量619

点赞数

分类专栏： .NET 2.0 平台文章标签： security 数据库 dataset cmd user

本文链接：https://blog.csdn.net/lchj007/article/details/1706901

版权

.NET 2.0 平台专栏收录该内容

12 篇文章 0 订阅

订阅专栏

新建数据库连接：
conn = new SqlConnection();
conn.ConnectionString = "Data Source=.//SQLEXPRESS;AttachDbFilename=|DataDirectory|//SQLDemo.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
conn.Open();
conn.Close();

用sqlDataadapter读取数据库：
conn = new SqlConnection();
conn.ConnectionString = "Data Source=.//SQLEXPRESS;AttachDbFilename=|DataDirectory|//SQLDemo.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";

cmd = new SqlCommand("select * from student",conn);
adpter = new SqlDataAdapter(cmd);

bulit = new SqlCommandBuilder(adpter);　
//可以使用sqldataadpter更新数据库　this.adpter.Update(this.ds, "locStd");

ds = new DataSet();
adpter.Fill(ds, "locStd");

this.dataGridView1.DataSource = ds.Tables["locStd"];

用sqlDataReader读取数据库：

            conn = new SqlConnection();
            conn.ConnectionString = "Data Source=.//SQLEXPRESS;AttachDbFilename=|DataDirectory|//SQLDemo.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
            conn.Open();

            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = "select * from student";
            SqlDataReader reader = cmd.ExecuteReader();

            while(reader.Read())
            {
                this.listBox1.Items.Add(reader[0].ToString() + "," + reader["name"].ToString() + " ," + reader["age"].ToString()
                    + "," + reader["city"].ToString() );
            }
            reader.Close();
            conn.Close();

使用sqlcommand更新数据库：
   conn = new SqlConnection();
            conn.ConnectionString = "Data Source=.//SQLEXPRESS;AttachDbFilename=|DataDirectory|//SQLDemo.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
            conn.Open();

            cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = "Update student set city = 'beijing'where id = @id" ;
            SqlParameter id = new SqlParameter(id,SqlDbType.Int);
            id.Value = Convert.ToInt32(this.textBox1.Text);

cmd.ExecuteNonQuery();
conn.Close();