Problem With Fill

  • Thread starter Thread starter Wayne Wengert
  • Start date Start date
W

Wayne Wengert

I am attempting to follow a walkthrough that builds an ASP.Net page with a
datagrid that can be edited. I modified the example to use one of my tables
on a SQL 2000 Server. I built the sqladapter, the connection and the dataset
without any errors but when I try to run the app I get an error pointing to
the command:

SqlDataAdapter1.Fill(DsUnitEvals1)



Any suggestions on how to debug this would be appreciated.

Wayne
 
What's the exact SQL statement you are passing into SQL server

If you have permission you can SQL Profiler to trace your call and see exactly what you sending to the SQL server

Suresh

----- Wayne Wengert wrote: ----

I am attempting to follow a walkthrough that builds an ASP.Net page with
datagrid that can be edited. I modified the example to use one of my table
on a SQL 2000 Server. I built the sqladapter, the connection and the datase
without any errors but when I try to run the app I get an error pointing t
the command

SqlDataAdapter1.Fill(DsUnitEvals1



Any suggestions on how to debug this would be appreciated

Wayn
 
The Select string is:

SELECT ID, UnitID, Evaluator, JudgeID, TapeReview, RecapReview, UnitProtest,
Observation, JudgeName, JudgeCaption, RegScoring, WCScoring, TapeDialog,
Conduct, Comments, AvgScore, LastUpdated FROM dbo.judgeevalsbyunits

I do not have permissions to use SQL Profiler. The query runs fine in QA?

Wayne


Suresh said:
What's the exact SQL statement you are passing into SQL server?

If you have permission you can SQL Profiler to trace your call and see
Click to expand...
exactly what you sending to the SQL server.
 
Also, I can use the option to Preview the data and it works fine?

Wayne

Suresh said:
What's the exact SQL statement you are passing into SQL server?

If you have permission you can SQL Profiler to trace your call and see
Click to expand...
exactly what you sending to the SQL server.
 
I noticed that the Select string in the sqlconnection string does not
include the password for my database. I tried adding that but it seems that
VSNET doesn't accept that (it disappears when I build)?. How is it supposed
to work when a database is password protected?

Wayne

Suresh said:
What's the exact SQL statement you are passing into SQL server?

If you have permission you can SQL Profiler to trace your call and see
Click to expand...
exactly what you sending to the SQL server.
 
Back
Top