日期:2014-05-18  浏览次数:20873 次

C#GridView無法显示查询结果
前台代码:
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
  CellPadding="4" 
  ForeColor="#333333" GridLines="None" 
  OnRowDeleting="GridView1_RowDeleting" 
  OnRowEditing="GridView1_RowEditing"
   
  OnRowCancelingEdit="GridView1_RowCancelingEdit">
  <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
  <Columns>
  <asp:BoundField DataField="ID" HeaderText="客户编号" ReadOnly="True"/>
  <asp:BoundField DataField="Master_Name" HeaderText="客户姓名" />
  <asp:BoundField DataField="Master_address" HeaderText="客户地址" />
  <asp:BoundField DataField="Master_tel" HeaderText="客户电话" />
  <asp:BoundField DataField="Mark" HeaderText="备注" />
  <asp:CommandField HeaderText="选择" ShowSelectButton="True" />
  <asp:CommandField HeaderText="编辑" ShowEditButton="True" />
   
  <asp:CommandField HeaderText="删除" ShowDeleteButton="true" />  
  </Columns>
  <RowStyle ForeColor="#000066" />
  <SelectedRowStyle BackColor="#669999" Font-Bold="true" ForeColor="White" />
  <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
  <HeaderStyle BackColor="#006699" Font-Bold="true" ForeColor="White" />
  </asp:GridView>
后台BUTTON代码:
 string sqlstr = "select id ,master_name ,master_address ,master_tel ,mark from master where master_name like '" + tbx_select_name.Text + "' and master_tel like '" + tbx_select_tel.Text + "'";
  sqlcon=new OleDbConnection(strcon);//strcon定义的语句为:string strcon="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\\data\\HMS.mdb";
  OleDbDataAdapter myda = new OleDbDataAdapter(sqlstr, sqlcon);
  DataSet myds = new DataSet();
  sqlcon.Open();
  myda.Fill(myds,"表");
  GridView1.DataSource = myds;
  GridView1.DataKeyNames = new string[]{ "id"};
  GridView1.DataBind();
  sqlcon.Close();

SQL在ACCESS里直接是查的出来数据的。为什么结果不显示在GRIDVIEW里,请救,谢谢!

------解决方案--------------------
你把like换成等号试试,like一般需要配合% _这类通配符的。