木子屋
 

标题: ASP获取新插入记录id示例

作者: dnawo

日期: 2007-03-22 04:05 PM

分类: Web编程

内容: ASP+ACCESS
复制内容到剪贴板 程序代码<%
dim conn, rs, sql, newid
set conn = Server.CreateObject("ADODB.Connection")
set rs = Server.CreateObject("ADODB.Recordset")
conn.connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\demo\db1.mdb"
sql = "select top 1 * from website"
conn.open
rs.open sql,conn,3,3
rs.addnew
rs("name")="木子屋"
rs("url")="http://www.mzwu.com/"
newid=rs("id")
rs.update
rs.close
conn.close
set conn = nothing
response.Write(newid)
%>
ASP+SQL Server
复制内容到剪贴板 程序代码<%
dim conn, sql, newid
set conn = Server.CreateObject("ADODB.Connection")
conn.connectionstring = "Provider=SQLOLEDB;Data Source=(local);Initial Catalog=mydb;User ID=sa;Password=sa"
conn.open
sql = "insert into website(name,url) values('木子屋','http://www.mzwu.com/')"
conn.execute(sql)
sql = "select scope_identity()"
newid = conn.execute(sql)(0)
conn.close
set conn = nothing
response.Write(newid)
%>
.NET+SQL Server
复制内容到剪贴板 程序代码using (SqlConnection conn = new SqlConnection("Data Source=(local);Initial Catalog=mydb;User ID=sa;Password=sa"))
{
    conn.Open();
    using (SqlCommand cmd = new SqlCommand("insert into website(name,url) values('木子屋','http://www.mzwu.com/');select scope_identity();", conn))
    {
        MessageBox.Show(cmd.ExecuteScalar().ToString());
    }
    conn.Close();
}

+ 查看当前日志评论 (1)

 

登录

────────────

木子屋

PJBlog3 v3.2.9.518 Inside.

Processed In 0.031 ms

标题: ASP获取新插入记录id示例

你没有权限发表评论

────────────

木子屋

PJBlog3 v3.2.9.518 Inside.

Processed In 0.031 ms

暂无评论

返回

────────────

木子屋

PJBlog3 v3.2.9.518 Inside.

Processed In 0.031 ms