نیاز به کمک فوری
با سلام به خدمت دوستان محترم
من یه کد نوشتم که متاسفانه error داره من هم اکنون نیازمند یاری فوریتان هستم
private void txtCode_Leave(object sender, EventArgs e)
{
using (cnn=new SqlConnection(Properties.Settings.Default.dbDrogSt oreConnectionString))
{
cmd = cnn.CreateCommand();
cmd.CommandText = @"select Code from tbDrog ";
if (cnn.State==ConnectionState.Closed)
{
cnn.Open();
}
SqlDataReader dr = cmd.ExecuteReader();
List<E_Drog> lst = new List<E_Drog>();
while (dr.Read())
{
E_Drog q = new E_Drog()
{
Code = (int) dr["Code"]
};
lst.Add(q);
}
foreach (var item in lst)
{
if (item.Code==Int32.Parse(txtCode.Text))
{
selectInfo();
}
}
}
}
private void selectInfo()
{
using (cnn=new SqlConnection(Properties.Settings.Default.dbDrogSt oreConnectionString))
{
cmd = cnn.CreateCommand();
cmd.CommandText = @"select * from [tbDrog] where Code like " + "'" + Int32.Parse(txtCode.Text) + "'";
if(cnn.State==ConnectionState.Closed)
{
cnn.Open();
}
SqlDataReader dr = cmd.ExecuteReader();
List<E_Drog> lst=new List<E_Drog>();
while (dr.Read())
{
E_Drog q = new E_Drog()
{
Code = (int)dr["Code"],
ExplainUse = (string) dr["ExplainUse"],
FarsiName = (string) dr["FarsiName"],
LatinName = (string) dr["LatinName"],
Price = (string) dr["Price"],
ShortName = (string) dr["ShortName"],
UseFor = (string) dr["UseFor"]
};
lst.Add(q);
}
bsBuy.Add(lst);
BindInfo(bsBuy);
}
}
private void BindInfo(BindingSource bsbuy)
{
txtExplain.DataBindings.Add("Text", bsBuy, "ExplainUse");
txtFarsiName.DataBindings.Add("Text", bsBuy, "FarsiName");
txtLatinName.DataBindings.Add("Text", bsBuy, "LatinName");
txtPrice.DataBindings.Add("Text", bsBuy, "Price");
txtShortName.DataBindings.Add("Text", bsBuy, "ShortName");
txtDarmanKonande.DataBindings.Add("Text", bsBuy, "UseFor");
}
error اینه
Untitled.jpg
ممنون می شم اگه کمکم کنید
پاسخ با نقل قول