在C#中如何返回插入表的信息？
在代码中写了一句insert语句，想获得这条数据的信息，主键是自动产生的，请各位大虾指点迷津! 问题点数：100、回复次数：8Top
1 楼pgy8288（Just Coding）回复于 2006-01-24 17:08:13 得分 20
返回@@identityTop
2 楼JasonHeung（拥有一切不过就这样笑着哭）回复于 2006-01-24 17:10:52 得分 20
select * from table1 where pk = @@identityTop
3 楼antoniusguo（anton）回复于 2006-01-24 17:11:26 得分 0
看看.NET自动生成的Insert语句就明白了Top
4 楼songxiaozhao（雨朋）回复于 2006-01-24 17:15:00 得分 20
insert into 表 () values () select @@identity
int myID=int.Perse(myCommand.ExecuteScalar().ToString());
得到的myID就是你的表的主键Top
5 楼yuanarea（Sail before）回复于 2006-01-24 17:44:12 得分 20
@@identity
注意，多层结构中不安全Top
6 楼super_xiaohai（空心菜）回复于 2006-01-24 17:46:00 得分 0
cmd1.CommandText="insert into 表 () values () select @@identity"
cmd1.ExecuteNonQuery();
结果以什么形式取出来的呢?
Top
7 楼WYZSC（007，重在参乎，说错问错勿怪。）回复于 2006-01-24 17:54:41 得分 20
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<head>
<title>Adding a New Record</title>
</head>
</html>
<script language="C#" runat="server">
private void Page_Load(object sender, System.EventArgs e)
{
// Connection set up
String strConnection = ConfigurationSettings.AppSettings["NWind"];
SqlConnection objConnection = new SqlConnection(strConnection);
String strSQL = "INSERT INTO Categories (CategoryName,Description) VALUES ('Guitars', 'Here you can find just the guitar you were looking for'); SELECT @@IDENTITY As 'Identity'";
SqlCommand dbComm = new SqlCommand(strSQL, objConnection);
int iID = 0;
try
{
objConnection.Open();
iID = Convert.ToInt32(dbComm.ExecuteScalar());
}
catch (Exception ex)
{
Response.Write(ex.Message);
Response.End();
}
finally
{
if (objConnection.State == ConnectionState.Open)
{
objConnection.Close();
}
}
Response.Write("The ID of the new record is: " + iID.ToString());
}
</script>Top
8 楼super_xiaohai（空心菜）回复于 2006-01-25 11:59:10 得分 0
谢谢各位，解决了
Top
相关问题
关键词
得分解答快速导航
相关链接
广告也精彩
反馈
