Thnk u very much... With Best Regards, Mayur

Okay. I think I got it now. I tested this out and it seems to work, hopefully it will for you too: SELECT MAX(A, B, C, D) FROM myTable This will return the largest value for each record. Then you won't have to worry about doing it in code. As to why your array code wasn't working. I believe that when you declare your array as myIntArray(24) it doesn't create an array with elements of index 0 through 23. It really creates an array of elements 0 through 24. This means that you are not setting that last one, and perhaps it is defaulting to zero. Which would explain that after you sort it, the 0th element is always zero.

You have badly designed the database, and there is no easy way to aggregate this data. Maybe you could explain what you are trying to achieve, and somebody could make some suggestions on how to go about it better. Current blacklist svmilky - Extremely rude | FeRtoll - Rude personal emails | ironstrike1 - Rude & Obnoxious behaviour

it was a simple search at google, 1. open a new web page 2. write "www.google.com" to address bar 3. Click "Go" button (it is at right) 4. Then softly click to first result of returned by google. 5. You see "http://www.codeproject.com/csharp/export2excel.asp[^]"

If I understand your question correctly you want to group the same name records together even if the spelling of the name is different and then find the highest salary record from that group. First convert the name field to lower case. Then you will have to define a set of characters the can be savely removed from the name field. In that set you could include dash (-), quote ('), and space ( ). For each name remove those characters. This will attempt to convert similiar names to the same name. The way to find the highest salary kind of depends on how the data is stored. If it is in a datatable you can query records returning the highest value in the salary field. Or sort the records by salary in desc order putting the highest value in row 0. Or you can process the records one by one in a for next loop to find the highest salary. I hope this helps!

It Will be! You need to use the import wizard in excel and select the cell type to be text. If you load the file then try changing the column to text it will not do anything, as the leading zero's have already been taken out.

I take it that you're loading 1 Million records? You're MUCH better off leaving the data in the database and just running the queries against that. The .NET Framework objects are not designed to handle that much data and are not nearly as efficient at searching through it as the database engine is. The traffic you send and, more importantly, receive to/from the SQL Server (or whatever) will be FAR less than retrieving that mountain of records. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Try Instantiating the Datatable on the main thread before you start the second thread: Dim dt As New DataTable("dt") Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim thrFillTable As New Threading.Thread(AddressOf FillTable) thrFillTable.Start() End Sub Private Sub FillTable() Dim c1 As New DataColumn("Number") dt.Columns.Add(c1) Dim dr As DataRow For i As Integer = 0 To 10 dr = dt.NewRow dr.Item(0) = i.ToString dt.Rows.Add(dr) 'Next line is just to waste time 'so you will see combo has no data 'till thread Is finished Threading.Thread.Sleep(2000) Next Me.ComboBox1.DataSource = dt Me.ComboBox1.DisplayMember = "Number" End Sub

This site has many articles about this subject. Don't be lazy and do a search. Q:What does the derived class in C# tell to it's parent? A:All your base are belong to us!

mayhem_rules wrote: How do I export data to EXCEL or CSV or TSV Depends in which format the data is currently. From Microsoft SQL Server (Query Analyzer) you can run a query against the MSSQL database and export the results directly to CSV. Other database engine management tools also offer this feature. Also, I believe that Excel can hook into MS SQL Server directly - and possibly other databases with an ODBC connector. (You'll need to look that up in the Excel help.) If the data is in a proprietary or other file format (i.e. non-database), you may need a simple program to extract the data and write a flat file (which is what a CSV really is anyway) into the format outlined in previous posts. This is easily done with VB (look up the file handling functions). ...Steve "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." (Translation: I'll show you the way, but not write the code for you.) I read that somewhere once :-)

Thnx a lot. I will be waiting for your reply regarding 'Database updation from datatable". Right now I am facing a lot of problem using the traditional method of updating each record since the operation involves huge data. Once again thx for your help. Have a nice day. With Best Regards, Mayur

When you use a DataSet, or DataTable, with a DataAdapter object, you supply the DataAdapter with the SELECT statement to fill the DataSet. Your user makes any required changes to the data, then tells your app to update the database. This is where I think you're duplicating the functionality of the DataAdapter. The DataAdapter also needs the appropriate SQL commands for UPDATE, INSERT, and DELETE operations on the data it retrieved using the SELECT command. When the dirty data is written back to the database, the DataAdapter looks at each recond in the DataSet/DataTable and, using a flag attached to each record, decides which of those SQL commands to execute for that record, if any. You may be doing the same thing, or something similar. But, in any case, you're probably duplicating the functionality of the DataAdapter. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Sounds to me that you want the database to reside in one location as it should. Your application needs to point to that database. Meaning that the connection string needs to point to that location. Use your app config/reg entry/xml doc what ever to specify where the database is located.

Can you give me some more input on not having Excel loading on the target machine. Below is a link to a question I had, the feedback I'm getting is you need to have Excel loaded. Can you give me more feedback on not having Excel loaded? http://www.codeproject.com/script/comments/forums.asp?msg=1396040&forumid=1646&mode=all&userid=387911#xx1396040xx[^] Lost in the vast sea of .NET

Hey guys, I have found the solution, I guess. Please refer to the link below. http://www.c-sharpcorner.com/Code/2004/March/DataSetsIn.NETP2.asp[^] Ofcourse, i have the same query as shiroamachi. how do you insert or update data into a datatable and finally update the database with the datatable. if anyone has any idea regarding this, plz let us know. With Best Regards, Mayur -- modified at 4:07 Wednesday 15th February, 2006

Access doesn't support true stored procedures, so you'll have to write more efficiently in single SELECT statements. Access only supports single statement queries. Doing it in code the way you are now is just so inefficient it's not funny. You're not using the power of the database at all. Like I said, you'll haev to rewrite this so you're code is not going through the same records time and time again "looking" for a record that matches a certain criteria. This is one MAJOR spot where your code is bogging down. Rewrite just this little search as a SELECT statement and you should see a huge imporovement. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Thnx for your reply. I guess you did not understand my requirement. I need to get the address of each employee and insert the info into another table. EMP2000 contains only the emp code,name and period. EMPADDR contains emp code,addr and period. I need to link these and insert each employee record in EMPDATA. With Best Regards, Mayur