ffreydon
شنبه 21 اردیبهشت 1392, 17:22 عصر
کد زیر را نوشتم جواب میده اما پیغام خطای زیر را هم میده:
No mapping exists from object type System.Data.DataRowView to a known managed provider native type.
کد هم اینه:
try
{
SqlConnection objConnection = new SqlConnection("Data Source=.;Initial Catalog=Products;Integrated Security=True");
SqlDataAdapter objDataAdapter = new SqlDataAdapter();
DataSet objDataSet = new DataSet();
objDataAdapter.SelectCommand = new SqlCommand();
objDataAdapter.SelectCommand.Connection = objConnection;
objDataAdapter.SelectCommand.CommandText = "SELECT PacketID FROM Packets";
objDataAdapter.SelectCommand.CommandType = CommandType.Text;
objConnection.Open();
objDataAdapter.Fill(objDataSet,"Packets");
objConnection.Close();
cmbPacketID.DataSource = objDataSet.Tables[0];
cmbPacketID.DisplayMember = "PacketID";
cmbPacketID.ValueMember = "PacketID";
objDataAdapter = null;
objConnection = null;
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
try
{
SqlConnection objConnection = new SqlConnection("Data Source=.;Initial Catalog=Products;Integrated Security=True");
SqlDataAdapter objDataAdapter = new SqlDataAdapter();
DataSet objDataSet = new DataSet();
objDataAdapter.SelectCommand = new SqlCommand();
objDataAdapter.SelectCommand.Connection = objConnection;
objDataAdapter.SelectCommand.CommandText = "SELECT ProductName FROM Product,Product_Version WHERE PacketID=1 AND Product_Version.ProductID=Product.ProductID";
objDataAdapter.SelectCommand.Parameters.AddWithVal ue("@PacketID", cmbPacketID.SelectedValue);
objDataAdapter.SelectCommand.CommandType = CommandType.Text;
objConnection.Open();
objDataAdapter.Fill(objDataSet, "Product");
objConnection.Close();
cmbPrPackage.DataSource = objDataSet.Tables[0];
cmbPrPackage.DisplayMember = "ProductName";
cmbPrPackage.ValueMember = "ProductName";
objDataAdapter = null;
objConnection = null;
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
No mapping exists from object type System.Data.DataRowView to a known managed provider native type.
کد هم اینه:
try
{
SqlConnection objConnection = new SqlConnection("Data Source=.;Initial Catalog=Products;Integrated Security=True");
SqlDataAdapter objDataAdapter = new SqlDataAdapter();
DataSet objDataSet = new DataSet();
objDataAdapter.SelectCommand = new SqlCommand();
objDataAdapter.SelectCommand.Connection = objConnection;
objDataAdapter.SelectCommand.CommandText = "SELECT PacketID FROM Packets";
objDataAdapter.SelectCommand.CommandType = CommandType.Text;
objConnection.Open();
objDataAdapter.Fill(objDataSet,"Packets");
objConnection.Close();
cmbPacketID.DataSource = objDataSet.Tables[0];
cmbPacketID.DisplayMember = "PacketID";
cmbPacketID.ValueMember = "PacketID";
objDataAdapter = null;
objConnection = null;
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
try
{
SqlConnection objConnection = new SqlConnection("Data Source=.;Initial Catalog=Products;Integrated Security=True");
SqlDataAdapter objDataAdapter = new SqlDataAdapter();
DataSet objDataSet = new DataSet();
objDataAdapter.SelectCommand = new SqlCommand();
objDataAdapter.SelectCommand.Connection = objConnection;
objDataAdapter.SelectCommand.CommandText = "SELECT ProductName FROM Product,Product_Version WHERE PacketID=1 AND Product_Version.ProductID=Product.ProductID";
objDataAdapter.SelectCommand.Parameters.AddWithVal ue("@PacketID", cmbPacketID.SelectedValue);
objDataAdapter.SelectCommand.CommandType = CommandType.Text;
objConnection.Open();
objDataAdapter.Fill(objDataSet, "Product");
objConnection.Close();
cmbPrPackage.DataSource = objDataSet.Tables[0];
cmbPrPackage.DisplayMember = "ProductName";
cmbPrPackage.ValueMember = "ProductName";
objDataAdapter = null;
objConnection = null;
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}