Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: shangrilla
  • Content: Threads
  • Order by date
  1. shangrilla

    Seperate Value & Code for Combo box

    Hi: Table with 2 columns KeyValue DisplayValue 1 Tables 2 Chairs . . Can I have a combo box in which the display value is 'Tables, Chairs...', but the code to look up these values is '1,2...'?
  2. shangrilla

    Alert all users?

    How can I send a message to all users currently using the application? I can use javascript alert and call it on a form load, but I want something that will occur application wide not just when that particular form is loaded. For example in Global.asax file in Sub...
  3. shangrilla

    Char Value in SQL Server

    name is a char field stored as null in the database. I send name to the following function, but It never returns true. static private bool checkSpaces(char name) { bool val=false; try { if (name.Equals("") || name.Equals(null) || Convert.IsDBNull(name)) val =true; } catch {val=...
  4. shangrilla

    Attribues.Add()

    I want to change the color of the form if a particular label is visible. lblGo.Attributes.Add(&quot;onload&quot;, &quot;color();&quot;) 'doesn't Work lblGo.Attributes.Add(&quot;onclick&quot;, &quot;color();&quot;) 'works but doesn't serve my purpose <script language=&quot;javascript&quot;>...
  5. shangrilla

    Change form backcolor

    How can I change the backcolor of a form on server side? Private sub button1_click Form1.ActiveForm.BackColor = System.Drawing.Color.Red ' isn't working. end sub
  6. shangrilla

    SQL Between

    I am trying to get data where lastName falls between 2 values eg: A thru E. This would only give me data where lastNames are from A thru D. I am using BETWEEN val1 and val2 Can I modify this statement or use something else to include lastNames starting with E also. Thanks
  7. shangrilla

    Adding unbound column to a grid

    Hi All: I have a dataGrid(bound to a datatable). After the grid is loaded I add an unbound column to the grid. This new column is the last column(right most) in the grid. I want this new column to be the left most column when the grid is displayed. How can I do that? Thanks.
  8. shangrilla

    Rows on active page in datagrid

    Hi: I have a dataGrid (bound to a datatable) that displays 25 rows per page. How can I find out the # of rows being displayed on the current page? Thanks in advance.
  9. shangrilla

    Calculate # or rows per page in datagrid

    Hi: I have a dataGrid(bound to a datatable) that displays 25 rows per page. How can I find out the # of rows being displayed on the current page? Thanks
  10. shangrilla

    Problem inserting records

    Tables XXX and YYY have the same structure. USE XXX scan SCATTER MEMVAR INSERT INTO YYY FROM MEMVAR where xxx.pkey <> yyy.pkey (error in above statement) endscan How can I fix this problem?
  11. shangrilla

    Check for Uniqueness when Appending data

    Hi: I am appending data from one table to another table. Both tables have the same indexes, but each table is stored in a different location. if not used('origTable') use origTable endif if not used('appendTable') use appendTable endif append from origTable where country =...
  12. shangrilla

    Create New Table from existing table

    Hi: I need to create a new table that has the same structure as an existing table. For eg: c:\myApp\SalesMan.dbf (this already exists) I need to create c:\test\SalesMan.dbf (this should have the same structure as c:\myApp\SalesMan.dbf) Thanks in advance
  13. shangrilla

    Read a textfile line by line

    I get a text file without any line breaks. It looks something like this: 1234567890~ABCDEFGH~0987654321~HHGFEDCBA~ So ~ means a line break. I am using the streamreader.readline() method and it works fine when the file is like: 1234567890~ ABCDEFGH~ 0987654321~ HHGFEDCBA~ How Can I read...
  14. shangrilla

    Read a textfile

    I get a text file without any line breaks. It looks something like this: 1234567890~ABCDEFGH~0987654321~HHGFEDCBA~ So ~ means a new line. I am using the streamreader.readline() method and it works fine when the file is like: 1234567890~ ABCDEFGH~ 0987654321~ HHGFEDCBA~ How Can I read...
  15. shangrilla

    Set target frame

    Is there any way I can set the target frame of my page to _top. I want this page(login) to open always on top of all open pages. Top Frame (Menu) Left Right Frame (Pages) Frame Page opens here w/ left & top frame visible. (Tree) I only want to...
  16. shangrilla

    Redirect after session timeout.

    Hi: How can I redirect the users back to the login page after the session has timed out? Thanks
  17. shangrilla

    AccessKey &amp; HTML

    Is there any way I can send the access key info in url, so when the page loads it goes to a particular text box with the focus.
  18. shangrilla

    Bookmarks on web forms

    Hi: I am redirecting users from one form to another --> Redirect(&quot;WebForm.aspx?id=&quot;1234) How can I put a bookmark on the webform and redirect them to a certain portion of the form where the bookmark is placed. Sonmthing Like(&quot;WebForm.aspx?id=&quot;1234&quot;#PSR&quot;) The...
  19. shangrilla

    Set Rounding off

    Hi: I am debugging some code that is rounding off values like 49.16 to 49.20 etc. Doesn't make any sense but Select ......,nvl(view1.total) as amnt LEFT OUTER JOIN view1; ON table1.key= view1.key; group by table1.key into table tmpTable nvl() was causing the problem. I took...
  20. shangrilla

    Range Validator problem with dates

    I am using a RangeValidator control to validate if a Date is greater than today's date. RangeValidator1.MaximumValue = Now.Date RangeValidator1.MinimumValue = Now.AddYears(-150).Date It accepts all values > 2000 as 02/02/00 or 02/02/2000 , but doesn't accept 02/02/99. I have to enter...

Part and Inventory Search

Back
Top