Hi,

I noticed another post similar to this, however I could not get my
issue solved.

I am using a datagrid, dataset and dataadapter to retrieve data from a
database view. I have done this successfully with tables and also
stored procedures. I could not use the table directly because I got an
error when I tried to create an SQLDataAdapter with visual studio
because the table had more than 100 columns in it. So I thought I would
create a view and use it.

System
1. SQL Server 2000 sp3 on Windows 2003
2. Visual Studio MDE2002 ver 7.0.9466
3. .Net Framework 1.0 ver 1.0.3705

Steps so far.
1.

2. Run in SQL Analyzer: select * from dbo.Web_WorkOrder where wonum =
'525794'

3. Capture using SQL profiler and Run in SQL Analyzer: exec
sp_executesql N'SELECT wonum, status, statusdate, worktype,
description, eqnum, location, faildate, changeby, changedate,
wopriority, ldkey, reportedby, reportdate, actstart, actfinish FROM
Web_WorkOrder WHERE (wonum = @WonumI)', N'@WonumI varchar(10)', @WonumI
= '525794'

Both of these work.

Regards,
Garry

problem with no rows being returned - but rows are there
returning SCOPE_IDENTITY() in Insert command with C# DataSets
VB.NET create JET database without ADOX
Select where in
Updating Row value when PK is known