SimplyMe
Member
Background: I am working with an application imported from VS 2002 into VS 2005.
I have 2 problems with ADO and perhaps someone can help me.
1. Column in a SQL 2000 DB Table inside a dataset does not change.
I expanded a column in a SQL DB Table from "smallint" to "integer".
Then, I right clicked the corresponding DataAdapter in the tray, then
re-configured the DataAdapter (although I did not really change anything),
Then I re-generated the table into its home Dataset and it semmed to work. (That's the way I've always done it in VS 2002).
But when I viewed the Schema, I found the column I changed is still
a "smallint". Did the same thing one more time and it is still a smallint
although the corresponding database column is in fact an "integer".
Somehow, I managed to edit the Dataset Table column to become an Integer (32 bits).
My question is, "Is this the way things are supposed to work and I am not
supposed to generate tables this way anymore?" Since I am working with
programs written in VS 2002, I have plenty of DataAdapters in many many forms.
2. Difficulty with DataAdapter
I created a new DB Table but when I dragged it from the Server Explorer
into a form, nothing happened. Nothing got added into the tray. While I
was dragging the table, a Black circle with a diagonal line appeared and
it seemed liked it was being dragged, but when I released the mouse inside
the form, it disappeared, and nothing happened!! I did it this way because it is the way I have always done it. Old habits die hard.
Anyway, I played with DataSources and somehow managed to add this new table into the Dataset, it even has some kind of Fill command at the bottom, I think that is the equivalent of a DataAdapter. But, I cannot refer to this DataApapter in the form's code, I get an error saying it is not a member of the form. The Dataset is in the tray and the table is in the dataset and the DataAdapter is attached to the table, but somehow, the IDE seems to be unaware of this.
How should I refer to this DataAdapter? I did not drag any of the new table's column into the form because I am not displaying its contents there.
Any answers or thoughts is appreciated.
I have 2 problems with ADO and perhaps someone can help me.
1. Column in a SQL 2000 DB Table inside a dataset does not change.
I expanded a column in a SQL DB Table from "smallint" to "integer".
Then, I right clicked the corresponding DataAdapter in the tray, then
re-configured the DataAdapter (although I did not really change anything),
Then I re-generated the table into its home Dataset and it semmed to work. (That's the way I've always done it in VS 2002).
But when I viewed the Schema, I found the column I changed is still
a "smallint". Did the same thing one more time and it is still a smallint
although the corresponding database column is in fact an "integer".
Somehow, I managed to edit the Dataset Table column to become an Integer (32 bits).
My question is, "Is this the way things are supposed to work and I am not
supposed to generate tables this way anymore?" Since I am working with
programs written in VS 2002, I have plenty of DataAdapters in many many forms.
2. Difficulty with DataAdapter
I created a new DB Table but when I dragged it from the Server Explorer
into a form, nothing happened. Nothing got added into the tray. While I
was dragging the table, a Black circle with a diagonal line appeared and
it seemed liked it was being dragged, but when I released the mouse inside
the form, it disappeared, and nothing happened!! I did it this way because it is the way I have always done it. Old habits die hard.
Anyway, I played with DataSources and somehow managed to add this new table into the Dataset, it even has some kind of Fill command at the bottom, I think that is the equivalent of a DataAdapter. But, I cannot refer to this DataApapter in the form's code, I get an error saying it is not a member of the form. The Dataset is in the tray and the table is in the dataset and the DataAdapter is attached to the table, but somehow, the IDE seems to be unaware of this.
How should I refer to this DataAdapter? I did not drag any of the new table's column into the form because I am not displaying its contents there.
Any answers or thoughts is appreciated.
