if(dd.SelectedItem.Value=="学号")
{
string sql1="select a.zkzh, a.bdbj,a.xydm,a.zydm,a.bjdm, a.xm,a.bdzh,a.xh,a.lxdh,a.bmmc,a.zymc,bjqsch.qsh from (select xsxxb.zkzh, xsxxb.bdbj,xsxxb.xydm,xsxxb.zydm,xsxxb.bjdm, xsxxb.xm,xsxxb.bdzh,xsxxb.xh,xsxxb.lxdh,bmb.bmmc,zyb.zymc from xsxxb,bmb,zyb where xsxxb.zydm=zyb.zydm and xsxxb.xydm=bmb.bmdm and xsxxb.xh='"+TextBox1.Text+"') a left join bjqsch on bjqsch.xh=a.xh";
SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
SqlDataAdapter da1=new SqlDataAdapter(sql1,conn);
DataSet ds1=new DataSet();
conn.Open();
da1.Fill(ds1,"xsxxb1");
if (ds1.Tables["xsxxb1"].Rows.Count==0)
{
TextBox2.Text="";TextBox3.Text="";TextBox4.Text="";TextBox5.Text="";
TextBox6.Text="";TextBox7.Text="";TextBox8.Text="";TextBox9.Text="";
Image10.Visible=true;
Image10.ImageUrl="images/wu.gif";
Image2.Visible=false;