>
.这个为c#连接winform 注意点:(1)
时必须引用此类
命名空间 (2)类中引用
命名空间 using
; using
.Data; using
.Data.SqlClient; (3)
举例: DataSet ds =
DataSet
; 
sql=\"select * from [user]\"; ds=DoDataBase.GetDataSet(sql);
dataGrid1.DataSource=ds.Tables[0].DefaultView;
//以上 4行为用02wangluo数据库中user表来填充DataSet后绑定到dataGrid1
//这是
GetDataSet思路方法-->此思路方法主要面对是查(select) sql=\"insert 
o test(test_xingming) values (\"+txtUserID.Text+\")\"; DoDataBase.ExecuteSQL(sql);
//以上两行是
DoDataBase数据库操作类中ExecuteSQL思路方法来执行对数据库增
删改等操作般写到button_click中 (3)具体操作类代码:
public
DoDataBase {
public DoDataBase
{
//
// TODO: 在此处添加构造
逻辑 //
}
public
DataSet GetDataSet( sql) {
SqlConnection conn=
SqlConnection; DataSet ds=
DataSet; try
{
conn=
SqlConnection(\"server=localhost;uid=sa;pwd=;database=02wangluo\"); SqlDataAdapter sda=
SqlDataAdapter(sql,conn); sda.Fill(ds);
ds; }
catch(Exception ex)
{
throw(ex);
}
finally
{
conn.Close
; }
}
public
ExecuteSQL( sql) {
SqlConnection conn=
SqlConnection; try
{
conn=
SqlConnection(\"server=localhost;uid=sa;pwd=;database=02wangluo\"); SqlCommand sqlCmd =
SqlCommand(sql,conn); conn.Open
; sqlCmd.ExecuteNonQuery; }
catch(Exception ex)
{
throw ex;
}
finally
{
conn.Close
; }
}
}
2ASP.net中c#操作SQL SERVER 2000数据库
操作类 (1)类中命名空间:
using
; using
.Data; using
.Data.SqlClient; using
.Collections; using
.Configuration; (2)在web.config中
<configuration>下面行加入数据库连接
串 <appSettings>
<add key=\"sqlConn\" value=\"data source=(local); initial catalog=02wangluo;user id=sa; password=\"/>
</appSettings>
(2)操作类代码:
public
DoDataBase {
public
SqlConnection sqlConn = SqlConnection; public DoDataBase
{
}
public
DataSet GetDataSet( sql) {
DataSet ds =
DataSet; try
{
sqlConn =
SqlConnection(ConfigurationSettings.AppSettings[\"sqlConn\"]); SqlDataAdapter sqlApt =
SqlDataAdapter(sql, sqlConn); sqlApt.Fill(ds);
ds; }
catch (Exception ex)
{
throw (ex);
}
}
public
ExecuteSQL( sql) {
try
{
sqlConn =
SqlConnection(ConfigurationSettings.AppSettings[\"sqlConn\"]); SqlCommand sqlCmd =
SqlCommand(sql,sqlConn); sqlConn.Open
; sqlCmd.ExecuteNonQuery; }
catch (Exception ex)
{
throw (ex);
}
finally
{
sqlConn.Close
; }
}
}
(4)
举例:略
最新评论