数据库问题,在线等,高手请进啊

Question

private void Supply_company_query()
{
string supplyCompany = comboBox1.Text;                   //获取comboBox1中的内容
string connectionString = "server = hujianfang;"+"database = hbqjcfdb;"+"user =sa;"+"password = sa";
SqlConnection mySqlConnection=new SqlConnection(connectionString);
try
{
string SelectString = "SELECT Ware_import_code,Supply_company,unload_group,Charge_man,truck_number,Re"
+ "FROM material_import_total"
 + "where Supply_company =" 
+ supplyCompany;
SqlCommand mySqlCommand=mySqlConnection.CreateCommand();
mySqlCommand.CommandText=SelectString;                    //查询命令
mySqlCommand.CommandType = CommandType.Text;
mySqlConnection.Open();                                    //连接数据库
SqlDataReader reader =
mySqlCommand.ExecuteReader(CommandBehavior.CloseConnection);
}
catch(Exception ex)
{
 MessageBox.Show(ex.Message.ToString());
 mySqlConnection.Close();
}
finally
{
  mySqlConnection.Close();
}
}
private void button1_Click(object sender, System.EventArgs e)
{
if(radioButton1.Checked)
commit_time_query();
if(radioButton2.Checked)
   Supply_company_query();
if(radioButton3.Checked)
unload_group_query();
if(radioButton1.Checked)
truck_number_query();
           listView1.GridLines =true;
}
先自己顶一个

Answer 1

这种错误 你就断点把sql取得 到数据库中跑一把就找到问题了

Answer 2

string SelectString = "SELECT Ware_import_code,Supply_company,unload_group,Charge_man,truck_number,Re"
+ "FROM material_import_total"
 + "where Supply_company =" 
+ supplyCompany;改成 如下 试试string SelectString = "SELECT Ware_import_code,Supply_company,unload_group,Charge_man,truck_number,Re"
+ "FROM material_import_total"
 + "where Supply_company ='" 
+ supplyCompany+"'";