求Microsoft Visual Studio 2008和SQL数据库连接的教程

Question

如题所述

Answer 1

通用的方式有以下几种: 1. Connection + Command + DataAdapter + DataSet 2. Connection + DataAdapter + DataSet 3. Connection + Command + DataReader 二、 Connection + Command + DataAdapter + DataSet详解 1. Connection介绍 Open() Close() Dispose() ConnectionString 构造函数() SqlConnection conn = new SqlConnection(); conn.ConnectionString = "server=KEVIN-LI;database=ADONET;uid=admin;pwd=123456"; conn.Open(); conn.Close(); conn.Dispose(); 2. Command介绍 Dispose() CommandText 构造函数() SqlConnection conn = new SqlConnection(); conn.ConnectionString = "server=KEVIN-LI;database=ADONET;uid=admin;pwd=123456"; //打开连接 conn.Open(); //执行命令 SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; string sql = "select * from 销售记录表"; cmd.CommandText = sql; SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { dr.Read(); dr.Read(); MessageBox.Show(dr.GetString(1)); } conn.Close(); conn.Dispose(); 3. DataAdapter介绍 Dispose() Fill() 构造函数() 4. DataSet介绍 5. 综合应用 SqlConnection conn = new SqlConnection(); conn.ConnectionString = "server=172.16.32.200;database=ADONET;uid=admin;pwd=123456"; conn.Open(); MessageBox.Show("已经连接到服务器"); SqlCommand cmd = new SqlCommand(); //建立桥梁关系 cmd.Connection = conn; //设置命令内容 cmd.CommandText = "select * from 销售记录表"; //创建适配器 SqlDataAdapter apt = new SqlDataAdapter(); //建立桥梁关系 apt.SelectCommand = cmd; DataSet ds = new DataSet(); //填充数据 apt.Fill(ds); //绑定数据 dataGridView1.DataSource = ds.Tables[0]; ds.Dispose(); apt.Dispose(); cmd.Dispose(); conn.Dispose();