有什么办法,代码如下:
protected void Button1_Click(object sender, EventArgs e)
{
string messageID = ""; conn.Open();
SqlCommand cmd = new SqlCommand("insert into message(Content,sendTime,sendid) values ('" + TextArea1.Value + "',getdate() ,'1')", conn);
cmd.ExecuteNonQuery(); SqlCommand cmd2 = new SqlCommand("select ident_current('message')", conn);
SqlDataReader sdr2 = cmd2.ExecuteReader();
if (sdr2.Read())
{
messageID = sdr2[0].ToString();
}
conn.Close(); string s = HiddenField1.Value;
string[] sArray = s.Split(',');
foreach (string i in sArray)
{
if (i.ToString() != "")
{
conn.Open();
SqlCommand cmd3 = new SqlCommand("insert into receiveID(receiveID,messageID) values ('" + i.ToString() + "','" + messageID + "')", conn);
cmd3.ExecuteNonQuery();
conn.Close();
}
}
Response.Write("<script>window.opener.location.reload();window.close();</script>");
}
protected void Button1_Click(object sender, EventArgs e)
{
string messageID = ""; conn.Open();
SqlCommand cmd = new SqlCommand("insert into message(Content,sendTime,sendid) values ('" + TextArea1.Value + "',getdate() ,'1')", conn);
cmd.ExecuteNonQuery(); SqlCommand cmd2 = new SqlCommand("select ident_current('message')", conn);
SqlDataReader sdr2 = cmd2.ExecuteReader();
if (sdr2.Read())
{
messageID = sdr2[0].ToString();
}
conn.Close(); string s = HiddenField1.Value;
string[] sArray = s.Split(',');
foreach (string i in sArray)
{
if (i.ToString() != "")
{
conn.Open();
SqlCommand cmd3 = new SqlCommand("insert into receiveID(receiveID,messageID) values ('" + i.ToString() + "','" + messageID + "')", conn);
cmd3.ExecuteNonQuery();
conn.Close();
}
}
Response.Write("<script>window.opener.location.reload();window.close();</script>");
}
解决方案 »
- 我想自己开发一套Asp.net控件,大家看可行吗?
- js导出word ,2010word下面这句为什么会出错,new ActiveXObject("Word.Application");
- 请教:关于BinarySearch<string>方法,HELP^^^^^^^^
- 谁有类似的菜单导航控件代码,谢谢
- 【自定义WEB控件事件不激发/偶尔在调试的时候激发】
- asp.net2.0 (vs2005+sql2005+c#+ajax)问题终结者 群号:18895775
- 调用一个control类的派生类中的方法出现未将对象实例化
- 调用showModalDialog后,怎么刷新他的父窗口?
- 急!请问这是为什么!用户控件属性问题
- 关于连接数据库和DataGrid控件行列的问题!(40分,答对就给)
- aps.net通过下载工具下载
- 怎么设置 gridview 标题行 为多行
insert into Position(Title,Level,Description) values('aaaa',5,'dfjk'); select @@IDENTITY AS 'identity';这么写
SqlCommand cmd = new SqlCommand(Sql, connection);
result = (int)cmd.ExecuteScalar();
//执行查询并取出执行结果messageID
messageID = (Int32)cmd .ExecuteScalar();
//关闭数据库连接
con.Close();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into gendan(");
strSql.Append("yixiang,isXianxiahuodong,yuJiShouRu,yuJiSRDate,addTime,modifyTime,genDanRen,danwei,linkMan,lkmZhiwu,lkmTel,fristLkTime,daiLiShang,dlsLinkMan,hyType)");
strSql.Append(" values (");
strSql.Append("@yixiang,@isXianxiahuodong,@yuJiShouRu,@yuJiSRDate,@addTime,@modifyTime,@genDanRen,@danwei,@linkMan,@lkmZhiwu,@lkmTel,@fristLkTime,@daiLiShang,@dlsLinkMan,@hyType)");
strSql.Append(";set @ReturnValue= @@IDENTITY");