In the Express Edition, I was wondering how to drag/drop bound fields to the form like you can do if your DB is in local SQL/Server, from a remote SQL/Server.
I am aware I can do this all in code with SQLConnection, SQLAdapter controls. I can then FILL/Update a dataset control in code, but it appears you can't do this at design time.
I'm also aware that Professional edition ($500+) has a server connect, but I don't have this.
Am I correct that in the express edition, this all has to be done in ado.net code?
Second question, if I were to have a replica of the database local and drag/drop and design the form from there, how do I then change the datasource to an external DB?
I've tried endlessly to look this up, so if anyone can point me to a reference, that would be great. Thx.
I am aware I can do this all in code with SQLConnection, SQLAdapter controls. I can then FILL/Update a dataset control in code, but it appears you can't do this at design time.
I'm also aware that Professional edition ($500+) has a server connect, but I don't have this.
Am I correct that in the express edition, this all has to be done in ado.net code?
Second question, if I were to have a replica of the database local and drag/drop and design the form from there, how do I then change the datasource to an external DB?
I've tried endlessly to look this up, so if anyone can point me to a reference, that would be great. Thx.