mysql - Foreign key column not shown in vs Dataset DataTable -
I have created a process with the primary key constraint. It is working fine now I now have a dataset I will try to add the process -> Use the current stored procedure -> table adapter -> Finish This foreign key does not show the column How can I fix this error?
If you use the fill method for the data source, this schema Does not add data to the dataset. From to
To populate a dataset with the existing primary key constraint information from a data source, you can either call the FillSchema method to call data adapter, or fill Before you add the DataAdapter's MissingSchemaAction property to AddAffairs.
How to add schema information to a dataset using FillSchema .
DataSet custDataSet = new DataSet (); CustAdapter.FillSchema (custDataSet, Schema Type. Source, "Customer"); CustAdapter.Fill (custDataSet, "Customer");
DataSet custDataSet = new dataset (); CustAdapter.MissingSchemaAction = MissingSchelection AddWithKey; CustAdapter.Fill (custDataSet, "Customer");
Comments
Post a Comment