473,246 Members | 1,337 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,246 software developers and data experts.

Select string building in C# and ASP.NET

How would I go about using a custom select string that is passed from a form
to the SelectCommand parameter of SqlDataSource?

I tried:
SelectCommand = "<% Request.Form("hdnSelect") %>"

but I got an error about putting <% %> tags in a literal. I tried taking
out the quotes (the " ") and it didn't do any good. I'm trying to use the
built in ASP.NET 2.0 DataList control, but I haven't come up with anything.

Thanks,
Jacob
Dec 22 '05 #1
4 1991
Hi,

Did you tried:

SelectCommand = Request.Form("hdnSelect").ToString()

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Jacob Arthur" <ja******@community.nospam> wrote in message
news:e$**************@TK2MSFTNGP09.phx.gbl...
How would I go about using a custom select string that is passed from a
form to the SelectCommand parameter of SqlDataSource?

I tried:
SelectCommand = "<% Request.Form("hdnSelect") %>"

but I got an error about putting <% %> tags in a literal. I tried taking
out the quotes (the " ") and it didn't do any good. I'm trying to use the
built in ASP.NET 2.0 DataList control, but I haven't come up with
anything.

Thanks,
Jacob

Dec 22 '05 #2
Just tried something a little different, still no luck.

I tried putting the line
SqlDataSource1.SelectCommand = docList;

In to the Page_Load event to make sure it was getting there and it did
during debugging, but there is no data being pulled back. I traded out the
command for

SqlDataSource1.SelectCommand = "select '1'";

and it still doesn't bring anything back in the datalist. Am I missing
something here possibly?

Jacob

"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT dot.state.fl.us> wrote
in message news:uS*************@TK2MSFTNGP12.phx.gbl...
Hi,

Did you tried:

SelectCommand = Request.Form("hdnSelect").ToString()

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Jacob Arthur" <ja******@community.nospam> wrote in message
news:e$**************@TK2MSFTNGP09.phx.gbl...
How would I go about using a custom select string that is passed from a
form to the SelectCommand parameter of SqlDataSource?

I tried:
SelectCommand = "<% Request.Form("hdnSelect") %>"

but I got an error about putting <% %> tags in a literal. I tried taking
out the quotes (the " ") and it didn't do any good. I'm trying to use
the built in ASP.NET 2.0 DataList control, but I haven't come up with
anything.

Thanks,
Jacob


Dec 23 '05 #3
Hi,

is your problem in how to get the request which brings your query, or how to
get the data from the database?

post your entire method (where you get the value of the request, and where
you get your data from the DB)
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Jacob Arthur" <ja******@community.nospam> wrote in message
news:uQ**************@tk2msftngp13.phx.gbl...
Just tried something a little different, still no luck.

I tried putting the line
SqlDataSource1.SelectCommand = docList;

In to the Page_Load event to make sure it was getting there and it did
during debugging, but there is no data being pulled back. I traded out
the command for

SqlDataSource1.SelectCommand = "select '1'";

and it still doesn't bring anything back in the datalist. Am I missing
something here possibly?

Jacob

"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT dot.state.fl.us>
wrote in message news:uS*************@TK2MSFTNGP12.phx.gbl...
Hi,

Did you tried:

SelectCommand = Request.Form("hdnSelect").ToString()

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Jacob Arthur" <ja******@community.nospam> wrote in message
news:e$**************@TK2MSFTNGP09.phx.gbl...
How would I go about using a custom select string that is passed from a
form to the SelectCommand parameter of SqlDataSource?

I tried:
SelectCommand = "<% Request.Form("hdnSelect") %>"

but I got an error about putting <% %> tags in a literal. I tried
taking out the quotes (the " ") and it didn't do any good. I'm trying
to use the built in ASP.NET 2.0 DataList control, but I haven't come up
with anything.

Thanks,
Jacob



Dec 23 '05 #4
In the code behind file:
static String docList;
protected void Page_Load(object sender, EventArgs e)
{
SqlDataSource1.SelectCommand = docList;
}
protected void Button1_Click(object sender, EventArgs e)
{
docList = "";
String currDocId = "";
docList = "SELECT DocIdFld, NameFld FROM doctbl WHERE ";

System.Collections.Queue docIDQ = new System.Collections.Queue();
txtDocIDs.Text = txtDocIDs.Text + "\n";
for (int i = 0; i < txtDocIDs.Text.Length; i++)
{
if (Char.IsLetterOrDigit((char)txtDocIDs.Text[i]))
currDocId += (char)txtDocIDs.Text[i];
else if (currDocId != "")
{
docIDQ.Enqueue(currDocId);
currDocId = "";
}
}
if (docIDQ.ToArray().GetLength(0) != 0)
{
for (int i = 0; i < docIDQ.ToArray().GetLength(0); i++)
{
docList = docList + "DocIdFld = " +
((String)docIDQ.ToArray()[i]).ToString();
if (i + 1 < docIDQ.ToArray().GetLength(0))
{
docList = docList + " OR ";
}
}
}
hdnSelect.Value = docList;
Label1.Text = docList;
}

And in the main page file:
<asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource1">
</asp:DataList><asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" >
</asp:SqlDataSource>

My query string is getting built fine. The string (docList) is actually
stored to a label which is visible for debugging purposes. If I go out to
Query Analyzer, it brings back the rows that I would expect with the exact
select string pasted into it. For some reason though, it never actually
brings any results back on the server. Do I need to add a
SqlDataSource1.Select() or something similar after changing the select
command in the code-behind file perhaps?

Thanks,
Jacob

"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT dot.state.fl.us> wrote
in message news:Oh**************@TK2MSFTNGP12.phx.gbl...
Hi,

is your problem in how to get the request which brings your query, or how
to get the data from the database?

post your entire method (where you get the value of the request, and where
you get your data from the DB)
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Jacob Arthur" <ja******@community.nospam> wrote in message
news:uQ**************@tk2msftngp13.phx.gbl...
Just tried something a little different, still no luck.

I tried putting the line
SqlDataSource1.SelectCommand = docList;

In to the Page_Load event to make sure it was getting there and it did
during debugging, but there is no data being pulled back. I traded out
the command for

SqlDataSource1.SelectCommand = "select '1'";

and it still doesn't bring anything back in the datalist. Am I missing
something here possibly?

Jacob

"Ignacio Machin ( .NET/ C# MVP )" <ignacio.machin AT dot.state.fl.us>
wrote in message news:uS*************@TK2MSFTNGP12.phx.gbl...
Hi,

Did you tried:

SelectCommand = Request.Form("hdnSelect").ToString()

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"Jacob Arthur" <ja******@community.nospam> wrote in message
news:e$**************@TK2MSFTNGP09.phx.gbl...
How would I go about using a custom select string that is passed from a
form to the SelectCommand parameter of SqlDataSource?

I tried:
SelectCommand = "<% Request.Form("hdnSelect") %>"

but I got an error about putting <% %> tags in a literal. I tried
taking out the quotes (the " ") and it didn't do any good. I'm trying
to use the built in ASP.NET 2.0 DataList control, but I haven't come up
with anything.

Thanks,
Jacob



Dec 23 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

15
by: grunar | last post by:
After some thought on what I need in a Python ORM (multiple primary keys, complex joins, case statements etc.), and after having built these libraries for other un-named languages, I decided to...
3
by: Tcs | last post by:
My backend is DB2 on our AS/400. While I do HAVE DB2 PE for my PC, I haven't loaded it yet. I'm still using MS Access. And no, I don't believe this is an Access question. (But who knows? I...
8
by: Jacob Arthur | last post by:
How would I go about using a custom select string that is passed from a form to the SelectCommand parameter of SqlDataSource? I tried: SelectCommand = "<% Request.Form("hdnSelect") %>" but I...
2
by: areef.islam | last post by:
Hi, I am kinda new to javascript and I am having this problem with selecting multiple options from a select tag. Hope someone can help me out here. here is my code...
5
by: Henning M | last post by:
Hi all, I having some problems with Access and selecting records between dates.. When I try this in access, it works fine!! "Select * from Bilag Where Mdates Between #1/1/2006# And...
2
by: johnhanis | last post by:
I'm using a Visual Basic front end with an SQL query to select some data from a MS Access database. I have a table named Tithes with Columns of TitheDate Tither No Total Tithes Faith Promise...
6
by: alex.kemsley | last post by:
Hi guys, I have the following sql statemant to search a mysql database that gets if values from a form with combo box's in. SELECT * FROM hottubs, manufacturers WHERE manufacturers.manid =...
5
by: =?Utf-8?B?bWNhdWxpZmZl?= | last post by:
I have an old application ( pre-VB5) that I need to add a select/option list to. This is an edit program so the values for the form will be retrieved from a database. How do I set the value of...
1
by: The.Daryl.Lu | last post by:
Hi, two parts to my problem if someone can help address either one or both: 1. I want to SELECT everything in the table if it matches the criteria when the query button is pressed (this is just...
7
by: php_mysql_beginer911 | last post by:
Hi .. hope someone will help i am trying to figure it out why i cannot post string "union select" every time i try to post data which content union and select .. the page doesn't get posted and...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.