Tagged Questions
0
votes
2answers
31 views
How to get a gridview to show all table rows when no text is entered in a dependent textbox?
The below works correctly and filters my gridview based on the text entered in my textbox.
When no text is entered into my textbox I get no results and cannot understand why.
MY QUESTION
How to get ...
0
votes
0answers
92 views
VB.NET T-SQL error retrieving SCOPE_IDENTITY() value with SQLDATASOURCE
I'm using Scope_Identity() and I cannot figure out why the new ID value isn't being retrieved on insert. I was hoping someone could see what I am missing. I am getting the following error:
...
1
vote
3answers
197 views
“Server” vs “Data Source” in connection string
I'm new to SqlServer, right now I have SqlLocalDb installed to work locally. Good, but I can see two connection strings typically and both works:
Data Source=(localdb)\v11.0;Integrated Security=true;
...
0
votes
3answers
122 views
Giving alias in JOIN command in sqldatasource
I am using JOIN command to connect two tables in SqlDataSource.
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:CS %>"
...
0
votes
3answers
279 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
99 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 ...
2
votes
1answer
204 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)
{
// ...
1
vote
0answers
112 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
3k 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
134 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
163 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
543 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
267 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
754 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 ...
