Tagged Questions

1
vote
3answers
43 views

Declare table variable in sqldatasource (aspnet)

I have a query that I try in Microsoft SQL Server Management Studio, and this query work fine: DECLARE @tableVariable TABLE (fecha DATE, valor Float); INSERT @tableVariable SELECT fecha, valor FROM ...
0
votes
0answers
31 views

SqlDataSource not being populated with parameter

I am executing an SSRS rpt and need to duplicate this in a web project with sqldatasource id's. The ssrs rpt parameters work perfectly as far as being populated, but when I try to get the same thing ...
1
vote
1answer
42 views

SqlDataSource won't retrieve logged in user's data from database?

I tried retrieving the user's data based on the logged in UserId, but no progress. Any suggestions? protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e) { // ...
0
votes
0answers
52 views

SQL request in Datasource

I would like to display messages from one table, and for each of these messages display all replies under the main message, much like on Facebook. I am using a SqlDataSource and a ListView because I ...
1
vote
0answers
71 views

How to make SQLDataSource insert into view instead of the underlying table?

We have replaced 20 tables with a consolidated table, that separates each set of data via a "set id" (all the records for table "A" have a set_id of 1, table "B" is 2, etc.). We then built views on ...
0
votes
3answers
551 views

Running a stored procedure in a SqlDataSource on button click

I am building a C# ASP.NET page where I want to call a stored procedure in a database. I have setup a SqlDataSource which points to the stored procedure. Parameters are obtained from the Web's ...
0
votes
4answers
2k views

.net 4 DataGridView does not update the database sqldatasource after adding, updating and deleting rows

I'm working on a big project and don't have much time to dwell on each problem, I'm using Windows Forms, particularly the DataGridView. I just added a data source that would query a table on the ...
1
vote
3answers
105 views

Static WHERE clause in SQLDatasource

I need to execute the query according to the Businessunit values which is to be passed in runtime. If the businessunit is null the AND condition should not get executed and if it is not null i have to ...
0
votes
0answers
150 views

Sql Data source option not appearing in visual studio 2010

I am working with sharepoint project. I want to show the details in grid view by connecting to the database. After I drag and drop the gridview to the Visual webpart surface and clicking on the Choose ...
0
votes
1answer
498 views

VB.Net data source connection error

i am using VS2008 VB.net and sql 2008. I tried to connect a new datasource using Microsoft SQL Server Database File (SqlClient) it gives an error; I tried to connect a new datasource using ...
1
vote
0answers
230 views

how to use a procedure with Default parameter in gridview ASP.NET VS in sqldatasource

I want to use a stored procedure that can make some parameters with null value and then test it if the parameter is null or not and do some coding , the procedure is working fine ... but when i want ...
1
vote
2answers
504 views

How to Extract data from a SQLDataSource to a datatable

Is it possible to store data that is retrieved by SqlDataSource in a DataTable? I mean, If I dragged and dropped a GridView and an SqlDataSource and then I set up those controls in page designer in ...
0
votes
0answers
1k views

Updating records using stored procedure .. in ASP.NET no access to the RowUpdating event

I'm facing a problem with updating rows in SQL Server When I want to update columns from a grid to a table in the SQL Server database using a stored procedure I have a problems with the onclick ...
0
votes
2answers
3k views

Change Gridview Datasource using ASP .NET SQLDATASOURCE

i have a gridview automaticly connecting with sqldatasource1, etc. For the grid, I also have a search textbox If the user needs to filter the records it calls an another ((sqldatasource2-another ...
0
votes
2answers
464 views

Change Gridview Datasource or Select statement ijn code?

I have a gridview with sqldatasource, etc. For the grid, I also have a search textbox. If the user needs to filter the records, I want to dynamically adjust the SELECT statement for the SqlDataSource ...

1 2
15 30 50 per page