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
11 views
Disply gridview base on multiple values
I am looking to pull my data to a grid view base on one parameters which is an ID; the tricky part is, this ID might content a multiple IDs.
In sql, I can write something like below.
Select * from ...
2
votes
0answers
101 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
115 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
494 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
14 views
How to we use the control inside RadGrid edit field as Select Control parameter Control id
I had a textbox control inside radgrid edit template, I want to use it as sqldatasource select parameter ControlID .
<SelectParameters>
<asp:ControlParameter ControlID="" ...
1
vote
0answers
21 views
SqlDataSource control is hidden in ToolBox of Visual Studio 2012
I'm a fresher started my career with SharePoint. I created a visual web part and tried to bind data with grid view of a SqlDataSource. But I cant see the SqlDataSource control in the toolbox and its ...
1
vote
0answers
99 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 ...
1
vote
0answers
72 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" />
...
1
vote
0answers
59 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="<%$ ...
1
vote
0answers
128 views
make (GridView with DropDownList using FilterExpression in SqlDataSource) work without reloading the page using JavaScript
How can i make this (Filter GridView with DropDownList using FilterExpression in SqlDataSource) work without reloading the page using JavaScript ?
<asp:DropDownList ID="ddlCountries" ...
1
vote
0answers
152 views
filter sqldatasource and display values that not equals filterexpression
I just want to filter my sqldatasource and display all values that not equals the filterexpression. Somehow like this:
SqlDataSource1.FilterExpression != "something='something'";
Is there ...
1
vote
0answers
284 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
283 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
167 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
73 views
SqlDataSource not populating controls until after page_load
bit new to asp.net so bear with me. I have a dropdown that is being populated from a SqlDataSource. This dropdown's selected value is used as a parameter in another SqlDataSource for my results grid.
...
1
vote
0answers
134 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
175 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
132 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
2k 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
364 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
189 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
266 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
447 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
641 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
1k 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
378 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
1k 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
19 views
parameterise table name in nested repeaters datasource
i want to select a column like cl1 from different tables for each row on gridview and show it on my repeater. how can i do this?
here is my code:
<asp:gridview cssclass="text-center table ...
0
votes
0answers
13 views
Naming parameters for stored procedure based UpdateCommand in ASP.NET SQLDataSource / FormView
I'm using a SQLDataSource object to edit data of a MYSQL table.
The ASP.NET form uses a FormView and fields are mapped onto controls through <% #Bind('field_id') %> directives.
The form is ...
0
votes
0answers
11 views
SqlDataSource using the client-side variable
I am using the SqlDataSource with sql query to provide the datasource for DataGrid. Using general query or stored procedure is fine. However, can I used the client-side variable, for example ...
0
votes
0answers
26 views
Send float parameter through SqlDatasource.InsertParameter
Hi I am trying to insert a float value into database through SqlDatasource.InsertParameter but after SqlDatasource.Insert() function is executed I only see the Integer part of it inserted in database. ...
0
votes
0answers
21 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
49 views
ASP.Net 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
0answers
25 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 ...
0
votes
0answers
56 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, ...
0
votes
0answers
9 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
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
55 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
0answers
14 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
0answers
46 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 ...
0
votes
0answers
25 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
577 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
0answers
66 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
0answers
93 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
76 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
22 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
0answers
109 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 ...
0
votes
0answers
35 views
Multiple Gridviews, Shared Sqldatasource , different filters
I have to do a webform with 5/6 gridviews that should show same data filtered in different ways.
Is there a way to do that using a single sqldatasource? (i.e. applying different filterexpressions to ...
0
votes
0answers
47 views
UpdateCommand different from SelectCommand
I have a sqldatasource, the SelectCommand has a join in it. However I want the UpdateCommand to only update one of the tables. ( to be specific two variables, memo and amount on one table).
I have ...
0
votes
0answers
71 views
SSRS Report Subscriptions and Data Source Credentials Disappear
We have a SQL 2008R2 environment, and SharePoint 2010.
We are running reporting services in integrated mode on these platforms.
For over a year, we have had no issues writing reports and using the ...
