bahrambasati
جمعه 22 اردیبهشت 1391, 19:24 عصر
می خواستم ازطریق این کد داده مورد نظر رو درون text boxبریزم.ولی اشکال میگیره.لطفا راهنمایی کنید
SqlConnection cnn = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirecto ry|\\Database1.mdf;Integrated Security=True;User Instance=True");
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter("select * from food where code=@code",cnn);
sda.SelectCommand.Parameters.AddWithValue("@code",textBox1.Text);
cnn.Open();
sda.Fill(ds,"x");
textBox1.DataBindings.Clear();
textBox1.DataBindings.Add("Text", ds, "namefood");
cnn.Close();
Cannot bind to the property or column namefood on the DataSource.
Parameter name: dataMember
SqlConnection cnn = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirecto ry|\\Database1.mdf;Integrated Security=True;User Instance=True");
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter("select * from food where code=@code",cnn);
sda.SelectCommand.Parameters.AddWithValue("@code",textBox1.Text);
cnn.Open();
sda.Fill(ds,"x");
textBox1.DataBindings.Clear();
textBox1.DataBindings.Add("Text", ds, "namefood");
cnn.Close();
Cannot bind to the property or column namefood on the DataSource.
Parameter name: dataMember