日期:2014-05-18 浏览次数:20610 次
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()看需求