Re: No. of hites facility in my website - ASP.NET Discussion Boards

afreshpulse27-Jun-07 4:45

27-Jun-07 4:45

I have a site where a user can input the first part of their post code to see if deliveries can be made to their area. Deliveries are only available in one area, so I use the following code:

	Private Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click<br />
<br />
		Dim al As New ArrayList()<br />
		Dim i As Integer<br />
<br />
		For i = 1 To 32<br />
			al.Add("BS" & i)<br />
		Next i<br />
<br />
		Dim postCode = Me.txtPostCode.Text<br />
<br />
		Dim idx As Integer = al.BinarySearch(postCode, New CaseInsensitiveComparer())<br />
<br />
		If idx > 0 - 1 Then<br />
			Me.litMsg.Text = "We can collect from you"<br />
		Else<br />
			Me.litMsg.Text = "We do not collect from your area"<br />
		End If<br />
<br />
	End Sub

This finds the first postcode, but none of the others. Is there something wrong in the code? Should I just use a database table and pull values from there instead?

Damian

Re: Values in array

RichardGrimmer27-Jun-07 5:45

RichardGrimmer

27-Jun-07 5:45

Couldn't you use the following if you're only supporting one delivery area:

<br />
<br />
string str = txtPostcode.text;<br />
if (str.StartsWith ("BS"))<br />
 ...<br />
else<br />
...<br />

"Knock me down, I'll get straight back up again, I'll come back stronger than a powered up pacman"
(Lilly Allen / Kaiser Chiefs)

Re: Values in array

afreshpulse27-Jun-07 6:24

afreshpulse

27-Jun-07 6:24

Hi Richard, thanks for responding.

I could use the StartsWith method (which works), However, the postcodes range from BS1 to BS32. So if a user types 'BS43' they still get the 'We can collect from you' message.

Any thoughts?

Damian

Re: Values in array

Urs Enzler27-Jun-07 8:40

Urs Enzler

27-Jun-07 8:40

Put all valid postcodes into an List<string> and use the Contains method:

List<string> postalcodes = new List<string>();

// add all codes
postalcodes.Add("BS1");
...

if (postalcodes.Contains(TextBox.Text))
...
else
...

-^-^-^-^-^-
no risk no funk

Re: Values in array

RichardGrimmer27-Jun-07 9:38

RichardGrimmer

27-Jun-07 9:38

Yeah - what he said lol...

"Knock me down, I'll get straight back up again, I'll come back stronger than a powered up pacman"
(Lilly Allen / Kaiser Chiefs)

No. of hites facility in my website

pathak7827-Jun-07 4:42

pathak78

27-Jun-07 4:42

I want to give facility of no. of hites in my site.

If any one have some idea about this.

please give me some source code.

Thanks,

Pathak

Re: No. of hites facility in my website

Christian Graus27-Jun-07 11:00

Christian Graus

27-Jun-07 11:00

You can store this in a file or in the database. Store a number, have code that increments the number called when a page is being served.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: No. of hites facility in my website

Vasudevan Deepak Kumar27-Jun-07 21:40

Vasudevan Deepak Kumar

27-Jun-07 21:40

Check out http://www.hotscripts.com/[^] for counters in different languages.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Property value after PostBack of UserControl

ZeedijkMike27-Jun-07 4:41

ZeedijkMike

27-Jun-07 4:41

Hi Allm

I have created a MaskedTextBox UserControl with a number of properties (Value, MinValue, MaxValue etc.) The UserControl works but I am not able to actually get the Value from the UserControl in the main apsx page. In short what I have done:

UserControl with a TextBox, a RangeValidator and some JavaScript to take care of the formatting.

In the main page:

<uc1:MaskedTextBox ID="MaskedTextBox2" runat="server" MinValue="-10000" MaxValue="10000" ErrorMessage="Value must be between {0} and {1}" Required="true" Display="None" /><br />
<br /><br />
<asp:Button ID="Button1" runat="server" Text="Button" /></div><br />
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label><br />

And in the code behind on_load event:

<br />
    protected void Page_Load(object sender, EventArgs e)<br />
    {<br />
        if (Page.IsPostBack)<br />
        {<br />
            Label2.Text = MaskedTextBox2.TextValue.ToString();<br />
        }<br />
    }<br />

But the value of the TextValue property is not available because the UserControl is loaded after the Page_Load event. How do I get the TextValue of the UserControl in the PostBack of the aspx page?
I would prefer not to use Session or ViewState because I would like to use the UserControl as I would use a 'normal' TextBox. Any ideas out there?

Kind regards,

Mike

Re: Property value after PostBack of UserControl

ZeedijkMike27-Jun-07 4:43

ZeedijkMike

27-Jun-07 4:43

Woops sorry for the double post Unsure | :~

Mike

Re: Property value after PostBack of UserControl

SHatchard27-Jun-07 5:28

SHatchard

27-Jun-07 5:28

If you want to do this I would suggest using an event

In your class

Public Event TextChanged(byval sender as object, byval e as eventargs)

Then pick up the text changed and bubble it

Public Sub textbox1_TextChanged(byval sender as object, byval e as eventargs) handles textbox1.textchanged
raiseevent textchanged(me, e)
end sub

Then you can use the event as normal within your aspx page.

If you need clarification please let me know

Re: Property value after PostBack of UserControl

ZeedijkMike27-Jun-07 5:56

ZeedijkMike

27-Jun-07 5:56

Thanks for the reply.

I'll try you solution. It looks somewhat better than the the solution I came up with my self. I try to dig in to the UserControl to get the value like this;

Label1.Text = (MaskedTextBox1.Controls[2] as TextBox).Text;

But working with events seems to be a more proper way.

Thanks,

Mike

Re: Property value after PostBack of UserControl

Urs Enzler27-Jun-07 8:44

Urs Enzler

27-Jun-07 8:44

What is causing the postback? I assume the Button.

Put your code in the event handler of the postback initiator instead of the load event handler. That would then be the Button_Click event handler if my assumption is right.

Happy Programming
Urs

-^-^-^-^-^-
no risk no funk

Retrieving Property value after PostBack of UserControl

ZeedijkMike27-Jun-07 4:39

ZeedijkMike

27-Jun-07 4:39

<uc1:MaskedTextBox ID="MaskedTextBox2" runat="server" MinValue="-10000" MaxValue="10000" ErrorMessage="Value must be between {0} and {1}" Required="true" Display="None" /><br />
<br /><br />
<asp:Button ID="Button1" runat="server" Text="Button" /></div><br />
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label><br />

And in the code behind on_load event:

<br />
    protected void Page_Load(object sender, EventArgs e)<br />
    {<br />
        if (Page.IsPostBack)<br />
        {<br />
            Label2.Text = MaskedTextBox2.TextValue.ToString();<br />
        }<br />
    }<br />

Mike

Re: Retrieving Property value after PostBack of UserControl

Venkatesh Mookkan27-Jun-07 17:38

Venkatesh Mookkan

27-Jun-07 17:38

Can you post the code used for the TextValue property? Use ViewState for the TextValue property. I believe you must be using String variable instead.

Regards,
Venkatesh Mookkan.
Software Engineer, India
My: Website | Yahoo Group | Blog Spot

SQL Query works intermittently...

TenmanS1427-Jun-07 4:39

TenmanS14

27-Jun-07 4:39

For some reason the code below to fill a datagridview works very intermittently, I was wondering if anyone could spot any coding horrors my inexperience may have allowed in there...

dateFrom = "CONVERT(DateTime, '01/" & MonthDD.SelectedIndex + 1 & "/" & Trim(YearDD.SelectedValue) & "', 103)"

If MonthDD.SelectedValue <> "December" Then
dateTo = "CONVERT(DateTime, '01/" & MonthDD.SelectedIndex + 2 & "/" & Trim(YearDD.SelectedValue) & "', 103)"
Else
dateTo = "CONVERT(DateTime, '01/01/" & Trim(YearDD.SelectedValue + 1) & "', 103)"
End If

SQLString1 = "SELECT [InvoiceNo], [ClientCode], [Date], [PnrCode], [Initials], [Amount], [AccyNC4000], [DisbsNC4090], [DKpgmgmtNC4050], [CorpTaxNC4021], [PersTaxNC4030], [PayrollNC4070], [ExectrustNC4031], [CoySecNC4010], [OtherNC4080], [AccyNC4000]+[DisbsNC4090]+[DKpgmgmtNC4050]+[CorpTaxNC4021]+[PersTaxNC4030]+[PayrollNC4070]+[ExectrustNC4031]+[CoySecNC4010]+[OtherNC4080] as [Total] FROM [transaction] WHERE ("

If PartnerDD.SelectedItem.Value <> 0 Then
SQLString1 = SQLString1 & "([PnrCode] = @PnrCode) AND "
End If

If ClientCodeDD.SelectedItem.Text <> "Select a Client Code" Then
SQLString1 = SQLString1 & "([ClientCode] = @ClientCode) AND "
End If

SQLString1 = SQLString1 & "([Date] >= " & dateFrom & ") AND ([Date] < " & dateTo & "))"

SqlDataSource1.SelectCommand = SQLString1

Re: SQL Query works intermittently...

Colin Angus Mackay27-Jun-07 5:12

Colin Angus Mackay

27-Jun-07 5:12

TenmanS14 wrote:
I was wondering if anyone could spot any coding horrors my inexperience may have allowed in there...

You should use paramertised queries rather than injecting values in to the SQL. See SQL Injection Attacks and tips on how to prevent them[^]... Actually later on you are using parameters! OMG | :OMG:

Why use two different ways of doing things?

Other than that I can't really see what you are trying to do. The code is quite difficult to read.

Perhaps you need to isolate this SQL and see how it runs on its own with various inputs to see if you can determine where exactly it is failing.

Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5

Ready to Give up - Your help will be much appreciated.

My website

Re: SQL Query works intermittently...

TenmanS1427-Jun-07 5:26

TenmanS14

27-Jun-07 5:26

because the dates come from a dropdown that contains a list of months and a dropdown that contains a list of years, these have then to be concatenated into Date Format with variables that I'm using in the SQL statement. This is going to be running on a company intranet so I'm not that worried about SQL Injection attacks

Code to populate the drop downs runs in not page.ispostback

thisMonth = Month(Now())
thisYear = Year(Now())

For j = thisYear - 5 To thisYear + 5
YearDD.Items.Add(Str(j))
Next

MonthDD.Items.Add("January")
MonthDD.Items.Add("February")
MonthDD.Items.Add("March")
MonthDD.Items.Add("April")
MonthDD.Items.Add("May")
MonthDD.Items.Add("June")
MonthDD.Items.Add("July")
MonthDD.Items.Add("August")
MonthDD.Items.Add("September")
MonthDD.Items.Add("October")
MonthDD.Items.Add("November")
MonthDD.Items.Add("December")

MonthDD.SelectedIndex = thisMonth - 1
YearDD.SelectedIndex = 5

Re: SQL Query works intermittently...

Colin Angus Mackay27-Jun-07 6:09

Colin Angus Mackay

27-Jun-07 6:09

TenmanS14 wrote:
This is going to be running on a company intranet so I'm not that worried about SQL Injection attacks

Statistiacally most attacks are insider jobs.

TenmanS14 wrote:
because the dates come from a dropdown that contains a list of months and a dropdown that contains a list of years, these have then to be concatenated into Date Format with variables that I'm using in the SQL statement

Or you could do that to create a DateTime object then pass that as a parameters.

Re: SQL Query works intermittently...

TenmanS1427-Jun-07 8:47

TenmanS14

27-Jun-07 8:47

OK, had a go at getting that variable as a parameter as well, works OK, but I still have the same problem, if I change the year or the month drop down and repost the page, it doesn't seem to run the query, as soon as I change the ClientCode or Partner dropdown and repost it, it runs the query with the correct Dates selected as well... This is going to be something really simple I feel and I'm going to look like a right tool...

SQLString1 = "SELECT [InvoiceNo], [ClientCode], [Date], [PnrCode], [Initials], [Amount], [AccyNC4000], [DisbsNC4090], [DKpgmgmtNC4050], [CorpTaxNC4021], [PersTaxNC4030], [PayrollNC4070], [ExectrustNC4031], [CoySecNC4010], [OtherNC4080], [AccyNC4000]+[DisbsNC4090]+[DKpgmgmtNC4050]+[CorpTaxNC4021]+[PersTaxNC4030]+[PayrollNC4070]+[ExectrustNC4031]+[CoySecNC4010]+[OtherNC4080] as [Total] FROM [transaction] WHERE "

If PartnerDD.SelectedItem.Value <> 0 Then
SQLString1 = SQLString1 & "([PnrCode] = @PnrCode) AND "
End If

If ClientCodeDD.SelectedItem.Text <> "Select a Client Code" Then
SQLString1 = SQLString1 & "([ClientCode] = @ClientCode) AND "
End If

SqlDataSource1.SelectParameters.Item("dateFrom").DefaultValue = dateParam
SqlDataSource1.SelectParameters.Item("dateTo1").DefaultValue = dateParam1

SQLString1 = SQLString1 & "([Date] >= @DateFrom) AND ([Date] < @DateTo1)"
MsgBox(SQLString1)
SqlDataSource1.SelectCommand = SQLString1

Re: SQL Query works intermittently... [modified]

TenmanS1427-Jun-07 9:20

TenmanS14

27-Jun-07 9:20

Fixed it.... had to make an invisible asp:label so I could pass the value from a controlparameter and bind the labels text property as the value...

-- modified at 15:57 Wednesday 27th June, 2007 cos I'm a prat and wrote commandparameter instead of controlparameter :p

urgent need about stored procedure...,

Member 387988127-Jun-07 3:21

Member 3879881

27-Jun-07 3:21

This is the actual result from my procedure

18-Mar-03 AUD -7.4505805969238281E-9
07-Apr-03 AUD -7.9162418842315674E-9
09-Apr-03 AUD 5.2386894822120667E-10
17-Apr-03 AUD -7.9162418842315674E-9

but My expected result is

18-Mar-03 AUD -7.45058
07-Apr-03 AUD -7.91624
09-Apr-03 AUD 5.23868
17-Apr-03 AUD -7.91624

Please help the do this process how to perform this?

Regards,
Magi

Re: urgent need about stored procedure...,

Colin Angus Mackay27-Jun-07 3:37

Colin Angus Mackay

27-Jun-07 3:37

What does this have to do with ASP.NET (a framework designed for writing web applications)?

This should go in the SQL Forum.

Re: urgent need about stored procedure...,

dekart_roo27-Jun-07 6:46

dekart_roo

27-Jun-07 6:46

It's sounding to me like you might be needing to do some string formats. Check out this link... I think it's the answer to your question.

http://blog.stevex.net/index.php/string-formatting-in-csharp/

-Roo

Printing

Blue_Boy27-Jun-07 3:10

Blue_Boy

27-Jun-07 3:10

How can I print window directly to printer without displaying print-dialogbox?

Regards

I Love SQL

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.