محمد هدایتی
جمعه 01 مرداد 1389, 22: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
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