Tagged Questions
0
votes
2answers
31 views
How to get a gridview to show all table rows when no text is entered in a dependent textbox?
The below works correctly and filters my gridview based on the text entered in my textbox.
When no text is entered into my textbox I get no results and cannot understand why.
MY QUESTION
How to get ...
1
vote
4answers
3k views
execute stored procedure using sqldatasource and get return value in vb.net
How can I execute a stored procedure using sqldatasource and get the return value in vb.net.
Thanks,
Terri
0
votes
2answers
50 views
Want gridview to fill only on button click
So I've been working on a search in asp.net using a sqldatasource with more than one control parameter. It's taken me a bit of looking into to get my table searchable if one control is filled in, but ...
1
vote
1answer
67 views
User.Identity.Name to SQL parameter
I have this code:
protected void Page_Load(object sender, EventArgs e)
{
SqlDataSource4.SelectParameters["zadavatel"].DefaultValue = this.Page.User.Identity.Name;
}
Markup:
...
0
votes
0answers
42 views
How I built a SQL Database connectionstring right?
I have a problem with a connectionstring in a html file ... is this connectionstring form false?
objConnection.Open "Provider=SQLOLEDB;Data ...
1
vote
2answers
158 views
ASP.NET SqlDataSource, like on SelectCommand
I'm working on asp.net. I Have a SqlDataSource with a query hardcoded on selectcommand:
<asp:SqlDataSource ID="DataSource1" runat="server" CancelSelectOnNullParameter="False"
...
0
votes
1answer
118 views
Error when displaying data in a datalist from sqldatasource in asp project
I am building a website for a class and have come across an error that I can not find the solution to. I have a dropdownlist on the page that displays the cutomer name and sets the selected value to ...
0
votes
2answers
252 views
Using C# SQL Parameterization on Column Names
I'm having a problem. I want this to work, but it doesn't:
SqlDataSource.SelectCommand = "SELECT blah1, blah2 FROM myTable WHERE @ColumnName = @Value";
...
0
votes
4answers
412 views
Proper populating of dropdown list in asp.net dynamically
I am a newbie in asp.net, I want to ask what is more proper in terms of populating the dropdown list in asp.net? using a Datasource or using a sqldatareader and a for loop.
I am using the ...
1
vote
0answers
82 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 ...
0
votes
0answers
87 views
Create and navigate an SQL query in VB.NET
I'm fairly new to VB.NET (upgrading from VB6 and VBA). I'm trying to write a sub that queries a datasource (datasource is setup and working) that I can then navigate in VB.
Im trying to do what I ...
0
votes
1answer
35 views
Error in sorting dynamically with a dropdownlist
I want to connect the SqlDataSource to the grid view and change the sorting data dynamically with a dropdownlist.
I used this code and it gave me this error:
code:
SELECT ...
FROM ...
ORDER BY
...
1
vote
1answer
92 views
Dynamic order by in SqlDataSource by a dropdownlist and grid view
I have a grid view that connect to the DataSqlSource. I want to sort my queries dynamically by a dropdownlist. for example by date,name,family etc.
I also join some tables in my queries.
I use this ...
0
votes
0answers
173 views
Error only using JSTL (No suitable driver found for dataSource)
I'm using this code in Servlets to use the Database:
Class.forName("com.mysql.jdbc.Driver");
DriverManager.getConnection("jdbc:mysql://localhost/petshop", user, password);
And it works fine. Now ...
2
votes
1answer
218 views
How to change this Ext.Net example to use Sql instead of Linq?
I am going by this example and trying to have it use a SqlDataSource instead of LinqDataSource. I can get the data to display in the table, but the form does not fill with the data when I select a ...
