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
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...
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
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...
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
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...
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
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
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...
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 =...
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.
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
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.