The SqlDataSource control enables you to use a Web control to access data located in a relational database, including Microsoft SQL Server and Oracle databases. The SqlDataSource control uses ADO.NET classes to interact with any database supported by ADO.NET. You can use the SqlDataSource control ...
2
votes
0answers
95 views
Automatic creation of parameters with the SqlDataSource Control
I've recently converted an existing web application from 3.5 to framework 4.0 and noticed a page stopped working - with an "incorrect number of parameters" error.
Page is fairly simple and has a ...
2
votes
0answers
105 views
Dreamweaver data source won't work after the first try on Mac OS X
I have a problem with the Adobe Dreamweaver CS5 version 11.
I am running Mac OS X Leopard.
One fine day I found out about Adobe Dreamweaver's quick (& dirty) automated back-end programming.
I ...
2
votes
0answers
470 views
Can I use an <asp:SessionParameter Direction=“Output”/> to *set* a variable?
If I have a SqlDataSource with
InsertCommand="INSERT [Applications] ([UserID]) VALUES (@UserID);SELECT @ApplicationID=SCOPE_IDENTITY()"
Can I use a SessionParameter to store the returned value?
...
1
vote
0answers
73 views
Why HikariCP datasource in spring throwing “HikariCP Housekeeping Timer” exception?
In my Spring application I'm using HikariCP as my datasource. It's working fine. But one strange thing is happening.I'm sharing the scenarios here:
I have a login page where username and password ...
1
vote
0answers
204 views
How to filter using a dropdown in a gridview and display all values when none is selected
I have a web page with 3 values (1 text box, and 2 drop-downs) and displays result in a gridview. This is working great when the value that I want to search is in the drop-down. However, if the user ...
1
vote
0answers
114 views
SqlDataSource updating different fields with one UpdateCommand
I have a SqlDataSource that I would like to use for updating. I would be using two similar update commands, and I was wondering how I could do this in one SqlDataSource. I know how to do 'normal' ...
1
vote
0answers
620 views
getting return value from aspx sqldatasource
I've used the insert command through the code front in aspx and the output parameter is:
asp:Parameter Name="ReturnCustomerID" Type="String" Direction="Output"
and in the codebehind (C#) for ...
1
vote
0answers
121 views
adding order by to select command from webconfig
Hello I have an sql data source (below) and the select command is in the webconfig it is a simple select...from... . I use this select command a few times but the ORDER BY changes. Is there anyway to ...
1
vote
0answers
163 views
Set number of pages in gridview with custom source
Here is the scenario: I have gridView with sorting on TemplateField headers - SortExpression is set and gridView_Sorting function implemented.
I store sorting values and directions in ViewState.
I ...
1
vote
0answers
100 views
databinding with parameters to oracle via sql
We have a linked server set up in SQL Server to an oracle server.
I need to populate a gridview with some data. But I find that when I use a parameter with the datasource the query is very slow. ...
1
vote
0answers
1k views
Insert database row via ASP.net 4.5 GridView on-board functionality?
I would like to insert a database entry by using standard functions of my GridView and SqlDataSource. Has there been any update on this topic since the dirty workarounds some versions ago (e.g. see ...
1
vote
0answers
234 views
nested repeater each with sqldatasource
<asp:HiddenField ID="hfOrderState" Value="1" runat="server" />
<asp:SqlDataSource ID="ReadyOrders" runat="server" EnableCaching="true"
DataSourceMode="DataSet" ...
1
vote
0answers
152 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 ...
1
vote
0answers
223 views
Trouble handling exceptions with a SqlDataSource
I having trouble handling exception of a SqlDataSource. The SqlDataSource is currently being used by my ListView. My code doesn't seem to display an error message even though it looks correct to me. I ...
1
vote
0answers
392 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
0answers
521 views
SqlDataSource + Disabled Viewstate = Double DataBind
Here's a test page (.NET 4) I built to show the symptom I'm experiencing:
<%@ Page Language="C#" AutoEventWireup="true" ViewStateMode="Disabled" %>
<script runat="server">
protected ...
1
vote
0answers
705 views
java connection pool autocommit
I'm using for the first time the connection pool in java. The application that I'm writing is a web application deployed on oracle glassfish 3.1 and the resource connection pool is handled by it. I ...
1
vote
0answers
286 views
How to see foreign key value when showing a database in a DataGridView
I'm building a Windows forms application that connects to a database.
I used the generate database from model function in Visual Studio 2010 to create the database in SQL Server.
I have two tables:
...
1
vote
0answers
815 views
ASP.NET BoundFields not setting UpdateParameters
I have a few bound fields, but they don't seem to be setting the UpdateParameters for my SQL statement. I do have some code that runs on SqlDataSource Update to set UpdateParameters for non bound ...
0
votes
0answers
14 views
Does The Order In Which SQLDataSource Parameters Are Specified When Calling A Stored Procedure Matter?
If I'm calling a Stored Procedure in a Microsoft SQL Server database which requires parameters, using an SQLDataSource control on an ASP.NET page, do I have to pass the parameter values from the ...
0
votes
0answers
12 views
DataRowView does not contain a property with the name 'FormID'
I am having trouble using the data value within a listbox. The DataValueField and SelectedValue always shows an error for the property FormID.
<asp:ListBox ID="ListBox1" runat="server" ...
0
votes
0answers
24 views
GridView + DataKeyNames + BoundField, “must declare the scalar variable @…”
I'm trying to used Gridview, with sqldatasource and updatecommand.
My update command has 3 parameters, 2 of them works fine, but the one of the ID fails.
I tried all combinations of DataKeyNames + ...
0
votes
0answers
22 views
GridView Row Count after FilterExpression and Paging
I was using below code to count total row, But total row is not updating with filter expression.
protected void SqlDataSource1_Selected(object sender, SqlDataSourceStatusEventArgs e)
{
int ...
0
votes
0answers
16 views
Sqldatasource connect Oracle database with parameters, code behind not working
I need set 3 parameters in SQLDatasource, binding source to the gridview.
If I remove the parameters, and directly choose datasource from design view, it shows data correctly.
I guess after pass ...
0
votes
0answers
57 views
Bind columns from two tables of a database into one gridview (Nonprogrammatically) ASP.NET
There are several answers to this question across the internet but every one is programmatically, which is more complicated than necessary. There's a way to do it in visual studio with the built in ...
0
votes
0answers
19 views
Object reference not set to instance of an object gridView datasource
So I have been looking in to this over and over trying to find something on it. I am trying to set my Grid View dataSourceID manually. My GridView ("GridView1") is inside of a FormView ("FormView1"). ...
0
votes
0answers
21 views
Context.User.Identity.GetUserId() doesn't return any value
Why the following code doesn't return any data? There are values in the database for Context.User.Identity.GetUserId()
ASPX markup:
<asp:SqlDataSource ID="owner_information" runat="server" ...
0
votes
0answers
21 views
Passing Context.User.Identity.GetUserId() to an SQL statement returns no data
I have the following code but it doesn't seem to work. The <%= Context.User.Identity.GetUserId() %> has a value in the database but it's not returning any data..... Thanks
<asp:SqlDataSource ...
0
votes
0answers
22 views
How to exclude NULL values from DataBinder.Eval
I am trying to pull data from the same table where, one column only has about 10 values (Which I want to be bound to the header of my accordion menu in Asp.net) and the other column has over 100 ...
0
votes
0answers
24 views
How to set listitems to DropDownList in from database table without being exposed for SQL Injection?
All the other columns in GridView are using DataFields. GridView is populated visa DataSource property and DataTable.
this.GridView2.DataSource = dTable;
There's a DropDownList to be shown for ...
0
votes
0answers
41 views
How to fix connection leak error in glassfish 3.1.2?
I am seeing the below error in glassfish console:
WARNING: RAR5117 : Failed to obtain/create connection from connection pool [ ftpinboundpool ]. Reason : ...
0
votes
0answers
40 views
SQL Query fails in Visual Studio
I need to display data on a chart from a database. As far as I can tell, the chart has to be bound to a DataSource which in my case is a SqlDataSource. My query to get this data is:
SELECT A.a, A.b, ...
0
votes
0answers
16 views
ASP.NET GridView show edit button only if SQLDataSource value is specific
I have a GridView with auto generated Edit buttons, linked to an SQLDatasource with a "State" column in a table called "Leaves", Is there anyway that the Edit button appears only if the "State" of ...
0
votes
0answers
42 views
Dynamically update GridView results based on text entered into a textbox
I would like to dynamically update the results of a GridView based on characters that are entered into a textbox. My code currently works but only fires the update when the textbox loses focus or the ...
0
votes
0answers
24 views
ASP.Net Get Cookie values through SqlDataSource
I am trying to pass some of my cookie values into the sqldatasource as parameters. I've put the cookie name which is correct, but how do I get specific values of the cookie. Eg. name of cookie or ...
0
votes
0answers
80 views
Context variable cannot be resolved to a type MS SQL Server 2008 Tomcat 7 DataSource
I am trying to create a connection to an MS SQL Database using the context.xml and web.xml files but I am getting the following error:
An error occurred at line: 26 in the jsp file: ...
0
votes
0answers
167 views
RadioButton selection changing dropdownlist datasource
This should be terribly straightforward, but I'm missing something. I've got a dropdownlist populated by a SQLDataSource which has its SelectCommand set from code behind.
Upon initial page load, I ...
0
votes
0answers
39 views
C# Basic Active View Index Coding - Adding an Update View
I am attempting to do the code for an Update view on a multiview task.
The directions are as follows:
What is the index of the Update command in the RBL?
If this index is selected, then before ...
0
votes
0answers
129 views
When adding to the database in the code behind the databound GridView does not update
I am attempting to allow users to add items to a table in a database and would like the user to be able to see the update reflected in a DataBound GridView below. However, while the database is ...
0
votes
0answers
27 views
SqlDataSource with MySQL using MySQL Connector for .Net
I am stuck in configuring SqlDataSource Object for MySQL Connector 6.8.3
(.Net Client). I have done the following so far.
<asp:SqlDataSource ID="SDS_Orders"
...
0
votes
0answers
58 views
SQldatasource update not working
I am using templates in gridview. In 1 template I took a checkbox and in the footer templates I took a button. I want to perform an update action when the button is clicked on checked entries in the ...
0
votes
0answers
296 views
ASP.Net server side validation before insert Data to GridView
Im trying to build a simple App with ASP.Net.
my Database has 3 tables:
tblSong with columns: ID(PK, Unity), Title, ArtistId(FK), GenreId(FK)
tblArtist: ID(PK, Unity) Artist
tblGenre: ID(PK) Genre
...
0
votes
0answers
50 views
Sql Stored Procedure Help Request
I am very new in stored procedure.
Developing own web application and for new requirement need to convert my SqlDataSource to Stored Procedure..
Here is my SqlDatasource and my first StoredProcedure ...
0
votes
0answers
174 views
Build (web): Type 'System.Web.UI.WebControls.SqlDataSource' does not have a public property named 'SelectQuery'
I'm building a simple .net program for class using Visual Studio 2012. I'm getting this error:
Build (web): Type 'System.Web.UI.WebControls.SqlDataSource' does not
have a public property named ...
0
votes
0answers
89 views
Listview Control with datapager: How to export to excel and get all data
I am having an issue with getting all of the data to export from a Listview control with datapager to excel. This is my code:
private void ExportListView()
{
...
0
votes
0answers
50 views
Unknown column error for which column I have
I know this is not a good writing query :) but it does what I want when I execute it on FlameRobin. But when I try to use same query on a web app for a SqlDataSource.SelectCommand I get unknown ...
0
votes
0answers
37 views
Procedure or function 'stored proc' has too many arguments specified.
I am using a SQLDataSource to update a record from a GridView.
Below is the SQLDataSource
<asp:SqlDataSource ID="NonMatchDataSource" runat="server" ConnectionString='<%$ ConnectionStrings:PILOT ...
0
votes
0answers
179 views
ASP.NET SqlDataSource Update command
I've got stuck a little:
protected void btnUrediUporabnika_Click(object sender, EventArgs e)
{
DataSet ds = (DataSet)SqlDataSourceUserDetails.Select(DataSourceSelectArguments.Empty);
...
0
votes
0answers
183 views
How to show a bootstrap modal when a SqlDataSource's DeleteCommand is executed?
I have the following markup:
<asp:GridView ID="Users" runat="server"
CssClass="table table-hover table-striped" GridLines="None"
AutoGenerateColumns="False" ...
0
votes
0answers
183 views
Error in list of function arguments: 'SELECT' not recognized / ORA: 01008 not all variables bound
Why this block of code producing error in sqldatasource wizard in Visual studio ,
what i can do make it work ,
Is it a syntax error or what, if so please help me with a reference or a tool. thanks
...
