Recent content by nerdalert1

How can I set this into a declared variable so I can use this in an IN Statement DELCARE @CustList AS varchar(50) SET @CustList = '1','2','3','4' SELECT * from tblCustomer where CustNumb IN (@CustList)

Ya I am confused I think this might not work either. Maybe I just need to use straight javascript code. Calling on the exit of a textbox a function that prompts a confirm and if the user clicks yes then fill the txtbox(x).Text with the same values

This is what I have so far in my code behind but its not working: Dim sb As New StringBuilder sb.Append("<script language=javascript>") sb.Append("if (confirm('Your query returned over 1000 records. Do you want to proceed?')") sb.Append("{")...

How do I call javascript function called "messageuser" from the change event of a text box in ASP.Net

Thanks SQLSister

Hello all. When Selecting from the Inserted table on a trigger wont there always be just one record? UPDATE Customer Set MailSend = 1 where CustNumb = (SELECT CustNumb FROM INSERTED) This is on the insert of a new record. Wont I only have one value for this each time? Somehow I am...

I needed the autopostback = true thats what I really needed. It seems to be working now. One last question I need to prompt the user if they want to roll the totals into the other textboxes. The routine is firing now correctly. How do I prompt the user with a Yes No dialog and then run my...

How would I do that? I have the textbox as Runat="server".

Can I call a VB Code Behind routine from within the javascript?

Hello all. I have 12 textboxes on a form where currently I have a client control validator for each checking if the value is currency. How can I also call a sub routine either on the change or exit of the textbox to call a Total Sub Routine which adds up the textboxes and places it into a...

I got it to work. Do you happen to know how I can on the update of a textbox or the lost focus call a Total routine in my code behind? I already have a validator on the box checking for currency. But now I need to call a Totl routine on each box.

Getting this error: Index (zero based) must be greater than or equal to zero and less than the size of the argument list.

I need to total textboxes going across. However I do not want to place a "0" in the textbox itself. Can I somehow default in my code that value to 0 without having to complete IF statements. Right now it goes (Cdbl(textbox1.text) + CDbl(textbox2.text).ToString But one of the values could be...

I have a datagrid where I have a "DataFormatString="{0:#,##0.00}" as the format of the column. I am using CDbl to total columns with a .ToString at the end to fill a textbox. How can I make this the same format so lets say 10000 comes up 10000.00 thanks all.

Is there a way to force my dropdown list to open down on page. When I open the box the values all flow up over the page then going down.