如有一个sql语句 sql="select @@IDENTITY AS 'xlh'"
那么我怎样才能在asp.net(vb.net)得到xlh的值?急用,谢谢!
那么我怎样才能在asp.net(vb.net)得到xlh的值?急用,谢谢!
解决方案 »
- 字符串拼接问题
- 关于findControl("id")和controls[number]的区别?
- 用户控件调用JS的问题
- 怎么获取XML的最后一个节点?
- 初学ASP.NET C# 弱弱的一问
- MSN ??? 中的提示信息小窗口! (在线)求助!!!大家
- [弟兄们急]关于日历的问题
- asp.net所有文件上传到空间上,为什么不能读取Access中的数据?我在本机测试没有问题,并且网上可以读aspx格式文件
- 请指教DATAGRID的超级链接列的问题?
- 关于ASP.Net中的TreeView控件
- 有哪位用过nGallery的,就是ASP.NET官方主页推荐的那个网络影集,我装了想研究一下,可是......
- 访问HTTPS的问题
sql="select @@INDENTITY as '" & strPP & "'"
select @variable=column from table_name
CREATE PROCEDURE 存儲過程名
@Title nvarchar(50),
@ClassId int,
@Author nvarchar(20),
@GatherFrom nvarchar(20),
@IsUrgent tinyint,
@IsImportant tinyint,
@Content ntext,
@Files nvarchar(100),
@RealFileName nvarchar(100),
@Keywords nvarchar(20),
@Link nvarchar(100),
@Upload nvarchar(20),
@UploadDate datetime,
@UpdateUserId nvarchar(20),
@UpdateDate datetime,
@Status tinyint,
-- @SerialId int,
@DepthId int,
@BrowseDepthId int,
@InsertId bigint output
AS
begin transaction
INSERT CIC_Intelligence(
Title,
ClassId,
Author,
GatherFrom,
IsUrgent,
IsImportant,
Content,
Files,
RealFileName,
Keywords,
Link,
Upload,
UploadDate,
UpdateUserId,
UpdateDate,
BrowseNum,
CommentNum,
Status,
DepthId,
BrowseDepthId)
VALUES(
@Title,
@ClassId,
@Author,
@GatherFrom,
@IsUrgent,
@IsImportant,
@Content,
@Files,
@RealFileName,
@Keywords,
@Link,
@Upload,
@UploadDate,
@UpdateUserId,
@UpdateDate,
0,
0,
@Status,
--@SerialId,
@DepthId,
@BrowseDepthId)
commit
set @InsertId=@@identity
returnGO
------------------------------------------------------string constr=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
SqlConnection con=new SqlConnection(constr);
string intelType;
if((lstClass3.SelectedValue!=null)&&(!lstClass3.SelectedValue.Equals("0")))
{
intelType=lstClass3.SelectedValue;
} con.Open();
SqlTransaction intelTrans=con.BeginTransaction(); SqlCommand cmd = con.CreateCommand();
cmd.CommandType=CommandType.StoredProcedure;
cmd.CommandText="存儲過程名";
cmd.Transaction=intelTrans; cmd.Parameters.Add("@Title",SqlDbType.NVarChar,100);
cmd.Parameters.Add("@ClassId",SqlDbType.Int);
cmd.Parameters.Add("@Author",SqlDbType.NVarChar,50);
cmd.Parameters.Add("@GatherFrom",SqlDbType.NVarChar,50);
cmd.Parameters.Add("@IsUrgent",SqlDbType.TinyInt);
cmd.Parameters.Add("@IsImportant",SqlDbType.TinyInt);
cmd.Parameters.Add("@Content",SqlDbType.NText);
cmd.Parameters.Add("@Files",SqlDbType.NVarChar,100);
cmd.Parameters.Add("@RealFileName",SqlDbType.NVarChar,100);
cmd.Parameters.Add("@Keywords",SqlDbType.NVarChar,200);
cmd.Parameters.Add("@Link",SqlDbType.NVarChar,200);
cmd.Parameters.Add("@Upload",SqlDbType.NVarChar,10);
cmd.Parameters.Add("@UploadDate",SqlDbType.DateTime);
cmd.Parameters.Add("@UpdateUserId",SqlDbType.NVarChar,10);
cmd.Parameters.Add("@UpdateDate",SqlDbType.DateTime);
cmd.Parameters.Add("@Status", SqlDbType.TinyInt, 1, "Status");
cmd.Parameters.Add("@BrowseDepthId",SqlDbType.Int);
cmd.Parameters.Add("@DepthId",SqlDbType.Int);
cmd.Parameters.Add("@InsertId",SqlDbType.BigInt); cmd.Parameters["@Title"].Value = txtTitle.Text.Trim();
cmd.Parameters["@ClassId"].Value = Convert.ToInt16(intelType);
cmd.Parameters["@Author"].Value = txtAuthor.Text.Trim();
cmd.Parameters["@GatherFrom"].Value = txtGatherFrom.Text.Trim();
cmd.Parameters["@IsUrgent"].Value =Convert.ToInt16(lstUrgent.SelectedValue);
cmd.Parameters["@IsImportant"].Value =Convert.ToInt16(this.IsImportant.SelectedValue);
cmd.Parameters["@Content"].Value =this.FCKeditor1.Value;
cmd.Parameters["@Keywords"].Value = txtKeywords.Text.Trim();
cmd.Parameters["@Link"].Value = txtLink.Text.Trim();
cmd.Parameters["@Upload"].Value = curUser;
cmd.Parameters["@UploadDate"].Value = DateTime.Now;
cmd.Parameters["@UpdateUserId"].Value = curUser;
cmd.Parameters["@UpdateDate"].Value = DateTime.Now;
cmd.Parameters["@Status"].Value=intStatus;
cmd.Parameters["@BrowseDepthId"].Value =lstDepth.SelectedValue;
cmd.Parameters["@DepthId"].Value =userInfo.AuthenticateInfo.DepthId;
cmd.Parameters["@InsertId"].Direction=ParameterDirection.Output; try
{
cmd.ExecuteNonQuery();
MaxId=cmd.Parameters["@InsertId"].Value.ToString();
cmd.Parameters.Clear();
intelTrans.Commit();
Insert_Flag = true;
}
catch(Exception)
{
intelTrans.Rollback();
}
finally
{
con.Close();
}
那么我怎样才能在asp.net(vb.net)得到xlh的值?急用,谢谢!
--------------------------------
sql="select @@IDENTITY AS 'xlh' FROM A"
DataSet ds=new DataSet ;
ds=Info.Select(sql,"A");
string str=ds.Table["A"].ROWS[0]["xlh"].Tostring();
这是我们在C#的做法,你可以参照一下!!!!!!!!