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
18 views
Windows odbc drivers datasource manager can no longer find a server it could before and now sql manager can't either
I am trying to use PyCharm to get access to my Microsoft SQL Server database. I registered the server on the data source administrator (64bit) on windows so that pypyodbc python package could find it. ...
pycharm
0
votes
0answers
12 views
using a drop down list within a details view to update a database entry in asp
I have a Details View that contains a drop down list. I have the drop down list being populated and I have the drop down list item that matches the database entry as the default selection. The problem ...
0
votes
1answer
30 views
Populate drop down list with current user value as the selected drop down list option asp
I would like to know the best approach on populating a drop down list with all database values, AND have the current value for a user be the selected index. I have the drop down list being populated ...
0
votes
0answers
24 views
asp.net with SQLDataSource
i have two SqlDataSource one of them depends on a return value of the other
how can i do this
<i><asp:SqlDataSource runat="server" ID="SqlDataSource2" ConnectionString='<%$ ...
-1
votes
1answer
44 views
asp.net c# Repeating only 1 of 3 images related to record
i want to repeat out all items from a single category (selected via querystring) which currently works.
However, each item is currently shown (repeated) 3 times, all 3 with the same text just a ...
1
vote
0answers
18 views
SQLDATASOURCE - Updating database using datavaluefield in combobox
I update in a datagridview.
I display a combobox and selected in my datasource datatextfield and datavalue field. When I create my update command, how is it possible to select my value and not my ...
1
vote
0answers
11 views
Must declare scalar variable when binding aspgridview to aspsqldatasource
I'm having difficulties in understanding how parameters in aspsqldatasource know where to get their values. Here is an example:
My users table is as follow:
CREATE TABLE HR.Users
(
userid CHAR(3) NOT ...
0
votes
1answer
15 views
Binding a SqlDataSource to a GridView: What is the difference between binding via ID and via setting DataSource
I want to bind a SqlDataSource to a GridView for viewing and editing database records.
No big deal (I thought).
However, there seems to be a big conceptual difference between
binding via the '...
0
votes
0answers
9 views
SqlDataSource not Passing Update Value
I have a GridView that updates the values of a SqlDataSource. All of the other fields work. However I have a bit value for is active, when I update and try to deactivate that, it simply doesn't pass a ...
-1
votes
0answers
16 views
Weird Issue with SQL DataSource and GridView
So after moving a GridView to scrollable div, I have a weird issue with updating the SQL database in the code behind. For example, the GridView passes parameters automatically in the ...
0
votes
1answer
38 views
Must declare the scalar variable, but they exist in markup
I have an SqlDataSource that i'm using for a GridView. I have used the Delete functionality of the GridView the same as iv used it for the Update function on other ones, but for some reason this is ...
0
votes
1answer
29 views
SQL Delete from DataGridView is not happening
I have a DataGridView that has delete enabled, but it never happens. The whole grid disappears (multiple rows), but the delete for the row I click never happens.
I can run the sql statement manually ...
0
votes
0answers
15 views
How do I get Postgresql as an option in Visual Studio 2015 Data Connections
I have an asp.net project where I want to interact with my Postgres database through my Code Behind and.
I have been able to use Npgsql (added through Nuget) to query the DB in the C# code behind but ...
0
votes
1answer
11 views
Update Command not firing after Edit/Save
I have a page that is not firing the update command when making changes to the information. I have several other pages that are working just fine and I am not seeing a difference in the coding that ...
0
votes
1answer
22 views
SqlDataSource and “Contains” when a comma or space is part of search string
I am writing an application in Asp.net with c# as code behind. I have a text box ("txtNameSearch") for the user place information into to filter a SqlDataSource, and a gridview that populates based ...
0
votes
2answers
23 views
asp.net VB Need to set default value for Listview or SQL Insert
Hope I can make this clear. I have:
Listview with a sql datasource
a separate dropdown that when something is selected filters the listview/sqldatasoure
What I am trying to do is use the value from ...
0
votes
1answer
21 views
SqlDatasource: Parameters on Select()
After reading https://msdn.microsoft.com/es-es/library/system.web.ui.webcontrols.sqldatasource.select(v=vs.110).aspx
I'm a bit confused about the Select() method of the SqlDatasource. It's easy to ...
0
votes
0answers
14 views
sqldatasource cache at the scope of application
Is there a way to cache sqldatasource for lookup fields at application level. So that if it has been cached once, it can then be used by all future sessions. What other techniques do you use so that ...
0
votes
2answers
21 views
Asp.Net SqlDataSource bind two columns together into one column in ASPX
I had a <asp:SqlDataSource connected to a database using a connection string however I wanted to have 2 columns merged together to create 1 column such as:
Column: First Name
Column: Last Name
...
1
vote
0answers
165 views
Visual Studio 2015 : SQL Data Source : Unable to retrieve schema. Ensure that the ConnectionString and SelectCommand properties are valid
I have the following development environment for ASP.Net WebPage
VS 2015 Professional Version, using .Net Framework 4.0
MySQL Server 5.6,
MySQL .Net Connector 6.9.5
MySQL for Visual Studio 2.0.2
...
1
vote
0answers
22 views
Hikari connection Leakage error
I have implemented Hikari connection with java configuration the code is below ,
HikariConfig sqlConfig = new HikariConfig();
sqlConfig.setDataSourceClassName(WebAppListener.getContextParameter(...
0
votes
1answer
50 views
how to use SQL datasource wizard at runtime (Devexpress) ?
there is a component in DevExpress called SQLDataSource, this component allows you to import data from any database but not at RunTime,
I'm currently developing a module that import data from any ...
-1
votes
1answer
23 views
which datasource doesn't supports caching in asp.net
we have different data sources like
sqldataource
objectdatasource
linqdatasource
xmldatasource
Out of which doesn't supports caching
0
votes
1answer
27 views
2 Dropdownlists in Gridview cause error: Databinding methods such as Bind() can only be used in the context of a databound control
Though this seems to be discussed before, I can't apply given help in my case:
I have 2 DropDownLists (DDL1, DDL2) inside the Edit Template of a Gridview, which is bound to a SQLDataSource. DDL2 ...
0
votes
1answer
24 views
Updating my Gridview Search boxes to use LIKE instead of '= or null'
I currently have a gridview that has text boxes across the top that the user can leave blank (in which case all records in the table are returned) or the user can supply exact matches to information ...
0
votes
2answers
49 views
Bind dynamic parameters to the SQL data source not working
I want to call the stored procedure on the child gridview by using a SqlDataSource.
This is what I'm doing:
<obout:Grid runat="server" ID="grid1" AutoGenerateColumns="false" PageSize="10" ...
0
votes
0answers
29 views
alert message on admin page when any user login using c#?asp.net
i have an asp.net grid i want to update its datasource from another page i am using sqldatasource1 so that grid sync with database on insert operatioon called on another page and results in updation ...
1
vote
1answer
63 views
SqlDataSource - SelectCommand with session variable filter
ASP.NET 2.0 framework
I'm trying to list all user related entries when the user visits the page. I have a session variable set with the visitor in session. Now I want to query the database with that ...
1
vote
2answers
35 views
Select only the name of the column of the tables implemented by the inheritance of the table in SQL Server 2014
I have a question about selecting only the name of the column of the tables implemented by the inheritance of the table in SQL Server 2014.
I.e. having four types of person (students, teachers, ...
0
votes
0answers
43 views
Cannot Find Control ID in ControlParameter obtained by Request.QueryString - Asp.Net
I'm with a doubt in getting the id of a book author and add the publication of a book, and the book to be published should have an author id that was used as identity and a name as a text and an ...
0
votes
1answer
33 views
SqlDataSource SelectCommand contains null values
My SQL code that works running on the server.
SELECT
[LINE_NO], [CUST_ORDER_ID], [PART_ID],
[CUSTOMER_PART_ID], [MISC_REFERENCE], [PROMISE_DATE],
[PROMISE_DEL_DATE]
FROM
[...
0
votes
0answers
21 views
Combining Gridviews with sqldatasources
Good afternoon. I have three gridviews that contain sqldatasource. Both grids are 5x2. What I am trying to figure out is how to combine the multiple gridviews into a table. To get that result, ...
1
vote
2answers
33 views
Display results from databound dropdownlist
I have made a dropdown list named Company Dropdown that is databound. The dropdown's data comes from the sql database.
There is a table called CompanyList. Once someone selects a company from the ...
0
votes
0answers
22 views
Object reference not set to an instance of an object - Database1Entities showing up as null [duplicate]
So I'm trying to import an excel file to a local database table "TopicList" and it throws this error saying Database1Entities is not set to an instance of an object. Here is my code when I try to ...
1
vote
1answer
49 views
ASP.NET Cannot find object in parameter ControlParameter
I'm trying to get value from DropDownList as a parameter for SQL query. I have a GridView and SqlDataSource. And I can't reach DropDownList ("DDLName") inside the GridView. When "DDLName" is outside ...
0
votes
2answers
76 views
SqlDataSource not binding with multiple parameters
I have a very simple ASP.NET page that has two textboxes, a button, a SqlDataSource and a GridView. The SqlDataSource gets it's two parameters from the two textboxes, which it then passes on to a ...
1
vote
1answer
360 views
Procedure or function has too many arguments specified in FormView and SQL SERVER c#
I have one stored procedure called VideoGalleryDelete . I am using FormView and Gridview to insert, update, show and delete data. VideoGallery is my primary table with PK VideoId and it has a foreign ...
0
votes
1answer
39 views
ASP.NET C# Edit SqlDataSource record without FormView
How can Edit SqlDataSource record without FormView?
I knows getting data into TextBox, But can't save changes.
protected void Page_Load(object sender, EventArgs e)
{
DataView dvSql = (DataView)...
0
votes
0answers
13 views
edit formview using a dropdown list
I do have several items on my profile page (Name, address, number etc) and what i want to do on the address part (which is separated by city,province,barangay) is when i try to edit it, there will be ...
0
votes
0answers
42 views
How to use LIKE operator on DATE/TIME using a Text control parameter in asp.net?
I am trying to use a like parameter to get the year within a date field in my database using a control parameter. I need this to work on the aspx not the aspx.cs page. Below is my code:
<asp:...
0
votes
1answer
98 views
SQLDataSource not showing in design view ASP.net C#
I am attempting to build a report in Visual Studio 2015 using ASP backed with C#. however, any time i try to add the SQLDataSource control it will add the ASP code but will not show the control in the ...
0
votes
0answers
11 views
Are there restrictions on column data types that can be used for KeyNames in an editable asp:GridView (update fails without error)
I'm having trouble getting an asp:SqlDataSource + asp:GridView combination to successfully save the changes back to the database (SQL Server).
I'm basically going through the common steps using the ...
1
vote
0answers
8 views
Count Blank columns in a row Excel 2013 Pivot Table
I have a Pivot table in Excel 2013 which fetches data from SQL Server. I wanted to create a calculated field in one the tables imported to average upon 6 columns in each row of the table, so my ...
0
votes
2answers
37 views
Visual Studio 2013 Select Where Date = Today's Date
Hello I am trying to display information using an SqlDataSource to a Gridview where it only displays data where the date is = to today however I'm struggling to get it work I have tried several ...
1
vote
1answer
63 views
How to assign a radiobuttonlist to a boundfield in GridView?
I imported an excel table consisting of 5 columns and 50 rows into a datatable and stored it in a database table. None of the columns are a primary key as they consist data of string, are repetitive ...
0
votes
2answers
55 views
If SQLDatasource returns 0 rows, change display:none to display:block
I have a table with content that says
0 orders found
That is currently set in css
#OrderNoExist {
display:none;
}
I'd like for the C# to change the css style for this table to block. Here's ...
0
votes
0answers
26 views
Cross FormView fields update
I have an ASP.NET page (C# codebehind) with two FormView both of these are bound to the same underlying SQL table but SQLDataSource objects feeding the forms are different because I needed two ...
1
vote
2answers
66 views
SqlDataSource ControlParameter not working
I have a dropdown (selProject) populated by a SQL table. The value is the id field, the name is the name field.
I have a gridview control fed by a sqldatasource.
What I want to do is to conditional ...
0
votes
0answers
90 views
Error uploading InfoPath form to Sharepoint 2013: “Object reference not set to an instance of an object”
The only change we've made is added an additional data connection to a SQL database and then filter on the data connection to set a field.
The form is fine when you query the database only but when I ...
0
votes
1answer
27 views
How to stop Visual Studio Query Builder from re-writing SQL (VS2005)
I simply paste this SQL code that I've carefully crafted in SQL Server Management Studio and it works.
SELECT v.StudentID, v.StudentName, s.StudentHomeEmailAddress, s.StudentStudyYear, s....
