PDA

View Full Version : textbox databinding



محمد هدایتی
جمعه 01 مرداد 1389, 21:09 عصر
. string strr;
strr = comboBox1.Text;
SqlConnection objConnection = new SqlConnection("Data Source=.;Initial Catalog=h;Integrated Security=True");
SqlCommand objCommand = new SqlCommand();
objCommand.Connection = objConnection;
SqlDataAdapter objDataAdapter = new SqlDataAdapter();
DataSet objDataSet = new DataSet();
objDataAdapter.SelectCommand = new SqlCommand();
objDataAdapter.SelectCommand.Connection=objConnect ion;
objDataAdapter.SelectCommand.CommandText = "select PkParvandeId from Bimar " + " where name = " + " ' " + comboBox1.Text + " ' ";
objDataAdapter.SelectCommand.CommandType = CommandType.Text;

objDataAdapter.Fill(objDataSet,"icc");
DataView objDataView = new DataView(objDataSet.Tables["icc"]);

CurrencyManager objCurrencyManager;
objCurrencyManager = (CurrencyManager)(this.BindingContext[objDataView]);

textBox9.DataBindings.Clear();
textBox9.DataBindings.Add(" Text ", objDataView, " PkParvandeId");

objCommand.CommandText="INSERT INTO resid "+" (pkshomareresid,FkParvandeId_Bimar,mablagh,tarikhe sodor) " + " VALUES(@pkshomareresid,@FkParvandeId_Bimar,@mablag h,@tarikhesodor)";
objCommand.Parameters.AddWithValue("@pkshomareresid",textBox8.Text);
objCommand.Parameters.AddWithValue("@FkParvandeId_Bimar",textBox9.Text);
objCommand.Parameters.AddWithValue("@mablagh",textBox6.Text);
objCommand.Parameters.AddWithValue("@tarikhesodor",textBox7.Text);
objConnection.Open();
objCommand.ExecuteNonQuery();

objConnection.Close();

سلام دوستان من این برنامه را برای ثبت اطلاعات در یک جدول resid نوشتم که با جدول Bimar از طریق فیلد خارجی FkParvandeId_Bimar ارتباط داره ولی در این قسمت

textBox9.DataBindings.Clear();
textBox9.DataBindings.Add(" Text ", objDataView, " PkParvandeId");
این error را می دهد


Cannot bind to the property ' Text ' on the target control
Parameter name: PropertyName

gwbasic
شنبه 02 مرداد 1389, 07:48 صبح
فاصله قبل و بعد Text رو بردار و همینطور PkParvandId