读书人

.net提交有关问题

发布时间: 2012-04-21 14:34:44 作者: rapoo

.net提交问题
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()看需求

读书人网 >asp.net

热点推荐