insert tablename(fieldname)values(value),select @@identity
解决方案 »
- 为什么NeatUpload控件在VS2010中不能用啊?
- 瞧一瞧,看一看啊,会的帮忙解决一下,不会捧个人场啊,简单的jQuery操作表单问题
- 新人求教 三层开发的概念
- Gridview拖动问题,请教
- 要疯了,想了几个小时了,DataList中ItemDataBind 寻找控件的问题!
- 请教一个关于IFRAME的问题
- 请大家帮忙讨论一下:DATASET保存在SESSION中设计有没有问题?
- ASP.NET(C#)的怎么把读入的是一段有格式的文章放入到文本域里呢?
- 日期转换 在线等到
- 在vs中怎么将DateTime这个时间格式转化成Oracle中字段属性为DATE格式
- sql server2000中怎样在日期中提取yyyy-mm-dd格式的数据?
- 文件上传的问题
session("key") = now
提交时将now同时写入提交后到一个新页面,
select * ... where key = '" & session("key") & "' order by id desc
有没有在asp.net2.0中做的方法,我用dataset一次插入多条记录,再把我刚插入的多条记录的id取出,加入另一个数据表的记录中
类似这样的SQL语句 ---------
SQL = "Insert into Ask_Juan(Ask_ID,Ask_Suoyin,Ask_User) select top 10 ID,'" & Suoyin & "','" & UserName & "' from Ask_Ask where ID not in(select Ask_ID from Ask_Juan where Ask_User = '" & UserName & "') and Ask_Pass='1' order by newid()"一次性读取10条随机数字,并写入到新表中,见
http://www.sjf.cn/ask/
就是当前插入的ID
所以,在你插入的存储过程中,返回这个就可以了
insert 语句 插入到另外一张表就可以了
objcmd.InsertCommand.CommandText = "insert into aaa(......) values(?,?,?,?,?,?,?)"
objconn.Open()
objcmd.InsertCommand.Connection = objconn
...
参数
....
Dim mytable As DataTable = DS.Tables("aaa")
Dim i As Integer
Dim myrow As DataRow
For i = 0 To DS.Tables("xxx").Rows.Count - 1
myrow = mytable.NewRow()
...
...
mytable.Rows.Add(myrow)
Next
Dim sum As Integer = DS.Tables("xxx").Rows.Count
objcmd.Update(DS, "aaa")
''取得刚插入数据的id
CreateDataSet("select top " & sum.ToString & " id from aaa where nsrid=" & textbox1.Text & "and nd='" & Trim(Drpnd.SelectedItem.Value) & "' order by cpcjid desc", "aaa1")
Try
objcmd.InsertCommand.Transaction = tran
objcmd.SelectCommand.Transaction = tran
objcmd.Update(DS, "cpb") objcmd.SelectCommand.CommandText = "select top " & sum.ToString & " * from cpb where nsrid=" & textbox1.Text & "and nd='" & Trim(Drpnd.SelectedItem.Value) & "' order by cpcjid desc" objcmd.Fill(DS, "cpb1")
tran.Commit()
Catch obja As Exception
tran.Rollback()
Dim script As String = "<script language='javascript'>"
script += "alert('" & " 保存出错,请重试! " & obja.InnerException.Message & "');<"
script += "/script>"
Response.Write(script)
Exit Sub
End Try
System.Guid.NewGuid().ToString();
----------------------------------------
接分.