DataReader方法详解
来源:互联网 发布:wifi没有可切换的网络 编辑:程序博客网 时间:2024/06/14 22:09
以下内容演示DataReader的各项操作:
using System;
using System.Data;
using System.Data.SqlClient;
using System.Data;
using System.Data.SqlClient;
//建立Sql连接
//可以将连接字符串定义为const,以便测试
string strConn=@"server=suo/sqlexpress;uid=suo;pwd=***;database=test";
SqlConnection conn=new SqlConnection(strConn);
//首先是DataReader的两种取值方法
public void GetValue()
{
string sql="SELECT * FROM friend";
SqlCommand cmd=new SqlCommand(sql,conn);
SqlDataReader reader=cmd.ExecuteReader();
while(reader.Read())
{
//一种为reader.GetString(index)或者reader[index].ToString();另一种为reader["字段名"].ToString()
Console.WriteLine("No:{0}/tName:{1}/tPhoneNum:{2},/tAddress:{3}",reader.GetInt32(0).ToString(),reader.GetString(1),reader[2].ToString(),reader["Faddress"].ToString());
}
reader.Close();
conn.Close();
}
reader.Close();
conn.Close();
}
//带参数查询的操作
public void HasParam()
{
SqlCommand cmd = conn.CreateCommand();
string sql = "SELECT Fname,Fphone,Faddress FROM friend WHERE Fid > @Fid";
cmd.CommandText = sql;
SqlParameter param = new SqlParameter("@Fid",SqlDbType.Int,4);
param.Value = 15;
cmd.Parameters.Add(param);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);//当关闭reader的时候同时关闭数据库连接
while(reader.Read())
{
Console.WriteLine("Name:{0}/tPhoneNum:{1}/tAddress:{2}",reader.GetString(0),reader.GetString(1),reader.GetString(2));
}
reader.Close(); //此时这里无需关闭conn,系统会自动调用这个方法来关闭conn连接
}
{
SqlCommand cmd = conn.CreateCommand();
string sql = "SELECT Fname,Fphone,Faddress FROM friend WHERE Fid > @Fid";
cmd.CommandText = sql;
SqlParameter param = new SqlParameter("@Fid",SqlDbType.Int,4);
param.Value = 15;
cmd.Parameters.Add(param);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);//当关闭reader的时候同时关闭数据库连接
while(reader.Read())
{
Console.WriteLine("Name:{0}/tPhoneNum:{1}/tAddress:{2}",reader.GetString(0),reader.GetString(1),reader.GetString(2));
}
reader.Close(); //此时这里无需关闭conn,系统会自动调用这个方法来关闭conn连接
}
//存储过程的输出参数
public void OutputParam()
{
SqlCommand cmd= conn.CreateCommand();
cmd.CommandText = "GetInfo";
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter param = cmd.Parameters.Add("@Fid",16);
param = cmd.Parameters.Add("@Fname",SqlDbType.VarChar,8);
param.Direction = ParameterDirection.Output;
param = cmd.Parameters.Add("@Fphone",SqlDbType.VarChar,8);
param.Direction = ParameterDirection.Output;
conn.Open();
cmd.ExecuteNonQuery();
string Fname = cmd.Parameters["@Fname"].Value.ToString();
string Fphone = cmd.Parameters["@Fphone"].Value.ToString();
Console.WriteLine(Fname + " " + Fphone);
conn.Close();
}
public void OutputParam()
{
SqlCommand cmd= conn.CreateCommand();
cmd.CommandText = "GetInfo";
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter param = cmd.Parameters.Add("@Fid",16);
param = cmd.Parameters.Add("@Fname",SqlDbType.VarChar,8);
param.Direction = ParameterDirection.Output;
param = cmd.Parameters.Add("@Fphone",SqlDbType.VarChar,8);
param.Direction = ParameterDirection.Output;
conn.Open();
cmd.ExecuteNonQuery();
string Fname = cmd.Parameters["@Fname"].Value.ToString();
string Fphone = cmd.Parameters["@Fphone"].Value.ToString();
Console.WriteLine(Fname + " " + Fphone);
conn.Close();
}
//读取多个无关记录集
public void MultiResult()
{
SqlCommand cmd=conn.CreateCommand();
string sqla = "SELECT Fname FROM friend";
string sqlb = "SELECT Fphone FROM friend";
cmd.CommandText = sqla + ";" + sqlb;
conn.Open();
SqlDataReader reader= cmd.ExecuteReader();
int i = 1;
do
{
Console.WriteLine("第" + i.ToString() + "个记录集内容如下:/n");
while(reader.Read())
{
Console.WriteLine(reader[0].ToString() + "/t");
}
i++;
}
{
SqlCommand cmd=conn.CreateCommand();
string sqla = "SELECT Fname FROM friend";
string sqlb = "SELECT Fphone FROM friend";
cmd.CommandText = sqla + ";" + sqlb;
conn.Open();
SqlDataReader reader= cmd.ExecuteReader();
int i = 1;
do
{
Console.WriteLine("第" + i.ToString() + "个记录集内容如下:/n");
while(reader.Read())
{
Console.WriteLine(reader[0].ToString() + "/t");
}
i++;
}
while(reader.NextResult()); //NextResult()移动到下一个记录集
reader.Close();
conn.Close();
}
reader.Close();
conn.Close();
}
//获取数据库模式信息
public void GetSchema()
{
SqlCommand cmd;
cmd = conn.CreateCommand();
string sql = "SELECT Fid,Fname,Fphone FROM friend";
cmd.CommandText = sql;
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
DataTable SchemaTable = reader.GetSchemaTable();
DataRowCollection SchemaColumns = SchemaTable.Rows;
DataColumnCollection SchemaProps = SchemaTable.Columns;
foreach(DataRow SchemaColumn in SchemaColumns)
{
foreach(DataColumn SchemaColumnProp in SchemaProps)
{
Console.WriteLine(SchemaColumnProp.ColumnName + "=" + SchemaColumn[SchemaColumnProp.ColumnName].ToString());
}
}
{
SqlCommand cmd;
cmd = conn.CreateCommand();
string sql = "SELECT Fid,Fname,Fphone FROM friend";
cmd.CommandText = sql;
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
DataTable SchemaTable = reader.GetSchemaTable();
DataRowCollection SchemaColumns = SchemaTable.Rows;
DataColumnCollection SchemaProps = SchemaTable.Columns;
foreach(DataRow SchemaColumn in SchemaColumns)
{
foreach(DataColumn SchemaColumnProp in SchemaProps)
{
Console.WriteLine(SchemaColumnProp.ColumnName + "=" + SchemaColumn[SchemaColumnProp.ColumnName].ToString());
}
}
reader.Close();
conn.Close();
conn.Close();
}
声明:以上内容非本人原创,详情请查阅《C#数据库入门经典(第二版)》作者:James Huddleston
- DataReader方法详解
- DataReader转DataSet方法
- DataReader转DataSet方法
- DataReader链接数据库的方法
- datareader
- DataReader
- DataReader
- 使用DataReader[列序号]的方法读取DataReader对象
- 使用DataReader[列序号]的方法读取DataReader对象
- C#反射静态方法开发实例详解(从DataReader将数据填充到数据实体泛型集合)
- DataReader绑定DataGridView的两种方法
- 如何使用DataReader对象的GetSchemaTable方法
- 【性能技巧】使用DataReader[列序号]的方法读取DataReader对象
- 【性能技巧】使用DataReader[列序号]的方法读取DataReader对象
- EXT核心API详解(十)--DataReader/ArrayReader/JsonReader/XmlReader
- ADO.NET常用对象详解之:DataReader对象
- ADO.NET常用对象详解之:DataReader对象
- vs2005下调用存储过程并用Datareader读出的方法
- 如何阅读源代码
- VS2008与IE8.0不兼容 VS2008添加成员变量异常 VS2008添加类异常[强烈推荐]
- Struts2小结
- 大幅优化myeclipse的速度
- C# 获取被调用函数的信息
- DataReader方法详解
- 从程序角度看ecshop
- 对象内存布局 (14)
- 转:Windows Socket 网络编程(二) —— 套接字编程原理
- 关于linux 定时器的问题
- 学习xpath的好去处
- emacs中color-theme的正确配置方法
- 打工不如当老板,注册公司费用和步骤
- 转:Windows Sockets 网络编程(三) —— WINDOWS SOCKETS 1.1 程序设计