JonnyR
February 24th, 2010, 03:50 AM
Hi,
'Theory' or 'Practice' question here-
I am writing a client for a SQL Server DB- I have a copy of the DB locally on my laptop as well as on a server.
I knew my local schema was slightly off, but thought it would not matter much.
Anyway after three days programming I had a nice working prototype.
Plugging in to the server I found a column name was wrong (which I knew), and the DB name was ....2 not ...
CHanging these in code is a snip, as was updating the copy DB, BUT the design time controls in C# are a nightmare- they are 'binding' in the background to the old schema / DB name.
The form now refuses to run.
I can't find the text forms of the auto code to correct, and those that I can are regenerated so an edit does not work. Going through the GUI, I can address the SQL code 'Select from' or whatever, but cannot get 'to' the DB name. I can't seem to kick the Wizard back in to re-auto gen the table name etc (and what i can get to crashes as the DB is no longer available).
SO- is there an example of how to do this? What is 'practice' for a problem such as this?
SHould I just back up the code, delete the Chart objects & re drag & drop?
Seems crazy you cannot access the code- or have I something wrong.
Any advise gratefully received.
J.
'Theory' or 'Practice' question here-
I am writing a client for a SQL Server DB- I have a copy of the DB locally on my laptop as well as on a server.
I knew my local schema was slightly off, but thought it would not matter much.
Anyway after three days programming I had a nice working prototype.
Plugging in to the server I found a column name was wrong (which I knew), and the DB name was ....2 not ...
CHanging these in code is a snip, as was updating the copy DB, BUT the design time controls in C# are a nightmare- they are 'binding' in the background to the old schema / DB name.
The form now refuses to run.
I can't find the text forms of the auto code to correct, and those that I can are regenerated so an edit does not work. Going through the GUI, I can address the SQL code 'Select from' or whatever, but cannot get 'to' the DB name. I can't seem to kick the Wizard back in to re-auto gen the table name etc (and what i can get to crashes as the DB is no longer available).
SO- is there an example of how to do this? What is 'practice' for a problem such as this?
SHould I just back up the code, delete the Chart objects & re drag & drop?
Seems crazy you cannot access the code- or have I something wrong.
Any advise gratefully received.
J.