By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,919 Members | 1,587 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,919 IT Pros & Developers. It's quick & easy.

Problem With Fill

P: n/a
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
Nov 18 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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

Nov 18 '05 #2

P: n/a
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" <an*******@discussions.microsoft.com> wrote in message
news:91**********************************@microsof t.com...
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 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

Nov 18 '05 #3

P: n/a
Also, I can use the option to Preview the data and it works fine?

Wayne

"Suresh" <an*******@discussions.microsoft.com> wrote in message
news:91**********************************@microsof t.com...
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 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

Nov 18 '05 #4

P: n/a
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" <an*******@discussions.microsoft.com> wrote in message
news:91**********************************@microsof t.com...
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 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

Nov 18 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.