protected void btnSubmit_Click(object sender, EventArgs e)
{
if (txtcontant.ToString() == null)
{
Alert("请填写随访内容！");
}
else if (txtresults.ToString() == null)
{
Alert("请填写随访结果！");
}
else
{
HypertensionFollowupItem hyp = new HypertensionFollowupItem();
hyp.Followupcontent = this.txtcontant.ToString();
hyp.Followupresults = this.txtresults.ToString();
Updatefollowup(hyp);
}
}
public static int ExecuteNonQuery(CommandType cmdType, string cmdText, params SqlParameter[] commandParameters)
{
string connectionString = ConfigurationManager.ConnectionStrings["db_health"].ConnectionString;
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand cmd = new SqlCommand();
int val = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
return val;
}
public static int Updatefollowup(int upuserid)
{
HypertensionFollowupItem Hyper = new HypertensionFollowupItem();
string sql = " update health_user_hypertension_followup set followupcontent=@followupcontent,followupresults=@followupresults where user_id=@upuserid";
SqlParameter[] ps ={
new SqlParameter("@followupcontent",Hyper.Followupcontent),
new SqlParameter("@followupresults",Hyper.Followupresults)
};
return ExecuteNonQuery(CommandType.Text,sql,ps);
}
btnSubmit_Click中else应该如何接受从页面输入的数值？然后传入方法并执行，我上面的写法有没有什么问题？
------解决方案--------------------------------------------------------
- C# code
SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=（数据库）;Integrated Security=True");protected void btnSubmit_Click(object sender, EventArgs e) { string strcontant= this.txtcontant.ToString(); string strresults= this.txtresults.ToString(); int upuserid=“不知道等于什么”; Updatefollowup(strcontant，strresults); } /// <summary> /// <summary> /// 执行一条SQL语句,并返回受影响的记录条数 /// </summary> /// <param name="strSql"></param> /// <returns></returns> public int intExecuteSql(string strSql) { try { conn.Open(); SqlCommand cmd = new SqlCommand(strSql, conn); int intCount = cmd.ExecuteNonQuery(); return intCount; } catch (Exception e) { throw e; } finally { conn.Close(); } }public int Updatefollowup(string strcontant，string strresults，int upuserid)｛string sql = " update health_user_hypertension_followup set followupcontent=’”+strcontant+“‘,followupresults=’”+strcontant+“‘,where user_id=’”+upuserid+“‘";intExecuteSql(sql);｝
------解决方案--------------------------------------------------------
txtcontant.ToString() == null
都能.ToString()了就不用再判断==null
应该是这样
if(txtcontant.Text.Trim().Length > 0)
要不要.Trim()看需求