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!

Register Log in
  • 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: James1981
  • Content: Threads
  • Order by date
  1. James1981

    Does changing a dll require re-register?

    Hi, I want to know if I make changes to a DLL and upload it to my webserver, do I have to reregister the DLL on the server? Thanks, James
  2. James1981

    Problem with foreach (Control loop

    Hi I've got the following loop: foreach (DropDownList ddl in myPanel.Controls) { ddl.ClearSelection(); } I keep on getting a cast error, saying that it can't cast to DropDownList. I know there are DropDownList controls within the panel I am looping thru, as I have debugged and seen...
  3. James1981

    DB Connection Question

    Hi there, I want to encapsulate a db connection into a class and then have a static method within this class that returns an open connection to a database. I want to know if the connection is closed properly, as the method returns the connection before the closed() command is called. Here is...
  4. James1981

    Best method to make all panels not visible

    Hi I'm trying to set the visible property on all panels on my page. Is this possible using a foreach loop? I have tried using the following but it doesn't work: foreach (Panel p in Page.Controls) { do something } Does anyone know where I am going wrong? Cheers, JAmes
  5. James1981

    Adding attribute to <body> tag

    Hi I want to add an attribute at runtime to the body tag e.g. <body myAttribute=1> How do I go about doing this? Thanks James
  6. James1981

    SQL Server Connection Timeout

    Hi, I have a Stored Procedure that takes a very long time to run, I'm getting a problem that I think is due to the connection to the DB timing out. Is there a default amount of time after which the connection times out if no result is given from the SQL server? If so, how can I change this...
  7. James1981

    Calculate no of weekdays in date range

    Hi, Is there an easy way to calculate the no of weekdays (not weekends) in a specified date range? Cheers James
  8. James1981

    Need to identify if a workbook was opened by another workbook

    Hi, I have a workbook which I open using a macro, and I need to tell whether the workbook has been opened by the macro (in the first workbook) or by the user manually... Is there an easy way of doing this within the Workbook_Open() method Thanks, James
  9. James1981

    Halting a Macro

    Hi, Is there anyway to stop a macro from running in VBA/Excel? The only thing I can find is Application.Quit but I don't want to close the Workbook... James
  10. James1981

    Excel - On Cell Change Event

    Hi, Is there an event in VBA that is triggered when a user changes the value in a cell - i.e. when the user hits enter. Cheers James
  11. James1981

    Embed HTML in XML

    Hi, I want to embed HTML within my XML document. Due to the tags, HTML causes the XML parser not to function... One way round this is to use the HTML entities instead (e.g. &lt;).. is there anyway to automatically convert HTML tags into their entities? Cheers James
  12. James1981

    src problems

    Hi, I have the following script setup: <script language=javascript src=myfile.js> myVar1 = &quot;test&quot;; </script> within myfile.js the script references myVar1, but when i run the script IE says it can't find the variable. Am I doing anything wrong, if so is there a work-a-round...
  13. James1981

    Problem with mail object

    Hi I'm using the mail object to send an email but am receiving am catching an error... I'm using the following code: try { SmtpMail.Send(newMail); } catch (Exception exError) { return exError.ToString(); } The code above is raising the following exception: Could not access...
  14. James1981

    Exporting stored procedures to txt files

    Hi, Is there any way to export all the stored procedures from my database? James
  15. James1981

    Problem with DataGrid.ItemCommand Method

    Hi, I have a button in my datagrid, and an event handler for it which calls a function.. Only the eventhandler never calls the function, (or possibly the eventhandler never captures the button being pressed). Has any body had any similar problems or can anyone see any problems with my code...
  16. James1981

    Problem with Data Formatting Expression in DataGrid

    Hi, I'm pulling a date from a SQL Server and putting it in a bound column of a DataGrid. I set the data formatting expression = {0:yy-MM-dd} but the date still displays in long form with Time included. Any body know why this is happening? James
  17. James1981

    Concatenating Problem

    Hi I'm trying to concatentate two varchar fields together in a query but it returns null always. Below is the code: SELECT source + ' (' + card_digits + ')' AS reference FROM myTable Any ideas? Thanks, James
  18. James1981

    Efficiency of Table, TableRow and TableCell

    Hi, I want to know if there is a drop in performance when creating a table and all it's child elements (rows, cells) at RunTime using the .net objects provided, compared to HTML tables and inserting data within them. James
  19. James1981

    Update top record only

    Hi, I want to update 1 record in a table based on a where clause that will return more than one record. I suppose it is similar to a SELECT TOP 1 field FROM table statement. Does anyone know if it is possible to use the TOP keyword or is there a more complicated way of doing it? Thanks James
  20. James1981

    Grouping records

    Hi, Is there a way in the group by clause to group records into max of three records? i.e. there may be more than 3 records belonging to that group in the query but I only want to see the top 3. James.

Part and Inventory Search

Back
Top