toorkaman
یک شنبه 11 مهر 1389, 10:46 صبح
با سلام
ایراد کدهای من که کد جستجو است و بر اساس مورد جستجو است در چیست
string SQLSTR;
DataSet DS;
switch (ComboBox2.SelectedIndex)
{
case 0:
SQLSTR = "SELECT * FROM univer WHERE univerr=\'" + TextBox3.Text + "\'";
break;
case 1:
SQLSTR = "SELECT * FROM univer WHERE reshte=\'" + TextBox3.Text + "\'";
break;
case 2:
SQLSTR = "SELECT * FROM univer WHERE maghtah=\'" + TextBox3.Text + "\'";
break;
case 3:
SQLSTR = "SELECT * FROM univer WHERE nezam=\'" + TextBox3.Text + "\'";
break;
default:
SQLSTR = "SELECT * FROM univer";
break;
}
sqlDataAdapter(SQLSTR, objconn);
DS = new DataSet();
DA.Fill(DS, "univer");
dataGridView1.DataBindings.Add(new Binding("DataSourceU", DS, "daneshjo"));
dataGridView1.DataBindings.Clear();
ایراد کدهای من که کد جستجو است و بر اساس مورد جستجو است در چیست
string SQLSTR;
DataSet DS;
switch (ComboBox2.SelectedIndex)
{
case 0:
SQLSTR = "SELECT * FROM univer WHERE univerr=\'" + TextBox3.Text + "\'";
break;
case 1:
SQLSTR = "SELECT * FROM univer WHERE reshte=\'" + TextBox3.Text + "\'";
break;
case 2:
SQLSTR = "SELECT * FROM univer WHERE maghtah=\'" + TextBox3.Text + "\'";
break;
case 3:
SQLSTR = "SELECT * FROM univer WHERE nezam=\'" + TextBox3.Text + "\'";
break;
default:
SQLSTR = "SELECT * FROM univer";
break;
}
sqlDataAdapter(SQLSTR, objconn);
DS = new DataSet();
DA.Fill(DS, "univer");
dataGridView1.DataBindings.Add(new Binding("DataSourceU", DS, "daneshjo"));
dataGridView1.DataBindings.Clear();