deamweaver 与SQL怎么连啊

来源:百度知道 编辑:UC知道 时间:2024/06/08 20:14:18
我是用deamweaver里的ASP。NET(C#),,请各位高手帮忙一下。。。

public DataTable GetTable(string selectSql,string tableName)
{
try
{
string strconn;
strconn = "server=" + Dbserver + ";uid=" + UserId +";pwd=" +
UserPWD + ";database=" + Dbase + ";";
SqlConnection conn = new SqlConnection(strconn);
SqlDataAdapter cmd=new SqlDataAdapter(selectSql,conn);
DataSet ds=new DataSet();
cmd.Fill(ds,tableName);
return ds.Tables[tableName];
}
catch
{
return null;
}
}

----------------------------------------------------
Module MdlCommon
Public txtSQL As String '存放SQL语句
Public DBSet As DataSet '查询得到的记录集
Public ErrorMsg As String '存放错误信息

Public Function ExecuteSQL(ByVal strSQL As String, ByRef e