Search results for query: *

  1. F

    Integrating file extensions into Windows

    The normal way would be to add an entry in control Panel-> Folder options -> File Types. Is this what you are after or are you looking for a way to do this in code? g
  2. F

    Playing two sounds at once

    Hi It is possible to play two wav files at once but not through the same instance of the application (to test open up two wav players and play). I'm not sure of the best way of doing this but i would sugest creating a seperat thread for the background music. E.G. Private Sub...
  3. F

    Formatting and Integer

    There isn't in 1.1/2003 and it seams unlikly that there are in 2.0/2005.
  4. F

    SELECT Queries with Multiple Tables

    yep it's key word conflict try []'ing open and close.
  5. F

    SELECT Queries with Multiple Tables

    hi the code you're trying to run the select date needs an associated table eg. SELECT Table1.date, Table1.close AS prod1, Table2.close AS prod2 FROM Table1, Table2 WHERE Table1.date = Table2.date if thats not the problem could you send the error message. g
  6. F

    Joining of 3 tables

    yeah been a bad day i was thinking that he was only sellecting from table1 so in your example using DISTINCT would only return one line and in mine it would return 3 (t1,t2,t3) but as thats not the case the way they are linked only really effects the WHERE cluse depending which table STAFFNAME...
  7. F

    Joining of 3 tables

    Yes sorry i've mentally changed the query to SELECT table1.* ... but he should check that the tables are in the right order any way. g
  8. F

    datagrid sorting help?

    Try adding bound columns to the datagrid ether using the rClick -> property builder ... or adding: <asp:BoundColumn DataField="ColumnName" HeaderText="Column Name"> </asp:BoundColumn> for each column you wish to show. If you already have this you may wish to check the stored proc. g
  9. F

    Joining of 3 tables

    Agreed more onformation is required. but if DISTINCT had no effect (Ok not best solution for whole line removal but works:D) then the another option for extra rows is as follows: example: table 1 contains id "1" three times table 2 contains it twice and table 3 contains it once lets assume...
  10. F

    Joining of 3 tables

    Ok what is the result you are expecting? I'm assuming from the query that you you are looking for a case where table1.id = table3.id (if it exists in table2.id)? g
  11. F

    Joining of 3 tables

    If the extra lines are duplicats of rows in table1 then adding DISTINCT between the select and *. If the rows are unexpcted rows in table try adding a where cluse in to remove them. are the tableN.id columns primary keys? g
  12. F

    Select a cell in Datagridview to display details in combo boxes and textbox

    Hi this is what i would use in 2003 SELECT [table1].* FROM [table1] INNER JOIN [table2] ON [table1].1_ANID = [table2].2_ANID WHERE ([table2].Name = @Name) AND ([table1].IntYear = DATEPART(year, GETDATE()) OR [table1].IntYear = DATEPART(year, GETDATE()) -1) ORDER BY [table1].IntYear DESC...
  13. F

    How to close the windows application through the windows service

    I'm not 100% sure what you mean by showing the user interface through the coding. If you wanted to edit settings (If there normally in the popup menu etc...) in the example.exe you could use the args section of the start. dim args as String = {arg1,arg2,etc} Process =...
  14. F

    How to release objects and classes

    The freeing of Objects is done automaticly by the CLR Garbage Collector, so the the code above is fine. It is possible to force the GC if you wish, using the finalize intrenal sub.
  15. F

    how i can make my program in startup

    http://www.chami.com/tips/delphi/112796D.html this help?
  16. F

    How to close the windows application through the windows service

    try something like this Dim mProccess As New System.Diagnostics.Process mProccess = System.Diagnostics.Process.Start("example.exe") ... mProccess.Kill() I'm not sure how safe that will be but if the exe isn't doing to much it should be fine. g
  17. F

    SQL DB Retrieve then Update

    Quick thought are you using page.IsPostBack to chatch the submit anywhere. if not the page is likly writing over the contence of the text boxes before writing to the database.
  18. F

    formatting time in a datagrid

    try using: (MM/dd/yyyy hh:mm:ss tt)
Back
Top