办公室座位对两个门:谁有数据连接文件给我一个 CONN那个

来源:百度文库 编辑:神马品牌网 时间:2024/04/30 03:12:50
asp的不是ASP.NET的

联接ACCESS 数据库代码:
string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = xt.mdb ";
OleDbConnection myConn = new OleDbConnection(strCon);
string strCom = " SELECT id,mm,fwq FROM xt where id1 = '1'";
//创建一个 DataSet对象
DataSet myDataSet = new DataSet();
myConn.Open();
OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn);
myCommand.Fill(myDataSet, "xt");
//myConn.Close();
L1 = myDataSet.Tables[0].Rows[0][0].ToString(); //用户名
L2 = myDataSet.Tables[0].Rows[0][1].ToString(); //密码
L3 = myDataSet.Tables[0].Rows[0][2].ToString(); //服务器
//SQLCONN为字符串联接字符串,在下列窗体中多次用到
SQLCONN = "Persist Security Info=True;User ID=" + L1 + ";Password=" + L2 + ";Initial Catalog=xitong;Data Source=" + L3;

删除记录:
public void deleterow(string Strbianhao, string table)
{
SqlConnection conn = new SqlConnection(cnStr);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
string CMDtext = "delete " + table + " where dzbh='" + Strbianhao + "'";
cmd.CommandText = CMDtext;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("删除成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
//如果是放在类中,自己还可以添加返回值,如1为成功,0为错误
}

有不明白继续问我
我帮你看

这玩意不能通用的。

<%
dim conn
dim connstr
dim db '你的数据库文件的位置
db="datebase\seaheart.mdb"
On Error Resume Next
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("datebase\seaheart.mdb")
conn.Open connstr
If Err Then
err.Clear
Set Conn = Nothing
Response.Write "数据库连接出错,请报告本站站长,谢谢!"
Response.End
End If

sub CloseConn()
conn.close
set conn=nothing
end sub
%>