I Want to draw one line in two windows， when I move my mouse in one window， I draw one line from top to bottom。 There is another window at the bottom of this window，I also want to draw one line in this window， if I Sendmessage to do it， It looks like draw two lines。

I want to finish functions which can download music files from the internet, such as: I want to search the song named "yesterday once more", the I can get many links which can download this song. so it will be difficult for me to search the song and get the url of it. can anyone tell me how to accomplish this task?

they can read together,but the content which thread one reads can not be read by thread2. there will be many threads, just like client/server mode, but how can i control these threads in order to let them read different data from the same database.

I want to use multiThread to read and write database,but I do not how how to prevent the thread from reading db again and again, for example, I want use Thread1 to read record 1 - 100,and use Thread2 to read record 101-200,but I don`t know how to control different threads to read different data?

I want to read from DB using multiThread, but I do not konw how to prevent from reading data repeatly? I use vc++ to process this task, can anyone tell me how to realise it?

I have thousands of tables, and the fields are always ordered by date, and i want to select bottom 60 from all the tables. I know I can realize this function by following statement: select top 60 from table order by date desc but I don't want to use "order by", all my data is sorted and it will waste my time. so can I get the bottom 60 record from the db? Is there any function like "select bottom 60"?

ok，thank you for your help. I think I need to search other solutions, otherwise it will cost me too much time.

I tried following solution,but it still can not work. it can not import excel2.1 to sql server. select * into dbo.Temple FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 5.0;Database=D:\a.xls;HDR=YES', 'SELECT * FROM [a$]') do you have some c# code that can import excel2.1 to sql server2005 quickly? I google some code which was written by c++,but most of them can not read excel2.1, and some of them can read, but the speed is really slowly. the problemis that I have thousands of excel files,not only one. or do you have some solution that can save many excel2.1 files as later version? if i open it and save as it, it can be imported.

the version of the excel files which i want to import is Excel2.1, if I use the following solution to import, it can not work. for example: select * into dbo.Temple FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=D:\a.xls;HDR=YES', 'SELECT * FROM [a$]') The fact is that I have to open it and save it as the later version.Unfortunately,I have thousands of excel files so that I couldn`t open them one by one. Are there some solutions that I change their version quickly? or some solutions that can help me to import excel2.1 to sql server directly?

Thank Eddy Vluggen very much! I'll try it.

I know this solution, but I have several thousands excel Files, and their version are EXCEL2.1, I still do't know how to import so many excel2.1 files to sql server? I have such a solution,but I first need to save excel files to the latest version, and it only can import one file to sql server. for example: SELECT * INTO XLImport5 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=D:\tt.SZ.xls', 'SELECT * FROM [tt$]')

I need to import many excel files to sql server 2005, These excel files have the same fields and different values. for example: table1 a b c 1 2 3 4 5 6 table2 a b c 22 33 44 77 88 66 Because there are many similar files in one directory, I want to import all these files into sql server 2005, and build these tables automatically. I don`t know how to do it?