Thanks for replying Tom.
Maybe I am missunderstanding. The dataset is still being generated based on parameters supplied by the user. It is not fixed data, but it is fixed types of data. When a user makes choices, the data is being retrieved from the database and filling the dataset at that...
The solution was that I had set up a seperate connection string when I made the Report Viewer forms. Not sure why I did it but that connection was pointing to the developer server. Easy fix once I figured out my error.
I have created a windows forms application with a SQL server backend. I am populating textboxes, listboxes, treeviews using Sql queries. I attached my database to SQL Server on the ‘client’ machine and the above all populate fine both in the development environment and when deployed.
I am also...
I have recieved the following error when trying to launch SSMS and have found many other instances online where people have had the same problem but no solution. Does anyone know what the fix is or where I could search further? Thanks.
'An error has occurred while trying to access the license...
Thanks for the reply Tom. That is what I would have expected and pretty much what I was doing. See my original post at the top. Why was that not working correctly? Again, I would get what I expected for the very first 'Product' that was queried. It would populate the 'Product' record and all...
The problem that I was running into had to do with getting items from a child table. I am running the query based on checked items in a treeview. If the item was checked then the query would obtain the 'Product' based on the checked node text. It would also search a second table to see it any...
Thanks for the reply. For anyone else who might run into this and find this thread:
I just figured it out about a half hour ago but spent quite a bit of time trying different things. I did figure out that my query was working fine so why would the datatable not fill correctly? Apparently...
Confused!!
I am trying to fill a DataTable with a DataSet using a SQL query with one parameter. The parameter is the Node text of a treeview whose checkbox has been checked. It will retrieve Products from one table and any associated Packages from a different table. I am using a FOR loop to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.