在Yq类中有下面的更新语句public void Update(Hashtable newyqInfo)
{
Database db=new Database();
string condition = "Where yqId = " + this._yqId;
db.Update("[Yq]",newyqInfo,condition);
}
请问.cs在里面怎样写更新Yq语句代码?
是在一个按钮单击事件中
{
Database db=new Database();
string condition = "Where yqId = " + this._yqId;
db.Update("[Yq]",newyqInfo,condition);
}
请问.cs在里面怎样写更新Yq语句代码?
是在一个按钮单击事件中
new Yq().Update(newyqInfo);看你代码估计是带参数的构造。new Yq(参数1,参数2).Update(newyqInfo);
我要更新的数据都是在页面的文本框中获得的
我瞎写了些
string sqlstr ="Update Yq Set
yqName='"+ yiqimingcheng.Text +"',(这里的' "+ +" ' 要不要加?)
yqleibieId = int.Parse(yiqileibie.SelectedValue),
yq.yqBianhao = yiqibianhao.Text.Trim(),
yqGuige = guigexinghao.Text.Trim(),
yqFromc = shengchanchangjia.Text.Trim(),
yqFrom = chandi.Text.Trim(),
yqTimeg = DateTime.Parse(gouzhiriqi.Text.Trim()),
yqYuanzhi = float.Parse(yuanzhi.Text.Trim()),
yqZhuangkuang = yiqizhuangkuang.Text.Trim(),
yqDanwei = suozaidanwei.Text.Trim(),
yqShiyanshi = suozaishiyanshi.Text.Trim(),
yqDidian = cunfangdidian.Text.Trim(),
yqLname = lianxiren.Text.Trim(),
yqDianhua = lianxidianhua.Text.Trim(),
yqEmail = email.Text.Trim(),
yqZhibiao = jishuzhibiao.Text.Trim(),
yqTese = tesegongneng.Text.Trim(),
yqYongtu = zhuyaoyongtu.Text.Trim(),
yqFuwu = fuwulingyu.Text.Trim(),
yqFujian = fujian.Text.Trim(),
yqYaoqiu = yangpinyaoqiu.Text.Trim(),
yqShoufei = shoufeibiaozhun.Text.Trim(),
yqTimek = kaifangshijian.Text.Trim(),
yqGongxiang = gongxiangjibie.Text.Trim(),
yqBeizhu = beizhu.Text.Trim(),
imgUrl =pictureName
where id=yqid";
SqlConnection conn = new SqlConnection(); //创建连接对象
conn.ConnectionString = "Data Source=;Database=;UId=;Pwd=";
SqlCommand cmd = new SqlCommand(sqlstr,conn);
conn.Open();
cmd.EndExecuteNonQuery();
conn.Close();
好象不行
高手帮我写点代码
="Update Yq Set
yqName='"+ yiqimingcheng.Text +"',(这里的' "+ +" ' 要不要加?)
yqleibieId = int.Parse(yiqileibie.SelectedValue),
yq.yqBianhao = yiqibianhao.Text.Trim(),
yqGuige = guigexinghao.Text.Trim(),
yqFromc = shengchanchangjia.Text.Trim(),
yqFrom = chandi.Text.Trim(),
这里的单引号 双引号 都哪里需要加?