How to Structure a SELECT Statement 1

[nimarii]

Hello,

I'm having some problems creating a SELECT statement in my C# app.

Here's what I have so far:

SELECT bill_no FROM voice_main WHERE beg_stamp > convert(datetime,StartDateTbx.Text) AND end_stamp < convert(datetime, EndDateTbx.Text)";

StartDateTbx & EndDateTbx are both textboxes on the webform.

the error message i'm getting is:

The column prefix 'StartDateTbx' does not match with a table name or alias name used in the query. The column prefix 'EndDateTbx' does not match with a table name or alias name used in the query.

How do I reference these textboxes containing date information in the SQL statement?

 

[jbenson001]

Try this:

"SELECT bill_no FROM voice_main WHERE beg_stamp > convert(datetime, " + StartDateTbx.Text + ")AND end_stamp < convert(datetime," + EndDateTbx.Text + ")";

 

[nimarii]

Hi, thanks for the reply!

Here's the error message I get when using that:

c:\inetpub\[URL unfurl="true"]wwwroot\evisionwww\Views\Home\Pages\Reports.aspx.cs(76):[/URL] The type or namespace name 'StartDateTbx' could not be found (are you missing a using directive or an assembly reference?)

I think this could be a problem, since StartDateTbx is a textbox on the webform, but its contained within a usercontrol...

is there a way I can reference this control, or do I have to take a different approach to this?

 

[chiph]

The place where your SQL code is running will need access to the data contained in the control. So you'll need to pass it in as a parameter.

Chip H.


____________________________________________________________________
Donate to Katrina relief:

http://s1.amazon.com/paypage/PELYGQVJ8Q7IB/103-6821258-5919825

If you want to get the best response to a question, please read FAQ222-2244 first

 

[jbenson001]

I don't believe there is a way to reference the object that way. There may be, however, this defeats the whole purpose of user controls. User controls are supposed to be independent of any page.
You may have to pass the object to the usercontrol for you to use it, or you can just pass the text value.

 

[nimarii]

Thanks, I'm new at this, so its still a huge learning process for me.

How can I pass the parameters from the usercontrol to the webform, or do I need to open up the connection within the usercontrol?

I'm worried that I've just simply designed this too poorly for anything to work effectively....

 

[jbenson001]

Where is the code above being called? Are you clicking a button on the webform or the UC?

 

[nimarii]

I'm clicking a button on the webform itself...do i need to move the button to the UC?

 

[jbenson001]

Ok, so what is in the user control? what controls what code? I an just not getting what is where and why.

 

[nimarii]

The UC contains 4 fields: StartDateTbx, EndDateTbx, StartTimeDdlb, EndTimeDdlb. This UC also contains another UC which causes a pop-up calendar to open up, and is how the user populates the StartDateTbx & EndDateTbx fields.

The webform has this main UC, and then a button called "Populate Toll Free Numbers" followed by a dropdownlistbox, and another button called "Generate Report".

The "Populate Toll Free Numbers" button needs to populate the dropdownlistbox depending on the data contained in the UC (in order to generate the SQL Statement).

I know this is confusing - any suggesstions are completely welcome...

 

[jbenson001]

I was able to get the value in a textbox in the UC with this code. Remember this is VB code:

CType(Me.Page.FindControl("txtTest"), TextBox).Text

 

[jbenson001]

I think this is the correct C# code

((TextBox)(this.Page.FindControl("txtTest"))).Text();

 

[nimarii]

thanks Jim, its finally working!

 

[jbenson001]

cool.. glad you got it working..
Jim