因为asp.net2.0wap form中的TextBox控件没有多行输入功能,所有我就用web form中的TextBox控件,现在我无法得到它的值呀,求各位帮忙解决,谢了!代码: string updatestr = string.Empty;
updatestr = UserInfo.backor == 1 ? "update Tb_Bill set BackContent=BackContent+'&'+CONVERT(varchar(30), Backtime, 20)+':'+@BackContent,Backtime=@Backtime,WriteBack=1 where IDS='" + UserInfo.orderon + "'" :
"update Tb_Bill set BackContent=CONVERT(varchar(30), Backtime, 20)+':'+@BackContent,Backtime=@Backtime,WriteBack=1 where IDS='" + UserInfo.orderon + "'";
SqlConnection conn = UserInfo.getconn();
conn.Close();
conn.Open();
SqlCommand cmd = new SqlCommand(updatestr, conn);
cmd.Parameters.Clear();
cmd.Parameters.Add(new SqlParameter("@BackContent", SqlDbType.VarChar,5000));
cmd.Parameters["@BackContent"].Value = TextBox1.Text.Trim();//这里用的是不能输入多行的TextBox cmd.Parameters.Add(new SqlParameter("@Backtime", SqlDbType.DateTime));
cmd.Parameters["@Backtime"].Value = DateTime.Now;
try
{
cmd.ExecuteNonQuery();
}
catch
{
}
finally
{
conn.Close();
Response.Redirect("find.aspx");
}
updatestr = UserInfo.backor == 1 ? "update Tb_Bill set BackContent=BackContent+'&'+CONVERT(varchar(30), Backtime, 20)+':'+@BackContent,Backtime=@Backtime,WriteBack=1 where IDS='" + UserInfo.orderon + "'" :
"update Tb_Bill set BackContent=CONVERT(varchar(30), Backtime, 20)+':'+@BackContent,Backtime=@Backtime,WriteBack=1 where IDS='" + UserInfo.orderon + "'";
SqlConnection conn = UserInfo.getconn();
conn.Close();
conn.Open();
SqlCommand cmd = new SqlCommand(updatestr, conn);
cmd.Parameters.Clear();
cmd.Parameters.Add(new SqlParameter("@BackContent", SqlDbType.VarChar,5000));
cmd.Parameters["@BackContent"].Value = TextBox1.Text.Trim();//这里用的是不能输入多行的TextBox cmd.Parameters.Add(new SqlParameter("@Backtime", SqlDbType.DateTime));
cmd.Parameters["@Backtime"].Value = DateTime.Now;
try
{
cmd.ExecuteNonQuery();
}
catch
{
}
finally
{
conn.Close();
Response.Redirect("find.aspx");
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货