using System;
using System.Data;
using System.Data.OleDb;namespace pdvi
{
public class Pdvi
{
OleDbConnection OleDbConn = new OleDbConnection();
OleDbDataAdapter OleDbAdap = new OleDbDataAdapter();
string connstr = null;
string connuid = null;
string connpwd = null;
bool Statu = false; //数据源状态标志默认是关闭 public Pdvi() //构造函数
{
} public Pdvi(string ConnStr)
{
initialize(ConnStr); //调用初始化私有方法
} private void initialize(string ConnStr) //初始化私有方法
{
OpenConnString(ConnStr); //调用数据访问方法
} private void OpenConnString(string ConnStr) //调用方法打开数据源
{
try
{
this.OleDbConn.ConnectionString = ConnStr.ToString();
this.OleDbConn.Open();
}
catch(Exception e)
{
throw e;
}
finally
{
if (this.OleDbConn.State == System.Data.ConnectionState.Open)
{
this.Statu = true; //数据源被打开标志
}
else
{
this.Statu = false;
}
}
} public void OpenConnString() //调用方法打开数据源
{
try
{
this.OleDbConn.ConnectionString = this.connstr.ToString();
this.OleDbConn.Open();
}
catch(Exception e)
{
throw e;
}
finally
{
if (this.OleDbConn.State == System.Data.ConnectionState.Open)
{
this.Statu = true; //数据源被打开标志
}
else
{
this.Statu = false;
}
}
} public void SetConnStr(string connstr) //设置连接数据源的字符串
{
this.connstr = connstr;
} public void SetConnUid(string connuid) //设置连接数据源的用户名
{
this.connuid = connuid;
} public void SetConnPwd(string connpwd) //设置连接数据源的通行码
{
this.connpwd = connpwd;
} public string GetConnStr() //获取连接数据源的字符串
{
return this.connstr;
} public string GetConnUid() //获取连接数据源的用户名
{
return this.connuid;
} public string GetConnPwd() //获取连接数据源的通行证
{
return this.connpwd;
} public OleDbDataReader GetDataReader(string sSQL)
{
OleDbCommand cmd = new OleDbCommand(sSQL,this.OleDbConn); try
{
if (this.Statu == true)
{
return cmd.ExecuteReader();
}
else
{
return null;
}
}
catch (Exception e)
{
throw e;
}
finally
{
cmd.Dispose();
this.OleDbConn.Close();
this.OleDbConn.Dispose();
}
} public DataSet GetDataSet(string sSQL)
{
this.OleDbAdap = new OleDbDataAdapter(sSQL,this.OleDbConn);
DataSet Ds = new DataSet(); try
{
if (this.Statu == true)
{
this.OleDbAdap.Fill(Ds);
return Ds;
}
else
{
return null;
}
}
catch (Exception e)
{
throw e;
}
finally
{
this.OleDbConn.Close();
this.OleDbAdap.Dispose();
}
} }
}
using System.Data;
using System.Data.OleDb;namespace pdvi
{
public class Pdvi
{
OleDbConnection OleDbConn = new OleDbConnection();
OleDbDataAdapter OleDbAdap = new OleDbDataAdapter();
string connstr = null;
string connuid = null;
string connpwd = null;
bool Statu = false; //数据源状态标志默认是关闭 public Pdvi() //构造函数
{
} public Pdvi(string ConnStr)
{
initialize(ConnStr); //调用初始化私有方法
} private void initialize(string ConnStr) //初始化私有方法
{
OpenConnString(ConnStr); //调用数据访问方法
} private void OpenConnString(string ConnStr) //调用方法打开数据源
{
try
{
this.OleDbConn.ConnectionString = ConnStr.ToString();
this.OleDbConn.Open();
}
catch(Exception e)
{
throw e;
}
finally
{
if (this.OleDbConn.State == System.Data.ConnectionState.Open)
{
this.Statu = true; //数据源被打开标志
}
else
{
this.Statu = false;
}
}
} public void OpenConnString() //调用方法打开数据源
{
try
{
this.OleDbConn.ConnectionString = this.connstr.ToString();
this.OleDbConn.Open();
}
catch(Exception e)
{
throw e;
}
finally
{
if (this.OleDbConn.State == System.Data.ConnectionState.Open)
{
this.Statu = true; //数据源被打开标志
}
else
{
this.Statu = false;
}
}
} public void SetConnStr(string connstr) //设置连接数据源的字符串
{
this.connstr = connstr;
} public void SetConnUid(string connuid) //设置连接数据源的用户名
{
this.connuid = connuid;
} public void SetConnPwd(string connpwd) //设置连接数据源的通行码
{
this.connpwd = connpwd;
} public string GetConnStr() //获取连接数据源的字符串
{
return this.connstr;
} public string GetConnUid() //获取连接数据源的用户名
{
return this.connuid;
} public string GetConnPwd() //获取连接数据源的通行证
{
return this.connpwd;
} public OleDbDataReader GetDataReader(string sSQL)
{
OleDbCommand cmd = new OleDbCommand(sSQL,this.OleDbConn); try
{
if (this.Statu == true)
{
return cmd.ExecuteReader();
}
else
{
return null;
}
}
catch (Exception e)
{
throw e;
}
finally
{
cmd.Dispose();
this.OleDbConn.Close();
this.OleDbConn.Dispose();
}
} public DataSet GetDataSet(string sSQL)
{
this.OleDbAdap = new OleDbDataAdapter(sSQL,this.OleDbConn);
DataSet Ds = new DataSet(); try
{
if (this.Statu == true)
{
this.OleDbAdap.Fill(Ds);
return Ds;
}
else
{
return null;
}
}
catch (Exception e)
{
throw e;
}
finally
{
this.OleDbConn.Close();
this.OleDbAdap.Dispose();
}
} }
}
解决方案 »
- 冰天雪地跪地求教!!!马上结贴
- 用C#语言编了一个菱形程序,不过有点问题。输出像个三角形,怎么改改?
- 如何从资源中加载图片?
- DataSet存入数组问题。
- [100分提问]客户端和服务器端Oracle使用的字符集相同,但是开发工具的字符集不同,结果造成数据乱码
- 怎样对一个目录下面的所有文件做循环?
- 怎么找到GridView里的button控件并且改变其属性
- 以前的一个问题(使窗体成为系统模态窗体)
- 有消息说C#将会支持其他平台,哪位确定一下?
- POST生成的Excel表格,如何模拟下载采集Excel文件
- 如何在文本文件中写入打印机控制字符(如换行的ASCII码为LF,十进制是10)?
- 讨论关于如何正确合理的使用资源文件?
conn= new SqlConnection("data source=sunny;user id=code;pwd=code;initial catalog=test;");
conn.Open();
SqlCommand dcmd=new SqlCommand("select * from test",conn);
DataSet ds= new DataSet();
SqlDataAdapter dadp=new SqlDataAdapter(dcmd);
dadp.Fill(ds,"test");
DataGrid1.DataSource=ds.Tables["test"];
DataGrid1.DataBind();
conn.Close();
myCNN.ConnectionString = "data source=.;initial catalog=aa;user id=sa;password=123;";myCNN.Open();SqlCommand myCMD = new SqlCommand();myCMD.Connection = myCNN;
myCMD.CommandText = "Select Count(*) From tPassword Where cPassword = '" + strGroupPassword + "'";if ((int)myCMD.ExecuteScalar() == 0)
return "ERROR";
DATAGRID用DATASET填充
readCMD.CommandText = "SELECT * FROM userinfo"; nwindConn.Open(); SqlDataReader myReader = readCMD.ExecuteReader(); while (myReader.Read())
{
Console.WriteLine("\t{0}\t{1}", myReader.GetInt32(0), myReader.GetString(1));
} myReader.Close();
nwindConn.Close();
如:
dgd.DataSource=ds.Tables(0);
但这样不对呀????
急急急!!!!!!!!!!!!!!!
谢谢!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
DataSet ds = new DataSet();SqlDataAdapter adapt = new SqlDataAdapter();
adapt.SelectCommand = showCMD;adapt.Fill(ds);
DataGrid.DataSource = ds.Tables["tablename"];
DataGrid.DataBind();
System.Data.Odbc.OdbcCommand cmd =new OdbcCommand("select * from person",conn);
System.Data.DataSet ds1=new DataSet ();
//System.Data.DataTable dt1=new DataTable("person1" );
System.Data.Odbc.OdbcDataAdapter dba=new OdbcDataAdapter() ;
dba.SelectCommand =cmd;
dba.Fill(ds1,0,10,"person1");这里用的是ODBC连接
SqlConnection thisConnection=new SqlConnection(strConnection);
SqlCommand thisCommand=new SqlCommand("select * from AAUser",thisConnection);
DataSet ds = new DataSet();
thisConnection.Open();
SqlDataAdapter dadp=new SqlDataAdapter(thisCommand);
dadp.Fill(ds);
dgd.DataSource=ds.Tables(0);
thisConnection.Close();
这样错吗?