انا عملت برنامج عن طريق microsoft visual c#.net 2005 وعملت قاعدة بيانات عن طريق sql server 2012 وجعلت قاعدة البيانات 2005 وبعد ما كتبت الكود بتاع البرنامج وربط قاعدة البيانات بالبرنامج الاحظ ان يعمل error handle عندما اعمل بحث عن بيانات فى datagridview واليك كود البحث :-
privatevoid rdoDate_CheckedChanged(object sender, EventArgs e)
{
RadioButton rdoDate = (RadioButton)sender;
if (rdoDate.Checked)
{
conn.Open();
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
string cmdStr = "";
switch (rdoDate.Name)
{
case "rdoPerson":
cmdStr =
"Select Distinct resName from GimResg";
break;
case "rdoDate":
cmdStr =
"Select Distinct resDate from GimResg";
break;
case "rdoAddre":
cmdStr =
"Select Distinct resAddre from GimResg";
break;
case "rdoWzn":
cmdStr =
"Select Distinct resWzn from GimResg";
break;
case "rdoTele":
cmdStr =
"Select Distinct resTele from GimResg";
break;
case "rdoType":
cmdStr =
"Select Distinct resType from GimResg";
break;
case "rdoID":
cmdStr =
"Select Distinct resIDD from GimResg";
break;
case "rdoNum":
cmdStr =
"Select Distinct resNumb from GimResg";
break;
case "rdoGender":
cmdStr =
"Select Distinct resGender from GimResg";
break;
}
cmd.CommandText = cmdStr;
OleDbDataReader reader = cmd.ExecuteReader(); ---------> هنا يظهر error handle
cboSearch.Items.Clear();
while (reader.Read())
{
cboSearch.Items.Add(reader[0].ToString());
}
reader.Close();
conn.Close();
}
}
واتمنى التوفيق منكم
