mudedi。Text = Request。QueryString["mudedi"]。ToString()。Trim();
piaojia。Text = Request。QueryString["piaojia"]。ToString()。Trim();
huocheleixing。Text = Request。QueryString["huocheleixing"]。ToString()。Trim();
// }
}
protected void Button1_Click(object sender, EventArgs e)
{来:自[优.尔]论,文-网www.youerw.com +QQ752018766-
string sql;
sql = "select id from zaixiandingpiao where zuowei='"+zuowei。Text。ToString()。Trim()+"' and checi='"+checi。Text。ToString()。Trim()+"'";
DataSet result2 = new DataSet();
result2 = new Class1()。hsggetdata(sql);
if (result2 != null)
{
if (result2。Tables[0]。Rows。Count > 0)
{
Response。Write("<script>javascript:alert('对不起,该座位已有人占座,请换其他座位');history。back();</script>");
Response。End();
}
sql = "insert into zaixiandingpiao(yonghuming,xingming,dianhua,shenfenzheng,checi,huocheleixing,chufazhan,mudedi,piaojia,piaoshu,zuowei) values('" + yonghuming。Text。ToString()。Trim() + "','" + xingming。Text。ToString()。Trim() + "','" + dianhua。Text。ToString()。Trim() + "','" + shenfenzheng。Text。ToString()。Trim() + "','" + checi。Text。ToString()。Trim() + "','" + huocheleixing。Text。ToString()。Trim() + "','" + chufazhan。Text。ToString()。Trim() + "','" + mudedi。Text。ToString()。Trim() + "','" + piaojia。Text。ToString()。Trim() + "','" + piaoshu。Text。ToString()。Trim() + "','"+zuowei。Text。ToString()。Trim()+"') ";
C#+sqlserver列车时刻表查询系统的设计(10):http://www.youerw.com/jisuanji/lunwen_94295.html