62,040
社区成员
发帖
与我相关
我的任务
分享
SqlConnection Conn = new SqlConnection(strconn) ;
Conn.Open();
string sql = "insert into News(Title,NewsFrom,NewsContents,UpdateTime) values(@Title,@NewsFrom,@NewsContents,@UpdateTime)";
SqlCommand cmd = new SqlCommand(sql,Conn);
cmd.Parameters.Add(new SqlParameter("@Title",SqlDbType.NVarChar,255));
cmd.Parameters.Add(new SqlParameter("@NewsFrom",SqlDbType.NVarChar,50));
cmd.Parameters.Add(new SqlParameter("@NewsContents",SqlDbType.NText));
cmd.Parameters.Add(new SqlParameter("@UpdateTime",SqlDbType.DateTime,8));
cmd.Parameters["@Title"].Value=StrTitle;
cmd.Parameters["@NewsFrom"].Value=StrNewsFrom;
cmd.Parameters["@NewsContents"].Value=StrContents;
cmd.Parameters["@UpdateTime"].Value=DateTime.Now;
cmd.ExecuteNonQuery();
//获取新增记录ID
sql="select SCOPE_IDENTITY() as ID from News";
SqlCommand cmdsel = new SqlCommand(sql,Conn);
SqlDataReader NewsDr = cmdsel.ExecuteReader();
if(NewsDr.Read())
{
Response.Redirect("News_Detail.aspx?ID="+NewsDr["ID"].ToString());
}
Conn.Close();
string sql = "insert into News(Title,NewsFrom,NewsContents,UpdateTime) values(@Title,@NewsFrom,@NewsContents,@UpdateTime);SELECT SCOPE_IDENTITY() as id ";
declare @table table (id int identity(1,1),mcontent nvarchar(200))
insert into @table (mcontent)
select 'tt' union all
select 'yy'
select * from @table
select @@identity 'newid'
insert into @table (mcontent)
select 'mm'
select @@identity 'newid'
SELECT MAX(ID) from News
SqlConnection Conn = new SqlConnection(strconn) ;
Conn.Open();
string sql = "insert into News(Title,NewsFrom,NewsContents,UpdateTime) values(@Title,@NewsFrom,@NewsContents,@UpdateTime);SELECT @Identity=SCOPE_IDENTITY()";
SqlCommand cmd = new SqlCommand(sql,Conn);
cmd.Parameters.Add(new SqlParameter("@Title",SqlDbType.NVarChar,255));
cmd.Parameters.Add(new SqlParameter("@NewsFrom",SqlDbType.NVarChar,50));
cmd.Parameters.Add(new SqlParameter("@NewsContents",SqlDbType.NText));
cmd.Parameters.Add(new SqlParameter("@UpdateTime",SqlDbType.DateTime,8));
SqlParameter identity=new SqlParameter("@Identity",SqlDbType.Int);
identity.Direction = ParameterDirection.Output;
cmd.Parameters.Add(identity);
cmd.Parameters["@Title"].Value=StrTitle;
cmd.Parameters["@NewsFrom"].Value=StrNewsFrom;
cmd.Parameters["@NewsContents"].Value=StrContents;
cmd.Parameters["@UpdateTime"].Value=DateTime.Now;
int iden=int.Parse(cmd.ExecuteReader().toString());