navid1n2000
شنبه 07 آذر 1388, 00:41 صبح
من وقتي ميخوام اطلاعاتمو از يك جدول به اسم vam بگيرم اين كدو نوشتم :
SqlConnection objConnection = new SqlConnection("Server=ASAD-2DB92FD23F;Database=VamDB;Integrated Security = True");
SqlDataAdapter objDataAdapter = new SqlDataAdapter();
DataView objDataView;
DataSet objDataSet;
objDataAdapter.SelectCommand = new SqlCommand();
objDataAdapter.SelectCommand.Connection = objConnection;
objDataAdapter.SelectCommand.CommandText = "SELECT * FROM Vam WHERE VamTypeId ="+ comboBox1.SelectedValue+"";
objDataAdapter.SelectCommand.CommandType = CommandType.Text;
objDataSet = new DataSet();
objConnection.Open();
objDataAdapter.Fill(objDataSet, "Vam");
objConnection.Close();
objDataView = new DataView(objDataSet.Tables["Vam"]);
اين ارور رو داده :
http://up.iranblog.ir/4/1259358784.jpg
دليل چيه ؟
SqlConnection objConnection = new SqlConnection("Server=ASAD-2DB92FD23F;Database=VamDB;Integrated Security = True");
SqlDataAdapter objDataAdapter = new SqlDataAdapter();
DataView objDataView;
DataSet objDataSet;
objDataAdapter.SelectCommand = new SqlCommand();
objDataAdapter.SelectCommand.Connection = objConnection;
objDataAdapter.SelectCommand.CommandText = "SELECT * FROM Vam WHERE VamTypeId ="+ comboBox1.SelectedValue+"";
objDataAdapter.SelectCommand.CommandType = CommandType.Text;
objDataSet = new DataSet();
objConnection.Open();
objDataAdapter.Fill(objDataSet, "Vam");
objConnection.Close();
objDataView = new DataView(objDataSet.Tables["Vam"]);
اين ارور رو داده :
http://up.iranblog.ir/4/1259358784.jpg
دليل چيه ؟