966 questions
0
votes
0
answers
41
views
GridView`s SQL Data Source update
this is the aspx GridView
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:con %>" SelectCommand="SELECT [...
0
votes
1
answer
58
views
ASP.NET SqlDataSource.Select() not selecting
I have the following SqlDataSource:
<asp:SqlDataSource ID="DataSourcePFEP" runat="server" OnSelecting="DataSourcePFEP_Selecting" OnSelected="...
- 60
0
votes
0
answers
295
views
Tomcat server not starting!- Spring application - Upgrade from JDK8 to JDK17
The following is the error message I get when I try to start my web application.
This is a project where we are upgrading from JDK-8 to JDK-17.
We have upgraded all Jakarta libraries and required ...
0
votes
0
answers
146
views
Comparing two table schemas and generate the Alter table query for SQL databases
I have a requirement where I have two tables in two different databases, where one is source and other is destination. I have to pull the table schema between source table and destination table and ...
- 845
0
votes
1
answer
399
views
Change data source in visual studio
I want to change the source from dev server to uat server, when I try to do change source and give uat source details the database is not coming up it is still using dev database only
Suggest a way ...
1
vote
1
answer
1k
views
Combine two data sources into one data source inside SSRS report using a stored procedure
I am trying to build SSRS report that will fetch data from two different servers.
I have already created a stored procedure that works fine while running in Management Studio, but the same stored ...
-1
votes
1
answer
151
views
How can I bind "image1" to aspxImage?
I have a aspxImage but I can't give to datasource. I need to bind my "image1". You can take it from gridview or sqldatasource doesn't matter. How can I bind my image1 to aspxImage?
Here's my ...
- 3
0
votes
1
answer
39
views
Add blank first row to an SqlDataSource bound to DropDownList
So I am having an ASP.NET page for material ordering, where the users can order components for the production of a given product. The way it is structured:
First DropDownList lists all active ...
- 60
0
votes
0
answers
141
views
How to Read Data from SqlDataSource During Load
I have a FormView that contains three radio buttons which have values of 1, 2, and 3 respectively. I need to bind the radio buttons to a database field in the FormView's datasource (I do not want to ...
- 1,336
0
votes
1
answer
46
views
ASP.NET VB Nested Listviews problem with the inner listview
I am trying to make nested listview. but the inner listview did not displaying. outer is displaying.
I have outer listview and inner listview. each has its own sqldatasource. the problem is I cannot ...
0
votes
1
answer
958
views
docker file tomcat configuration with docker file
i want to create a docker file with tomcat server .
i have two war files war 1 and war 2.
i copied war1.xml into /usr/local/tomcat/conf/Catalina/localhost/
i copied war2.xml into /usr/local/tomcat/...
- 111
0
votes
0
answers
219
views
How to pass user defined type parameter to the stored procedure using SqlDataSource
We have user defined type in our SQL Server database defined as shown here:
CREATE TYPE Integer_List_tblType_InMemory
AS TABLE
(
RecordId BIGINT NOT NULL PRIMARY KEY ...
- 478
3
votes
2
answers
1k
views
How do I set Data Source password from environment variable in DataGrip?
To connect to DB I have to make an API call to generate a token. Lets say I store this in environment variable $TOKEN.
Now while setting up my data source in DataGrip, how can I tell DataGrip to read $...
- 135
-2
votes
1
answer
50
views
Populating the SQLDatasource SelectCommand
How do I take this string and drop it into the select command?
String SqlC = "select * from dbo.FindIt where " + SqlStr;
The object is to populate the SelectCommand:
<asp:...
- 7
0
votes
1
answer
152
views
Creating Dynamic SelectParameters in my Code instead of Markup for SqlDataSource?
I can properly parameterize my SQL query using IN Clause using a for loop. I have trouble properly implementing the same query in my SQLDataSource. I have to literally declare the SelectParameters in ...
0
votes
1
answer
171
views
Creating SqlDataSource SelectParameters for IN Clause Parameterized queries
I am trying to create a SqlDataSource SelectParameters for my IN clause parameterized queries. I can successfully parameterize. I was wondering if there is any way I can do it properly?
...
-1
votes
1
answer
208
views
"Must Declar Scalar Variable" Error even though I added it using Select Parameters
SqlDataAdapter adpReport;
DataSet dsReport;
ReportDataSource rds = new ReportDataSource();
strSQL = "SELECT ********* WHERE Facility.FacilityId = @FacilityID and ...
0
votes
1
answer
146
views
Multi-Threading on C# Dataset table rows making an external API call and update table with API Call results
I have a table in my SQL server/DB with close to 100,000 records. Using C# - need to loop thru the rows and make an external API call and update the results of the call into SQL table. I am new to ...
- 1
0
votes
1
answer
155
views
ASP.NET SqlDataSource want to put <%# Bind("StateID") %> into SelectCommand but fail with a message "The server tag is not well formed."
I wish to select the city name from tblCity Where the StateID will refer to the <%# Bind("StateID") %> but received with the error "The server tag is not well formed."
Is ...
- 11
1
vote
1
answer
762
views
ASP.NET - parametrize query for SqlDataSource in ASP.NET code behing- VB.NET / Visual Studio 2010
I am creating a query for a SqlDataSource in ASP.NET from code behind.
My code is as following:
Dim SqlDataSource1 As New SqlDataSource()
Dim SQL As String
' If Not IsPostBack Then
...
-1
votes
1
answer
59
views
Could not find control 'DropCity' in ControlParameter 'City' ERROR
Context: I am trying to nest two dropdownlist(ddl) inside a gridview, the first ddl is called "Ciudad" and the second one is called "Comuna", I want that according to the "...
0
votes
0
answers
67
views
SQL select with datasource in master page
I am wondering if it is possible to have a common SqlDataSource setup on a master page, then be able to use individual select statement within web pages that are based on that master page.
- 3
1
vote
1
answer
1k
views
DataSource controls not available in .NET Windows Forms app using Visual Studio 2019
I am running Visual Studio Community 2019 version 16.11.3, and I am having a problem with the data source controls (both SqlDataSource and ObjectDataSource).
Neither control shows up in the Data tab ...
- 149
0
votes
1
answer
190
views
asp:SqlDataSource with ROWVERSION (TIMESTAMP)
I ran into .NET (Framework, w/ WinForm and WebForms) / MS SQL project where significant tables in the database contain a TIMESTAMP (aka ROWVERSION) column (called tsModified) to prevent concurrency ...
- 473
0
votes
1
answer
155
views
What code is necessary to use escape character in asp.net:SQLDataSource control
I'm hoping someone has the answer to this problem. I am trying to pass a code behind value (@Artist) to the SqlDataSource control in an aspx file so that the value has a '&' in the string. The ...
- 1
1
vote
0
answers
46
views
No value given for one or more required parameter error for VBA in Excel
I have a SQL data table which contains below data.
In this I need to get the "Component" data which are structured under "Item" and after that each component will be considered as ...
3
votes
2
answers
3k
views
The name 'SqlDataSourceEnumerator' does not exist in the current context
In a C# .net 5 program in Visual Studio I am testing a code that is using SqlDataSourceEnumerator
public static List<SqlServerInstance> LocateSqlInstances()
{
List<SqlServerInstance> ...
- 99
0
votes
1
answer
62
views
How can I update existing SQL datasources (Live) to connect to correct views (reconnect) in Tableau Deskop?
I have one question. I am new in Tableau and I have to update existing SQL datasources (Live datasources) to connect to correct views (reconnect) in Tableau Deskop, because of some mappings/new data ...
-1
votes
1
answer
34
views
Please correct this QueryStringParameter
<td"><%#Eval("RegNo")%></td>
<asp:SqlDataSource ID="SqlDataSource4" runat="server"
ConnectionString="<%$ cn%>"
...
- 13
0
votes
0
answers
114
views
How to include a session variable in the update command of a datagrid asp.net
Super Beginner Here:)
My original scope was a simple datagrid where I could use the prebuilt vs2019 asp.net delete and edit properties of the datagrid.
<%@ Page Title="" Language="C#&...
- 9
0
votes
0
answers
758
views
ASP.NET SQLDataSource SelectParameters not set correctly
I have an ASP.NET web form coded like this:
<asp:TextBox
ClientIDMode="Static"
ID="_txtExitDate"
runat="server"
EnableViewState="true" />...
- 1,018
0
votes
1
answer
28
views
Selecting data from two tables based on record data containing a character in SQL
I'm having two tables - ItemMaster & PartItemMaster. Is it possible that if the record contains PT in itemCode (column from a third table), then data should be fetched from PartItemMaster table ...
0
votes
1
answer
122
views
Multiple Dropdownlists bound to one Dropdownlist
I'm really not sure how to ask this in a good or correct way. I need sort of help here. I'm not sure if this question was already answered in a different way. So please be patient.
How do I make 3 ...
- 11
1
vote
0
answers
95
views
GridViewDataComboBoxColumn: Taking value into datasource, updating problem
I'm working on a project using a Gridview and inside are 3 comboboxes (ComboboxColumn).
My first request when the page loads shows the different years where an organisation has a project in this year.
...
0
votes
1
answer
302
views
I want to update a GridView based off of a value selected from a DropDownList by editing my SqlDataSource
I'm trying to accomplish this by updating the SelectCommand on my SqlDataSource, clearing the GridView, and then reapplying the GridView.DataBind() based off the value in the dropdown. It's not ...
- 23
2
votes
1
answer
464
views
Displaying the data source in SSRS
How do I return and display the data source in SSRS?
I've got multiple data sources in the report in addition to Live vs. Test systems. How do I output/display a string with the data source.
- 1,741
0
votes
3
answers
190
views
OleDb SQLDATASOURCE can't select wildcard data
I've been tasked with applying sql parameters to a web page that's been identified as having a sql injection point. The originator used the typical inline sql string that is composed to do a wildcard ...
- 55
1
vote
1
answer
400
views
Using OS system variable for @DataSourceDefinition password failed in Wildfly 18
I want to externalize password for Java @DataSourceDefinition using OS system variable ${appuserpwd}. The below is my @DataSourceDefinition
@DataSourceDefinition(
name = "java:app/jdbc/mydb&...
- 9,715
0
votes
0
answers
45
views
Is there a way to load gridviews individually on page load?
I'm working on a monitoring webpage using C# & ASP.NET and I need to display data in multiple Gridviews with different data sources. Sometimes one of these data sources fails to connect or times ...
- 29
0
votes
1
answer
788
views
SSRS how to access Shared DataSet values in expression
I need to set the connection string somewhere in one place in SSRS project in order to use it in Data Sources across all the reports. As SSRS doesn't support project params it's recommended to create ...
- 393
0
votes
1
answer
557
views
EJB 3.1 remote access + Jboss 7.3 +JPA
I have created a EJB 3.1 application which uses remoting EJB project jar is deployed on Jboss application and Web project Client war is deployed on Tomcat server both the servers are running on ...
- 1
1
vote
1
answer
978
views
Kubernetes Persistent Volume for Pod in Production
I executed a scenario where I deployed Microsoft SQL Database on my K8s cluster using PV and PVC. It work well but I see some strange behaviour. I created PV but it is only visible on one node and not ...
2
votes
1
answer
7k
views
Error The database you are trying to open requires a newer version of Microsoft Access
I have a 2016 access file, when I try to access this file with an SQL or Access datasource in visual studio I get the following error message:
Database schema could not be retrieved for this ...
0
votes
1
answer
93
views
problem while inserting hindi text in mysql using wildfly
I am trying to insert some hindi text in mysql table from my web page. The server I am using is wildfly. I can insert the hindi text from mysql console. But when the same query is run from my bean ...
- 738
2
votes
1
answer
4k
views
GraphQL Query returning null. Not sure why though [duplicate]
I'm having some trouble with a graphQL query returning null and i'm not quite sure why its returning null. I've read several posts similar to this post but none of those posts have helped identify my ...
0
votes
1
answer
493
views
"TypeError: Cannot read property 'getAllParts' of undefined at allParts ..\\resolvers.js:6:62)",
I am having trouble figuring out why the object whos property is getting called is undefined. I am using graphql, apollo-server, and the following Data Source type https://github.com/cvburgess/...
0
votes
0
answers
263
views
how to filter boolean using sqldatasource parameter?
I have the following DropDownList :
<asp:DropDownList ID="GenderDropDownList" runat="server">
<asp:ListItem>Gender</asp:ListItem>
&...
0
votes
1
answer
227
views
Update DB through Gridview selected DDL from DataSource
I have one gridview which is connected through SQL Data source from one table and I have enabled the EDIT and delete columns of gridview. When I'm Editing the value of row, a column is having DDL in ...
- 19
0
votes
0
answers
72
views
Generate HTML table from SQLdatasource in ASP.net/VB.net
I worked on an online web template that has a lot of design classes.
I converted this web template to an ASPX file and all is good.
I then created some SQLdatasource to read data from a database (...
0
votes
1
answer
237
views
Cannot change SelectCommand contents dynamically
I am having an issue trying to change SelectCommand contents dynamically.
There is this Telerik searchbox control that uses SQLDataSource to constantly bang the DB with a select query and show up a ...
- 415