ASP 怎么连接SQL数据库

ASP与SQL数据库连接语句具体如下：

Set conn = Server.CreateObject("ADODB.Connection")

connstr = "provider=Sqloledbserver=服务器名uid=用户名pwd=密码database=数据库名"

conn.Open connstr

If Err Then

err.Clear

Set conn = Nothing

Response.Write "数据库连接出错，请检查连接字串"

Response.End

扩展资料：

SQL常用命令使用方法：

(1) 数据记录筛选：

sql="select * from 数据表 where 字段名=字段值 order by 字段名 "

sql="select * from 数据表 where 字段名 like ‘%字段值%‘ order by 字段名 "

sql="select top 10 * from 数据表 where 字段名 order by 字段名 "

sql="select * from 数据表 where 字段名 in (‘值1‘,‘值2‘,‘值3‘)"

sql="select * from 数据表 where 字段名 between 值1 and 值2"

(2) 更新数据记录：

sql="update 数据表 set 字段名=字段值 where 条件表达式"

sql="update 数据表 set 字段1=值1,字段2=值2 …… 字段n=值n where 条件表达式"

(3) 删除数据记录：

sql="delete from 数据表 where 条件表达式"

sql="delete from 数据表" (将数据表所有记录删除)

protected void Button1_Click(object sender, EventArgs e)

{

try

{

if (FileUpload1.PostedFile.FileName == "")

{

Response.Write("<script language='javascript'>alert('上传文件不能为空！')</script>")

//Label1.Text = "上传文件不能为空！"

}

else

{

string filepath = FileUpload1.PostedFile.FileName

string filename = filepath.Substring(filepath.LastIndexOf("\\") + 1)

string serverpath = Server.MapPath("File/") + filename

FileUpload1.PostedFile.SaveAs(serverpath)

//Response.Write("<script language='javascript'>alert('上传成功！')</script>")

}

}

catch (Exception error)

{

Response.Write("<script language='javascript'>alert('出现错误！')</script>")

}

--以上是上传的代码

string StyleSheet = "Sheet1"

LoadData1(StyleSheet)--导入数据

public void LoadData1(string StyleSheet)

{

string strCon = "Provider=Microsoft.Jet.OLEDB.4.0Data Source=" + Server.MapPath("File/上传的文件名") + "Extended Properties=Excel 8.0"

OleDbConnection myCon = new OleDbConnection(strCon)

myCon.Open()

DataSet myDataSet = new DataSet()

string strSql = "select * from [" + StyleSheet + "$]"

OleDbDataAdapter myCommand = new OleDbDataAdapter(strSql,myCon)

myCommand.Fill(myDataSet, "[" + StyleSheet + "$]")

DataTable dt = myDataSet.Tables["[" + StyleSheet + "$]"]

myCon.Close()

myCommand.Dispose()

for (int j = 0j <dt.Rows.Countj++)

{

string uid = dt.Rows[j][0].ToString()

--此处得到具体的字段

string sqlInsert = string.Format(@"insert into s_zj(表字段) values('{0}',。。。。)", uid, 。。。)

dbc.exeComm(sqlInsert)

}

Response.Write("<script>alert('导入完成！')</script>")

}

}

strconn = "driver={sql erver}description=sqldemoserver=127.0.0.1uid=用户名&_

pwd=data123database=data1

set conn = server.createobject("adodb.connection")

conn.open strconn

以上就打开数据库了，接下来就是插入数据了

set rs=server.CreateObject("adodb.recordset")

sql="update table set fn =da "

rs.open sql,conn,1,3

---