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 ...
1
vote
1answer
23 views
Using a VB Function as a SqlDataSource SelectParameter value
in my code behind i have a function getEmail() that returns an email address, in the front end i have a sql data source selectcommand that grabs info according to the email address. as of now the ...
-2
votes
0answers
20 views
ASP.NET GridView and SQLDataSource
Does anyone know how I am able to change the sqlDataSource connectionString and Select Command based on the user who is authenticated.
I have created a database of users and passwords using forms ...
0
votes
1answer
18 views
Load inserted Items only in Listview using SqlDataSource
I have a SqlDataSource which helps a Listview to Insert/Delete new data. But, I don't want to show the existing data to the Listview using this SqlDataSource. Only the newly inserted records to be ...
0
votes
0answers
15 views
Detailsview templatefield mapping to ObjectDataSource?
I need help to understand the proper way to map or associate TemplateFields to the ObjectDataSource. I show only one (of many) template definitions here:
<asp:TemplateField HeaderText="First ...
0
votes
2answers
55 views
Using SqlDataSource In Visual Studio
I am having an interesting problem in visual studio (likely due to my lack of experience). I have a SqlDataSource object and a GridView object. The Gridview object is setup to use the SqlDataSource ...
0
votes
0answers
5 views
Assign Dropdown value to insert parameter using SqlDataSource
I need to set the insert parameter to a SelectedValue of a Dropdown list that is an int. This should be easy but I cannot get it to work in my main application. It works in my test application. But ...
0
votes
0answers
19 views
SqlDataSource: FilterParameters not yielding results when SELECT statement includes WHERE clause
I have SqlDataSource control in my .aspx page.
The SelectCommand property includes a WHERE clause:
<asp:SqlDataSource runat="server" ID="dsProducts" DataSourceMode="DataSet" EnableCaching="true" ...
0
votes
2answers
51 views
Gridview with Sqldatasource Edit/Delete buttons
I'm using asp.net with c# code behind, and all I want to do is have a gridview+sqldatasource that I can manipulate at runtime and for whatever reason the buttons don't work. I have a login page that ...
0
votes
1answer
18 views
Multiple DataKeyNames not filtering sqldatasource
I have two grid-views on a page both bound to an sqldatasource. The first gridview (GVMonthReport) displays data from a table
My goal is to select a row from GVMonthReport to filter three items ...
1
vote
2answers
29 views
How to use appSettings key in SqlDataSource
Web.config:
<appSettings file="Application.config">
<add key="stringC" value="Data Source=svr1;Initial Catalog=myDB;Integrated Security=FALSE;user=user2;pwd=@#$123pop;" />
...
1
vote
1answer
51 views
How to bind a Data Source?
I'm getting an error -
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'netLogsDao': Injection of resource dependencies failed; nested
exception is ...
0
votes
0answers
11 views
Filter sqldatasource by ROWNUM
I have a sqldatacource control on an asp.net page that is the datasource for a gridview. This sqldatasource is selecting records from an Oracle database table.
The number of results I get back many ...
-1
votes
0answers
40 views
When SqlDataSource Return Different Table Scheme .“A field or property with the name 'XXX' was not found on the selected data source” Error Raises
I've a Stored Procedure that returns Different Columns depending on input parameters(@user , @BatchNo). So For Example:
if @user='Admin' & @BatchNo=1
SELECT SomeColumn, Column2 FROM Table 1 Join ...
0
votes
0answers
38 views
Dynamically remove rows from a datasource/database in gridview delete button handler
I have many different data sources being linked to different tables. One for each table. I have the edit and delete buttons showing on my gridview and have the subsequent methods created in my code, ...
1
vote
1answer
72 views
How to access selected values in ASP.net template field drop down list
I have a grid view in which i have two edit template fields both with list boxes in. I need to get the value out of DropDownList6 and use it in DropDownList1's SQL connection string. i have tried ...
0
votes
3answers
93 views
The conversion of the varchar value overflowed an int column ASP.NET
I have a SqlDataSource in ASP.NET that is returning an error
unhandled System.Data.SqlClient.SQLException, The conversion of the varchar value '5157964168' overflowed an int column
I am not sure ...
0
votes
1answer
50 views
Passing null in textboxes not working
Hi I m trying to pass null values in my date textboxes Textbox 3 and Textbox 4 but am not able to do so. Please let me know what I am doing wrong. Basically what I need is when the page load and the ...
0
votes
1answer
49 views
how to get all data from GridView before the paging occurs
I have GridView that have a SqlDataSource as DataSource. The GridView has its PageSize property set to 10 and AllowPaging to true. What I am trying to achieve is to get all rows data from the ...
0
votes
0answers
47 views
Dropdownlist inside gridview doesn't bind in previous gridview rows
I am using Obout:Combobox as a dropdownlist inside gridview.
<asp:TemplateField HeaderText="Particular" HeaderStyle-Width="500px">
<ItemTemplate>
...
3
votes
2answers
69 views
UpdateCommand not working?
So I have code that stores an UPDATE query in a string, then I parameter bind the update query and then execute and update it, this is my code:
string query = "UPDATE Users SET first_name = ...
0
votes
0answers
7 views
Bind Output Results to Variable
I am using a SQLDataSource to insert information into a database.
While it is inserting it also grabs the ID of that row
INSERT INTO InkInventory(CodeNumber, InkType, PMS, Color, Description, ...
0
votes
1answer
39 views
DataList not updating
I've been stuck on this problem for hours now and I have literally tried everything but nothing works!
So I have this piece of code in my button click event:
protected void btn_search_Click(object ...
0
votes
1answer
29 views
Eternal loading time with Update statement in ASP.NET
I have this code:
<asp:SqlDataSource ID="UpdateFullNameSQL" runat="server" ConnectionString="<%$ ConnectionStrings:UserQueries %>" ProviderName="<%$ ...
1
vote
1answer
40 views
Can I use the update statement with the select statement together in an SqlDataSource?
My query looks like this:
<asp:SqlDataSource ID="UpdateFullNameSQL" runat="server" ConnectionString="<%$ ConnectionStrings:UserQueries %>" ProviderName="<%$ ...
0
votes
1answer
55 views
Sql query with more WHERE parameters in ASP.NET, is it possible?
So here's my code:
<asp:SqlDataSource ID="UsersSearchResult" runat="server" ConnectionString="<%$ ConnectionStrings:UserQueries %>" ProviderName="<%$ ...
0
votes
0answers
16 views
how can I take data that contains text and code as <p> ,<strong>,world
I have a cell in database, it contains code and text like this;
<h3>TITLE</h3></br>weolcome
I've inserted this line with Ck EDitor.So how can I take this content of this cell ...
0
votes
0answers
36 views
Trying to insert data into database with sqldatasource, I get this error: ora-01745 invalid host exception, why?
I have this code in my aspx file:
<asp:SqlDataSource ID="RegisterUserSQL" runat="server" ConnectionString="<%$ ConnectionStrings:UserQueries %>" ProviderName="<%$ ...
0
votes
1answer
65 views
How can I use SqlDataSource properly with parameters?
Here is my code I'm using (with oracle developer tools):
<asp:SqlDataSource ID="FirstNameSQL" runat="server" ConnectionString="<%$ ConnectionStrings:UserQueries %>" ProviderName="<%$ ...
0
votes
1answer
40 views
A WHERE statement in my SqlDataSource causes invalid character exception (ORA-00911), why?
I'm using Oracle developer tools and my generated select command is:
SelectCommand = "SELECT "FIRSTNAME" FROM "USERS" WHERE ("USERNAME" = ...
0
votes
0answers
12 views
What is the this/self name when referring to self.property?
I have a ASP.NET GridView (actually ASPxGridView) and the SqlDataSource -- both wrapped in one User Control like this:
<%@ Control Language="C#" AutoEventWireup="true"
...
0
votes
1answer
39 views
How can I save the result of an SQLDatasource query into a variable in c#?
My query result supposedly is a string and I want to save it into a string variable and print it out. But the result is: System.Web.UI.WebControls.SqlDataSource
using this code: ...
0
votes
1answer
109 views
Fill nested repeaters in a table
I have a repeater inside another repeater. How can I display all the fields(surname) from db in an inner repeater. In the function outerRepeater_ItemDataBound, DataSource isn't recognized. I don't ...
0
votes
1answer
44 views
ASP.net user control with DataSource
My user control has several components, but the main is a CheckBoxList, I want to load it with a SqlDataSource, from the page, allowing me to use multiple instances of my control with different ...
0
votes
0answers
33 views
Can I use the result of an sqldatasource (a simple string) to use it as a parameter of another sqldatasource?
<asp:SqlDataSource ID="UsersUsernameSQL" runat="server"
ConnectionString="<%$ ConnectionStrings:UserQueries %>"
ProviderName="<%$ ConnectionStrings:UserQueries.ProviderName ...
1
vote
0answers
45 views
How to convert a dataset to a sql datasource or object datasource for use on a grid
I have a code which on button click, executes a sql string builder who's result is sent to a dataset. I would like to send these results from the dataset back to a datasource (sql datasource or object ...
0
votes
0answers
22 views
Not valid parameters are passing to SqlDataSource DeleteMethod
what I'm trying to do is delete a record form the database via GridView and SqlDataSource.
So I've got a little something like:
<asp:SqlDataSource ID="WorkersSqlDataSource" runat="server"
...
0
votes
0answers
93 views
Tableau: Filtering Across Multiple Data Sources
My data is coming from Microsoft SQL Server Management studio.
I was trying "Filtering Across Multiple Data Sources" by following the instructions provided in the link :
...
0
votes
1answer
48 views
SqlDataSource_OnSelected: Get data (DataTable) without re-executing the query
I have a SqlDataSource bound to a GridView with an SQL that takes about 10 seconds to retreive the data.
Also there is a UserControl called "PageSizeControl" which hooks the selected-event of the ...
0
votes
0answers
42 views
Binding GridView footer/edit controls to ODBC SqlDataSources in asp.net
I am making use of the SqlDataSource control in asp.net to connect to an ODBC source. This is my connection string stored in web.config:
<connectionStrings>
<add name="ODBC_SERVER" ...
0
votes
1answer
121 views
show header and footer in gridview asp.net when data source return no data
Goal
show header and footer when Sqldatasource of GridView1 returns no data
Problem
now this is what i did so far i have a GridView in my asp.net application which shows meetings of a persons ...
0
votes
2answers
66 views
How to allow greater than and less than in sqldatasource string parameter
I'm using a RadGrid and an SqlDataSource to make select, insert and update statements over a database table.
There is a string parameter in which I need to write down texts including tags, for ...
0
votes
0answers
74 views
Can´t find a ControlID in dx:ASPxGridView
Hello I need some help finding a ControlID inside a dx:ASPxGridView I've searched and its supposed to be working with a $ but it doesn't i don't know which is the mistake.
This is my GridView ...
0
votes
0answers
33 views
Multiple Selects on SqlDataSource
I want to populate a table inside a formview with information from either one table or another, depending on which dropdownlist option is selected.
<asp:DropDownList ID="Rules" ...
0
votes
0answers
18 views
Passing parameter to one of the datasources in GridView, based on gridview's original datasource
Below GridView is named begv_OrderDetail and has the DataSource sds_OrderDetail
For the control ddl_Vessels, the sds_Vessels is the DataSource. I want to filter this sds_Vessels with RowNo like ...
0
votes
1answer
150 views
SqlDataSource SelectParameters code behind
I have a SqlDataSource feeding a ListBox with this SelectCommand:
<asp:SqlDataSource ID="DSPatients"
ConnectionString="<%$ ConnectionStrings:CSMain %>"
ProviderName="<%$ ...
0
votes
1answer
32 views
ASP.Net AppSettings in Command of SqlDataSource
I have a SqlDataSource that I am trying to set an insert command with additional text after every table to switch for testing. I wanted to do this with an <appSetting> in the web.config.
When I ...
0
votes
0answers
68 views
Visual Studio Have to Click Button Twice
I'm trying to write code that will, at the click of a button, push a string variable onto a page and then open that page. The trouble that I am running into is that variable, a button's text, is ...
1
vote
0answers
48 views
String truncation: max=4000 error on sqldatasource with formview, update parameter string for CE4.0
I am using asp.net sqldatasource connected to formview which has update parameter defined as string like such:
<UpdateParameters>
<asp:Parameter Name="C" Type="String" />
...
0
votes
1answer
126 views
checking gridview count after filter expression
I'm working on an asp:GridView. On this aspx page, I'm giving users the option to search the current gridview by typing in a specific value into a textbox. Then, I set a SqlDataSource.FilterExpression ...
1
vote
0answers
51 views
SQL datasource Select Command (On Page Load) not working
i created this sql datasource in .aspx page i want to get the select command from code behind
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ...
