ADO.NET数据访问(2) 查询数据
来源:互联网 发布:和知聊差不多的软件 编辑:程序博客网 时间:2024/05/02 04:34
一:使用DataReader读取数据
private void button1_Click(object sender, EventArgs e) { string s = "server=.;database=SampleDb;integrated security=true;"; SqlConnection conn = new SqlConnection(s); SqlCommand cmd = new SqlCommand(); string sql = "select * from student"; cmd.CommandText = sql; cmd.Connection = conn; conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); string id, name, gender, major; int grade, cls; object o; while (reader.Read()) { o = reader["id"]; id=(string) o; name = (string)reader["name"]; gender = (string)reader["gender"]; major = (string)reader["major"]; grade = (int)reader["grade"]; cls = (int)reader["class"]; string temp=string.Format("{0}\t{1}\t{2}\t{3}\t{4}\t{5}\n", id, name, gender, major, grade, cls); textBox1.AppendText(temp); } reader.Close(); conn.Close(); }
二:使用综合条件查询,grade和gender两个条件查询。
private void button4_Click(object sender, EventArgs e) { textBox1.Text = ""; string s = "server=.;database=SampleDb;integrated security=true;"; SqlConnection conn = new SqlConnection(s); SqlCommand cmd = new SqlCommand(); string sql = "select * from student "; string where = " where 1=1 "; if (textBox2.Text != "") where = where + " and grade=" + textBox2.Text; if (textBox3.Text != "") where = where + " and gender='" + textBox3.Text + "'";//字符串需加引号 sql = sql + where; cmd.CommandText = sql; cmd.Connection = conn; conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); string id, name, gender, major; int grade, cls; object o; while (reader.Read()) { o = reader["id"]; id = (string)o; name = (string)reader["name"]; gender = (string)reader["gender"]; major = (string)reader["major"]; grade = (int)reader["grade"]; cls = (int)reader["class"]; string temp = string.Format("{0}\t{1}\t{2}\t{3}\t{4}\t{5}\n", id, name, gender, major, grade, cls); textBox1.AppendText(temp); } reader.Close(); conn.Close();
三:使用.DataGridView显示数据
显示或查询
private void button1_Click(object sender, EventArgs e) { string s = "server=.;database=SampleDb;integrated security=true;"; SqlConnection conn = new SqlConnection(); conn.ConnectionString = s; ds = new DataSet(); adapter = new SqlDataAdapter("select * from student",conn); adapter.Fill(ds); grid.DataSource = ds.Tables[0]; }
保存
private void button2_Click(object sender, EventArgs e) { SqlCommandBuilder builder = new SqlCommandBuilder(adapter); adapter.Update(ds); MessageBox.Show("保存成功!"); }
- ADO.NET数据访问(2) 查询数据
- ADO.NET数据访问
- ADO.NET 数据访问
- ADO.NET 数据访问介绍
- ADO.NET数据访问技术
- ADO.NET数据访问对象
- 数据访问与ADO.NET
- ADO.NET数据访问技术
- ADO.NET 数据连接查询
- ADO.NET查询表数据
- ADO.NET数据查询方法
- ADO.NET实现应用程序数据访问层2
- ADO.NET数据访问基础(读书笔记)
- ADO.NET 数据库访问之数据分页
- 第九讲 ADO.NET数据访问技术
- ADO.NET中的数据访问--强类型
- ADO.NET数据访问的流程
- ADO.NET 连接方式进行数据访问
- Lua基础 小结(两个Lua程序示例)
- Socket 长连接与短连接,心跳
- NSXMLParser类解析xml
- 动态加载 dll 枚举所有进程
- jquery.ztree
- ADO.NET数据访问(2) 查询数据
- Java基础复习:面向对象练习1
- static用法小结
- java向oracle插入blob类型图片
- NSXMLParser类解析xml--2
- 用LUA写的绘图函数
- 子弹接触边界反弹功能
- 音频编解码speex库的使用方法
- 8年苦恋阿里终弃中国雅虎