0
votes
0answers
364 views

Passing parameters to stored procedure in data view web part

I have a stored procedure which accepts 2 parameters. The stored proc is executed as EXEC MySP N'Val1, Val2', N'A,B,C' I inserted a Data View Web-Part and tried to get data from stored procedure. ...
0
votes
3answers
1k views

Dataview Web part and SQL - Way to use trusted connection?

As I'm sure you're already aware one of the biggest weaknesses of the data view web part is that it exposes connection strings for SQL Server connections. Instead of using a web service to pass my ...
1
vote
0answers
126 views

Dataview Web Part only works when pulling 110 lines or less of SQL

I recently started playing with the data view web part in SharePoint Designer. I've added a new data source and added a custom query. Unfortunately my queries appear to be limited to returning 110 ...
0
votes
1answer
786 views

How do I link (join) a sharepoint list and an external data source in a DVWP?

I've got an external data source (SQL Server) and a Sharepoint Custom List that I want to join in a single view using the data view web part. In theory this shouldn't be too hard, but I can't get it ...
0
votes
1answer
188 views

How do I get sorting to work in the DVWP when using custom SQL query to linked server?

WSS 3.0 I have a non-SQL database linked to a SQL database. I've created a datasource in SPD using a custom query to this database. select * from LINKEDDB...sometable I then created a data view ...
1
vote
1answer
487 views

SharePoint Dropdown Vaue not updating in to Dataview webpart with SQL backend

I have a data view webpart and its source is a sql server database table(2005). I have the data view setup to be able to edit some of the fields inside the dataview. Instead of providing the user ...