PDA

View Full Version : سوال: عدم ذخیره اطلاعات در بانک بدون رخ دادن خطا



toorkaman
شنبه 29 آبان 1389, 09:12 صبح
سلام روزتون بخیر

کد زیر رو وقتی اجرا میکنم چیزی رو از پایگاه داده نمایش نمی دهد و اروری هم نمی گیرد
مرا راهنمایی کنید
با تشکر فراوان


private void jostejo_Click(object sender, EventArgs e)
{
objconn.Open();
switch (comboBox2.SelectedIndex)
{
case 0:
SQLSTR = "select univer as 'دانشکده',reshte as 'رشته',maghtah as 'مقطع',nimsal as 'نیمسال' ,nezam as 'نظام' , men as 'مرد' from ict where univer =\'" + textBox1.Text + "\'";
break;

case 1:
SQLSTR = "select univer as 'دانشکده',reshte as 'رشته',maghtah as 'مقطع',nimsal as 'نیمسال' ,nezam as 'نظام' , men as 'مرد' from ict where reshte =\'" + textBox1.Text + "\'";
break;

case 2:
SQLSTR = "select univer as 'دانشکده',reshte as 'رشته',maghtah as 'مقطع',nimsal as 'نیمسال' ,nezam as 'نظام' , men as 'مرد' from ict where maghta =\'" + textBox1.Text + "\'";
break;

case 3:
SQLSTR = "select univer as 'دانشکده',reshte as 'رشته',maghtah as 'مقطع',nimsal as 'نیمسال' ,nezam as 'نظام' , men as 'مرد' from ict where nezam =\'" + textBox1.Text + "\'";
break;
}

SqlDataAdapter objadapter = new SqlDataAdapter(SQLSTR, objconn);
DataSet DS = new DataSet();
objadapter.Fill(DS, "ict");
datagv1.DataBindings.Add(new Binding("DataSource", DS, "ict"));
datagv1.DataBindings.Clear();
objconn.Close();
}

robat7
شنبه 29 آبان 1389, 17:14 عصر
سلام
ببخشید چرا از علامت "\" قبل از single quotation استفاده کرده اید؟