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
8 views
account page pass user specific information from o
What i want is that when a user logs in on a login page i want is his user specific data to show up in a form view have a session state and the sql datasource is populating the form view. Can some one ...
0
votes
0answers
16 views
Can't use PreparedStatement with DataSource type connection
I don't quite seem to get the PreparedStatement work when I use a DataSource type connection while inserting values in a table.
I tried type-casting:
PreparedStatement preparedStatement = ...
0
votes
2answers
26 views
In VB.NET evaluate 0.70 to be equal to .7
I am comparing a value that the user entered into a DataGridView cell - which, coming from an Editing Control will be a string to start with - with a decimal value from the data source (defined as ...
0
votes
2answers
18 views
How can I gather a sqldatasource's results as a comma separated string in code behind?
Hello and thank you for your time. If I have a Sqldatasource that is pulling from my database a list of ID's based on a certain criteria, how can I call that list formatted to a comma separated string ...
0
votes
1answer
29 views
Changing SQL Datasource stored procedure on button press
I have two different stored procedures i'd like to run. The first one as listed will run on start up and display all entries in a database. The 2nd one i want to only run on a button press, which ...
0
votes
3answers
29 views
Multiple INNER JOIN in sqldatasource for displaying in a gridview
Almost everything is in the title, I'm trying to create a SQLdatasource in for displaying data from several tables in a gridview.
I have three tables in the model :
table lot_poudre with Id ...
0
votes
0answers
36 views
SQL DataSource Commands not working
I've this commands made by aspx datasource wizard, but they don't work why?
<asp:SqlDataSource
ID="ListarRoles" runat="server" ConflictDetection="CompareAllValues" ConnectionString="<%$ ...
0
votes
1answer
24 views
Read only field does not postback from Gridview
I have a Gridview with a SQL data source attached. The smart tag set up was used to create and handle Select and Updates. When I edit Gridview columns to make 2 date fields Read Only, on the Update ...
0
votes
0answers
11 views
when I add new Data source using xampp MySql, VStudio reponse “ one or more errors occured, Could not retrieve schema information for table or view ”
As I add new Data Source using XAMPP MYSQL, the connection is ok![enter image description here][1]
and after I add the connection, when it comes to the choose the tables and views it has error----
...
1
vote
0answers
50 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" ...
0
votes
1answer
37 views
ssrs DB connection error
I'm Trying to created a shared Data source from a sql server that is not local. the host of SSRS is a sql server 2014 and the DB source is a sql server 2008 R2.
I'm getting the same error whatever I ...
0
votes
0answers
20 views
Spring DataSource Pooling Configration Reset
I'm using Spring JDBC DataSource with UCP. My Question is, How To Reset UCP Pool while my db server down/Up.
For Example I Start my application while DB Server is up and I have successfully login my ...
0
votes
1answer
19 views
CommandArgument on SQLDatasource Inserted?
I'm wishing to redirect to two different pages depending on which button is pressed on my form.
Both buttons call the Insert method of the Datasource, but only one of them needs to get hold of the ...
0
votes
0answers
40 views
Datasource control in WPF C#
I worked on ASP.NET and I use SqlDataSource control to add binding in my DataGrid. But now I am making an app in WPF C# and there is no SqlDataSource in Toolbar. I am using VS2013. I searched online ...
2
votes
0answers
8 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 ...
0
votes
1answer
68 views
How to bind 2 tables to Gridview in order to use better column headings
I have what is probably a common issue but just can't for the life of me think of a good way to do this.
The requirement is for the web site to read in an ftp file. No problem. The file is a CSV with ...
0
votes
0answers
31 views
The connection name was not found in the applications configuration or the connection string is empty
The connection name 'TConfiguration.TrackerDSN' was not found in the applications configuration or the connection string is empty.
There is no web.config file for this.App using ...
sharepoint
0
votes
1answer
39 views
Can I connect to multiple servers with an asp:SqlDataSource?
I have a repeater table in an asp.net application bound to an asp:SqlDataSource, and I need that data source's SelectCommand to select data from two databases in different servers.
I've been using ...
0
votes
0answers
29 views
How can I add to SqlDataSource SELECT statement in code in Visual Studio for Web?
I have a data source SqlDataSource1 with
SELECT * FROM [Locations]
as the select statement built in when I created the DataSource. During run time I want to load the source with only DriverID = ...
0
votes
0answers
101 views
DataSource or DataSourceID cannot be defined on '___' when it uses model binding. .net VB
To start off I want to say that my sqldatasource and grid view were working until I decided to add the UpdateMethod to the GridView. After adding this and setting it to a sub in the codebehind I get ...
0
votes
1answer
41 views
ORA-01036 after rewriting an Oracle insert command
I am reworking legacy code and came to this query:
sqlDS.InsertCommand = "INSERT INTO SCHEMA.TABLE " +
"(ID, DATUM, ID_STATE, G_AM, G_VON, DATUM_BEW) " +
...
0
votes
1answer
59 views
Unable to pass wildcard character to stored procedure using asp:ControlParameter
I have an aspx page that allows a user to enter in a string asp:ControlParameter that is then passed to a stored procedure using the SelectCommand.
The problem is if a user enters 123456% in the text ...
1
vote
0answers
32 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 ...
0
votes
2answers
116 views
The expression contains undefined function call DATEADD() | FilterExpression | Datime filter
I have a grid-view and I want to filter it to display data only in a certain date interval (from date A to date B, include A and B)
I use SqlDataSource and FilterExpression, initially I use this ...
0
votes
2answers
56 views
Repeat ASP code multiple times
I'm from a PHP background and pretty new to ASP.NET. Now I'm running into something and no amount of Google searching is getting me any closer.
I have a snippet of ASP.NET/VB code that renders a ...
0
votes
0answers
44 views
Using a CheckBoxList as paramater for SqlDataSource
I'm trying to populate a GridView based on a CheckBoxList on the same page. The GridView works well, however, I can't find a way to only use the values from the CBL. I searched and tried a few things, ...
0
votes
2answers
127 views
asp:DropDownList selectedvalues in multiple selection list
I have asp:DropDownList wich is populated from SQLdatasource and I need to set selected items on select list (asp:DropDownList or asp:DropDownList).
Here is my code:
<asp:SqlDataSource ...
0
votes
0answers
35 views
dbo table not showing up in SqlDataSource control setup UI in Visual Studio
I have a database with two different tables, one of which I want to assign to a SqlDataSource control on my ASP.NET webform. When I go to the tasks menu (clicking on the arrow on the control in design ...
1
vote
2answers
39 views
Button click to fire stored procedure from SqlDataSource
I have an sql stored procedure which accepts 3 parameters and acts as a search facility which all works fine as its supposed to. I also have an asp page with 3 corresponding text boxes, a grid view, ...
0
votes
0answers
67 views
Gridview Sum the Columns
I am trying to sum the columns into the footer in a Gridview.
Each Gridview row has a separate sum for each column.
Error Code on line "presum1 = Convert.ToDouble(TempTxt1.Text);":
Input string was ...
0
votes
0answers
73 views
How can I make a button filter my table based off of dropdown choice? (.Net)
I'm trying to make a program in Visual Studio using asp.net that displays the results of a SQL Database in an HTML repeater table. I'm attempting to filter the data within the table so that you are ...
0
votes
1answer
67 views
ASP:GridView dynamic datasource from Querystring
Just playing around with ASP.net C#. I am trying to pass a querystring to the gridview's datasource. The querystring is the SQLDataSource ID. This way one page can pull from different datasources ...
0
votes
1answer
151 views
Cannot Find Control ID in ControlParameter
I am trying to insert values from a textbox but I get an error that it cannot find the controlid in the controlparameter. The TextBox is inside a formview, which is inside a listview. The ...
-1
votes
1answer
341 views
How to add exception handling to SqlDataSource.UpdateCommand
We have a radgrid that is automatically updated with the SqlDataSource.UpdateCommand. So when we edit some column(s) and click on "Update" the table is updated correctly with UpdateCommand in the ...
0
votes
0answers
23 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
16 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
1answer
27 views
Insert Data retrieved from another row except one updated column
I would like to take all the data used in a previous row and insert it into a new row. However, in one column I will be using a new value. I am using a SqlDataSource in a FormView to show this ...
0
votes
1answer
91 views
Pass variable to sqldatasource Select command client side
I have a grid and a dropdownlist from where the user select the query to fill in the grid.
As it is now it works fine:
protected void Button1_Click(object sender, EventArgs e)
{
string ...
0
votes
0answers
79 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
2answers
91 views
display method in grid is showing the same text in all rows
I have a very simple display method on a table to display the weekday of a given date:
display DateDayName day()
{
WeekDays weekday;
;
weekday = dayofwk(this.TransDate);
return ...
0
votes
0answers
87 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
1answer
39 views
how to set a length of a string
i have the store procedure and i have passed the value as output which will return the value as string but the string is showing only length of 1 but on store procedure i have set the length(max) but ...
0
votes
1answer
69 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 ...
1
vote
1answer
105 views
<asp:QueryStringParameter> doesn't seem to be passing a value to my SQL stored procedure
I'm passing a partial name to an aspx page in the url in order to filter a list of names. However, the parameter seems to be completely ignored. The url is FilterPage.aspx?strPartialName=abi
The .Net ...
0
votes
1answer
88 views
why does my asp.net listview not show latest inserted record?
I'm just trying to get accustomed to LVs and I just threw this one together. I was under the impression that the LV would handle the inserting and refreshing of the LV after the insert but it doesn't ...
0
votes
2answers
62 views
Delete link in gridview deleting all row
I am facing a problem with my gridview as the Delete link is deleting all the rows where i want to delete one by one. I have record my screen that may exolain more about my problem
...
0
votes
1answer
294 views
Make an ASP.NET GridView change based on a DropDownList selection
I've tried a thousand ways to make this work and I can't. I have a DropDownList bound to the data in a column from an .mdf database. I also have a GridView below it that is bound using the Query ...
0
votes
1answer
39 views
SqlDataSource delete statement does not work
can anyone help me with my code, it hits an error in the last line of the code snippet with the error : Additional information: Deleting is not supported by data source '' unless DeleteCommand is ...
0
votes
0answers
150 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
174 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"). ...
