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 ...
0
votes
0answers
16 views
FormView databind data manipulation
EDIT: I've managed to fix the problem, all I had to do was put it in the formviews databound event and declare a formview value that I called locally. Just incase others try to do something similar in ...
0
votes
1answer
12 views
Accessing SqlDataSource result in code behind for conversion
I have SqlDataSource on my ASP.NET page and load this into Telerik's RadGrid control.
<asp:SqlDataSource
ID="DataSource"
runat="server"
ConnectionString="<%$ ...
0
votes
1answer
31 views
asp.net sqldatasource parameter not supplied
OBJECTIVE: TO GET THE DELETE STORED PROCEDURE TO WORK
Hi,
I am creating a very simple CRUD (CREATE, READ, UPDATE, DELETE) test program in asp.net framework 4 which needs to have a table id as a ...
0
votes
0answers
23 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
36 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
1answer
22 views
How to use SqlDataSource with button on click to get results from gridview
My overall goal is to be able to type in information into my textbox and click a button to search and get results from the database using gridview. So far I have my SqlDataSource SQL statement set up. ...
0
votes
0answers
14 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 ...
-2
votes
2answers
25 views
ASP.NET C# : How to load a dataview object using sql classes via the code behind?
I know I can drag/drop an sqlDataSource object onto my webform and then get my connection string from my webconfig file and link it and done... But I don't want to do it that way. I want to do it ...
0
votes
1answer
20 views
UPDATE command property for asp:SqlDataSource does not recognize parameter values
The error occurs when the asp:ListView object tries to call the update command built in to the datasource. Specifically the error states:
Cannot insert the value NULL into column 'FirstName', ...
0
votes
2answers
48 views
SQL Join query in SqlDataSource
I am not really sure about how to do this.
In a table Product1 I have:
Id, Code, Description, Group, Quantity, Unit, Cost, Note
In the other table Componets I have:
Id, Code, Description, Unit, ...
0
votes
0answers
26 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
18 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
2answers
23 views
How can I get the current user from Sqlconnection
I am trying to determine what user my application is using to authenticate to my database, is there a way that I can get the user that is being used to execute the sql code?
string connection = ...
0
votes
1answer
50 views
Path string format '/' to '\'
i have a problem about string format.
first, i have table on the database and the record is
id | url
---|-----------------
1 | \root\folder\file.txt
and i have to access query like this one,
...
1
vote
0answers
50 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 ...
0
votes
0answers
48 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: ...
-1
votes
3answers
84 views
What is the Sql command to get selected column names from a database table?
I am able to bind my dropdownlist with the following lines of code.
Current Scenario : DropDownList bounded with all the column names of that table.
Requirement: DropDownList to be bounded with only ...
0
votes
3answers
83 views
How to search data in asp.net web application
I need help with my asp.net web app. I have a page where i display data (all the users) with datagrid. For now, there is no problem when i only have a few users in. But when a database will be ...
1
vote
2answers
115 views
How to set a nested datasource from code behind?
Connection String (Conn) is set globally on page load.
(As below. I use this for all sqldatasources and it work perfectly.)
VB.NET (Page Load)
Imports Connections
Dim Conn As New ...
1
vote
3answers
89 views
DropDownList retains wrong input text instead of selected input from its List of Items
I have a DropDownList Control populated with List of Items from SqlDataSource. The SqlDataSource QueryBuilder chooses the Column_Names from my Database Table.
If the DropDownList is provided with ...
-1
votes
1answer
29 views
SqlDataSource get url parameter
I'm using an SqlDataSource and gridview to display some data, the data being displayed related to the url parameter. So in my case, my url paramter is ?orderid={number} and I want to use that for my ...
0
votes
1answer
81 views
How to configure SqlDataSource to handle a return value from Stored Procedure
I have a listview and in the listview Update commmand I am attempting to set the parameters defined in my SqlDataSource UpdateParameters property. When Update command fires, I recieve an error message ...
3
votes
3answers
97 views
How can I Bind separate query to separate column in GridView Asp.net C#
I am working on ASP.net 4.0 integrated with Oracle 10.2.0.4
This is my code for GridView and its SqlDatasource
<asp:GridView ID="gvRegNumber" runat="server" AutoGenerateColumns="False" ...
0
votes
1answer
25 views
Populate DDL with Customer Phone Number
I have been assigned to create a Contacts page using ASP.NET. I have a GridView that displays all Contacts with a DropDownList ItemTemplate in the 'Phone Number(s)' column. A Customer can have ...
0
votes
0answers
126 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
1answer
20 views
sqldatasource, SQL doesn't run correctly
This is a strange problem that I've been working on for a while. I have a sqldatasource with select and update statements. However the statements don't work correctly with parameters.
For example if ...
0
votes
0answers
34 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
96 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
25 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
1answer
101 views
query string and response.redirect issue
I Have a listView and I want to create a button or link that when user click,goes to a page that have a formview and it's datasourse configured :
</asp:FormView>
<asp:SqlDataSource ...
1
vote
1answer
56 views
How can I increase the performance of this FormView / SqlDataSource
I have a simple asp FormView on my page, it's working fine and everything, but I noticed the page is somewhat slow to load up (2-3 seconds), when there's really no reason for it, it's such a simple ...
0
votes
2answers
29 views
Select sqldasource query from dropdownlist
I have a grid which has a dasource selected sqlDataSource2. I have not built any query in the datasource. I have a dropdownlist with two items and I would like to select the query from the ...
0
votes
1answer
213 views
Procedure or function x has too many arguments specified
I have a gridview with the following SqlDataSource:
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnString%>"
...
0
votes
0answers
49 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
1answer
25 views
retrieve data from sqldatasource object
I'm working on a gridview and got a little problem with the built in edit button.
the gridview got 3 columns title, artist, genre and when editing the genre a ddl shows.
in my grv_update event
...
0
votes
0answers
244 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
2answers
31 views
Update the database from SqlDataAdapter using UpdateParameters
I have a problem and I need help, I have a gridview binding from SqlDataSource:
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource2">
...
0
votes
0answers
47 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
1answer
55 views
Dynamic Report building Refresh() is not changing data
I am trying to View a report dynamically from code behind. But when the parameters are changed from dynamic textboxes added in the page. in the report refresh() the data is not changed.
I call ...
0
votes
0answers
123 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
74 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
2answers
80 views
GridView is not visible in the output
Okay!
I am trying to merge 4 Tables which i have aliased in SelectCommand.
Problem--> The GridView is not visible in the final output
Guesswork--> I even tried without alias (Didn't work still). So i ...
0
votes
0answers
47 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
1answer
22 views
C#, In a Mysql connection proprety connection.Server and connection.DataSource are always equals or there is a case where are different?
In my program I can see these proprietes are always equals, can be different in some exceptional case?
0
votes
1answer
36 views
When using GridView, which is the best option to bind it to the datasource?
I'm relatively new to ASP.net and while learning it I came across different ways people use to bind data to GridView:
SqlDataSource
ObjectDataSource
Binding DataTable to GridView control from the ...
1
vote
2answers
142 views
Gridview with SQL data source is removing white spaces
I have a GridView connected to my database through an sql data source. It is bound by the follow code:
firstview = "SELECT ID, DC, DD, CYM, CB, ST FROM SCH_SCHEMANAME.TABLENAME WHERE CI = " & ...
0
votes
1answer
32 views
should we always use sqldatasource while we are using Gridview in asp.net?
should we always use sqldatasource while we are using Gridview in asp.net?
I am a beginner to asp.net. We can handle gridview using sqldatasource and ado.net codes with databind.Using ado.net codes ...
0
votes
1answer
17 views
Defining placeholders for source and schema name in a query inside SSIS
I am using a following query with hardcoded datasource name in my OLE DB source of SSIS package wherefrom I am pulling certain types of rows.
select *
from ...
0
votes
1answer
46 views
SQLDatasource Select Parameter causes time out
If I run this code, the result is returned in less than a second -
<asp:SqlDataSource ID="OrdersSqlDataSource" runat="server" ConnectionString="<%$ ...
0
votes
0answers
32 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 ...
