if (!Page.IsPostBack)
{
SqlConnection con = Operate.createCon();
SqlDataAdapter sda1 = new SqlDataAdapter();
sda1.SelectCommand = new SqlCommand("select client.client_name,clientpapers.papers_papers,clientpapers.papers_papersnumber,client.client_airinsurance,diary.airno from client,clientpapers,diary where client.client_autoid in(select client_autoid from diary where bill_autoid='" + bill_autoid + "') and clientpapers.client_autoid=client.client_autoid and diary.client_autoid=client.client_autoid", con);
DataSet ds1 = new DataSet();//from bill,client,diary where bill.bill_autoid=diary.bill_autoid and client.client_autoid=diary.client_autoid and bill.bill_state='" + bill_state1 + "'
sda1.Fill(ds1, "per1");
this.DataGrid2.DataSource = ds1.Tables["per1"];
this.DataGrid2.DataBind();
说明这段的意思是。用DataGrid列出对应着id 号的,姓 名, 证件种类 ,证件号码, 航空保险, 票 号 这几个列。票号是用TextBox的。我想有个提交按钮,点击把就可以把票号TextBox这里的值更新到库里面。请问怎么改啊。太谢谢大家了
{
SqlConnection con = Operate.createCon();
SqlDataAdapter sda1 = new SqlDataAdapter();
sda1.SelectCommand = new SqlCommand("select client.client_name,clientpapers.papers_papers,clientpapers.papers_papersnumber,client.client_airinsurance,diary.airno from client,clientpapers,diary where client.client_autoid in(select client_autoid from diary where bill_autoid='" + bill_autoid + "') and clientpapers.client_autoid=client.client_autoid and diary.client_autoid=client.client_autoid", con);
DataSet ds1 = new DataSet();//from bill,client,diary where bill.bill_autoid=diary.bill_autoid and client.client_autoid=diary.client_autoid and bill.bill_state='" + bill_state1 + "'
sda1.Fill(ds1, "per1");
this.DataGrid2.DataSource = ds1.Tables["per1"];
this.DataGrid2.DataBind();
说明这段的意思是。用DataGrid列出对应着id 号的,姓 名, 证件种类 ,证件号码, 航空保险, 票 号 这几个列。票号是用TextBox的。我想有个提交按钮,点击把就可以把票号TextBox这里的值更新到库里面。请问怎么改啊。太谢谢大家了
不過你可以做成有超鏈接的在生成的時就加上QueryString那樣不就可以更新數據庫了嗎
foreach(DataGridItem item in 你的datagrid的Id.Items)
{
TextBox a = ((TextBox)item.FindControl("你的票号textbox的ID"));
string b = a.Text;
}b就是你要的。然后写个更新到数据库的语句即可
我想把diary这个表的id取出来用。把更新的数据存在这个表里。我怎么把他的id读出来呢
string diaryID=Request.QueryString["diaryID"].ToString();