问题描述
usingSystem;usingSystem.Collections.Generic;usingSystem.Data.SqlClient;usingSystem.Linq;usingSystem.Web;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Data;publicpartialclass_963:System.Web.UI.Page{protectedvoidPage_Load(objectsender,EventArgse){}protectedvoidDropDownList1_SelectedIndexChanged(objectsender,EventArgse){}protectedvoidTextBox1_TextChanged(objectsender,EventArgse){}protectedvoidButton1_Click(objectsender,EventArgse){stringconnectionstring=@"DataSource=10.0.8.172;InitialCatalog='工会侯俊威';PersistSecurityInfo=True;UserID=sa;Password=15rj";SqlConnectionconn=newSqlConnection(connectionstring);conn.Open();stringsqlstring="select*fromzhubiaowhere姓名='"+TextBox1.Text+"'and性别='"+DropDownList2.SelectedItem.Value+"'and民族='"+DropDownList3.SelectedItem.Value+"'";SqlDataAdapteradapter=newSqlDataAdapter(sqlstring,conn);DataTabletable2=newDataTable();adapter.Fill(table2);GridView1.DataSource=table2;GridView1.DataBind();conn.Close();}}
解决方案
解决方案二:
"select*fromzhubiaowhere姓名='"+TextBox1.Text+"'and性别='"+DropDownList2.SelectedItem.Value+"'and民族='"+DropDownList3.SelectedItem.Value+"'";查看一下,这个条件值同数据库列的类型是否一致如果数据库是int,你传的为字符串会报错