strSQL = "Select id,aa,bb from table1 where id = 1 ";SqlConnection conn= new SqlConnection("连接字符串");conn.Open();SqlCommand cmd= new SqlCommand(strSQL,conn);SqlDataReader dr=cmd.ExecuteReader();while (dr.Read())
{
//
}
{
//
}
DataSet rs=new DataSet();
adp.Fill(rs); //取得DataSet-rs
2、if(ds.Rows.Count>0)
{
rs[0][0]= 1;
rs[0][1]= "aa";
rs[0][2]= "bb"; adp.Update(rs);
}
else
{
DataRow dr=rs.Rows.NewRow();
dr[0]=1;
dr[1]="aa";
dr[1]="bb;
rs.Rows.Add(dr); }
SqlConnection conn=new SqlConnection("server=ser;uid=sa;pwd=123456;database=dat");
SqlCommand cmd=new SqlCommand("select * from mytable",conn);
SqlDataReader dr=cmd.ExecuteReader();
while(dr.Read())//通过Read()方法使当前记录向前移动一条记录
{
dr.GetString(0).ToString();//此处可以获得相关列的值
}
要先
using System.Data;
using System.Data.OleDb;OleDataAdapter adp=new OleDataAdapter(strQuery,yourConnection);>>>
OleDbDataAdapter adp=new OleDbDataAdapter(strQuery,yourConnection);
填充数据集(DataSet)->用Rows[n][m]的n行m列来访问数据
*Adapter会有SelectCommand、UpdateCommand、InsertCommand、DeleteCommand四个属性
你如果要对数据集执行如上操作,则必需手动指定相应的*Command对象(或者用SqlCommandBuilder绑定到数据适配器来自动生成相应的Command对象)
Hope it would help you !
填充数据集(DataSet)->用Rows[n][m]的n行m列来访问数据
*Adapter会有SelectCommand、UpdateCommand、InsertCommand、DeleteCommand四个属性
你如果要对数据集执行如上操作,则必需手动指定相应的*Command对象(或者用SqlCommandBuilder绑定到数据适配器来自动生成相应的Command对象)
Hope it would help you !