Thanks, it turns out that we had to update the SQL express settings, I'm able to access the database locally from other directories on this system. I will be setting up to try it networked here in a few hours.
In the meantime, I do have another question on the same lines:
I am trying to get a report-type output, generated by specific search parameters entered by the users of the program, in order to pull the results from the SQL express 05 database. I have read alot of articles that talk about creating new queries in the tableadapter, but it's still clear as mud to me.
Example of what I'm trying to do:
User inputs stringA which represents data in column1 and stringB represents data in columnc;
I'd like to generate a datagridview that dynamically changes based on the data the person enters, ie: there are 6 different columns to choose data from.
I'm getting stuck with trying to figure out how to make a new sql query using the query creation wizard "thing" that pops up when you tell the tableadapterdataset to create a new query. I could be going about this the wrong way, but I'm totally lost and need some help..someone throw me a life preserver, I'm goin down...
Thanks.
|