SqlDataAdapter sda = new SqlDataAdapter();这句代码的意思

SqlDataAdapter sda = new SqlDataAdapter();这句代码的意思

新建了一个数据适配器对象

string strcon = "data source=(local);initial catalog=ticket;integrated security=true"; dataset ds = new dataset(); using(sqlconnection conn = new sqlconnection()) { conn = new sqlconnection(strcon); conn.open(); string strsql = "select * from tb_ticket where tnum like'%" + textbox1.text.trim() + "%'and startingpoint ='" + dropdownlist1.selecteditem.text.trim() + "'and endpoint='" + dropdownlist2.selecteditem.text.trim() + "'"; try { sqldataadapter sda = new sqldataadapter(strsql, conn); sda.fill(ds, "ticket"); }catch(exception ex){ throw ex.tostring(); } if(dt.rows.count>0) { response.write("<script>alert('已经执行并成功')</script>"); } gridview1.datakeynames = new string[] { "id" }; gridview1.datasource = ds.tables["ticket"]; session["id"] = gridview1.datakeynames; gridview1.databind(); ps:如果语句没问题并已经检索执行【sqldataadapter sda = new sqldataadapter(strsql, conn);】则返回已经执行并成功，如果语句有问题则报黄页，如果执行成功数据库为空则什么都不做。