Datagrid Display

asters · February 18th, 2009, 08:38 AM

I formally used ms access as my database.
When i needed to display a table information in my datagrid i used this code in the form_load sub

Code:

 asterdataset1.clear()
 asteroledbdataadapter.fill(asterdataset1)

However when i changed my database to ms sql this code does not work.
I have my imports system.data.sqlclient in place.
I have my datasets and adapters configured and code in form_load same;

Code:

 asterdataset2.clear()
 astersqldataadapter.fill(asterdataset2)

The error i get reads:
an unhandled exception of type 'system.data.sqlclient.sqlexception' occurred in system.data.dll

gbianchi · February 18th, 2009, 08:41 AM

Hi...

What if you do a try catch to get info about the error??

and maybe, maybe, the SQL you are using to get the data is failing?

asters · February 19th, 2009, 05:02 AM

The error i get reads:
an unhandled exception of type 'system.data.sqlclient.sqlexception' occurred in system.data.dll

fedrik · February 19th, 2009, 06:04 AM

But through MS access I am not able to ms access as my database. Showing error.

----------------------------
Database archiving

gbianchi · February 19th, 2009, 08:01 AM

I will ask again. Does the query work in SQL server?

asters · February 19th, 2009, 11:44 AM

I am currently work with ms sql server and still geting the error above.

asters · February 19th, 2009, 12:00 PM

I have followed the advice on a topic on this site.
Link is http://aspalliance.com/124_All_You_N...ONET_Part_12.4

I used

Code:

 
SqlDataAdapter1.Fill(MyDataSetName, "Table_Name")

In the form load of the datagrid and i still get the error:

An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll
Additional Information: System error

What can this error be since i have done exactly what the document in the link above says.

gbianchi · February 19th, 2009, 12:12 PM

I will ask for the third time (since you are not answering my question). Does the query work inside SQL server?

Please show us your query.

asters · February 19th, 2009, 02:15 PM

Yes this query works on the sql server.

Below is the query

SELECT AccountNum, LastName, FirstName, PolicyNumber, Premium
FROM INSURE_TABLE

This is the same query in the Data Adapter Configuration Wizard.

gbianchi · February 19th, 2009, 02:20 PM

Thanks, then could be a code issue.
Maybe you forget something when you translate the object to the sqlclient.. can you show us some code so we can see is something is wrong?? also, could you try to connect to something else in the database to see if it is really working?

The error is to generic to have an idea of what is happening.

If you bound the grid (just as a trial) do it connect correctly and fetch data from the database??