What error? Is it a socket error? Or does the service not start? Did you call GetLastError to get the error code? John

One of these links may help: http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=be6819e9-66a0-4524-abf9-09d5ff99e88c[^] http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=d10f0003-37ef-4427-9a85-74db5ceb547a[^]

This reads it into a DataTable public void CreateXLSDataTable( String fileName ) { //DataTable tb = new DataTable("XLS"); dtXLS = new DataTable(); Excel.Application ExcelObj = null; ExcelObj = new Excel.Application(); if ( ExcelObj != null ) { Excel.Workbook empBook = ExcelObj.Workbooks.Open(fileName,0,true,5,"","",true, Excel.XlPlatform.xlWindows,"\t",false,false,0,true); Excel.Sheets empSheets = empBook.Worksheets; Excel.Worksheet empSheet = (Excel.Worksheet)empSheets.get_Item(1); bool lineValid = true; int iCount = 1; while ( lineValid ) { iCount++; Excel.Range range = empSheet.get_Range("A"+iCount.ToString(), "X"+iCount.ToString()); System.Array myvalues = (System.Array)range.Cells.Value; string[] strArray = ConvertToStringArray(myvalues); if(strArray[0].Equals("") ) { lineValid = false; continue; } if( iCount != 2 ) { object[] objArray = strArray; dtXLS.Rows.Add(objArray); } else { for(int i=0; i< strArray.Length; i++) { dtXLS.Columns.Add(strArray[i]); } } } } else { Trace.WriteLine("Excel reading Error: could not load the excel file object"); } ExcelObj.Quit(); ExcelObj = null; } private string[] ConvertToStringArray(System.Array values) { string[] theArray = new string[values.Length]; for(int i=1; i<=values.Length; i++ ) { if( values.GetValue(1,i) == null ) theArray[i-1] = ""; else theArray[i-1] = (string)values.GetValue(1,i).ToString().Trim(); } return theArray; } public DataTable XLS { get { return dtXLS; } }

Hi, I use VB.6 and I want get all directories and files in CD ROM but I don't want scan all content of CD ROM. Please help me. Thanks. H.Dung

Hi, Thank you very much. I have been used the ArrayList class in System.Collections namespace, and I have everything which I need. H.Dung.

SELECT name FROM master..sysdatabases

Array.Clear()? leppie::AllocCPArticle(Generic DFA State Machine for .NET);

Thanks for your suggest very much. Now I can run my app in win98. H.Dung

Hi, Thanks you very much. H.Dung

Hoang Dung, the following is not the best code on the globe but hope it gives you some ideas. // construct table for Tasks grid and define columns m_dtTasks = new DataTable("Tasks"); m_dtTasks.Columns.Add("Task Name", typeof(string)); m_dtTasks.Columns.Add("Frame Maker Location", typeof(string)); m_dtTasks.Columns.Add("Approved", typeof(string)); m_dtTasks.Columns.Add("Approval Cycle", typeof(string)); OleDbCommand cmd = new OleDbCommand(sSelectQuery, conn); // have yr query & connection ready OleDbDataReader reader = cmd.ExecuteReader(); // DataReader is now loaded with data while(reader.Read()) { nNumRowsAffected++; Console.WriteLine("TaskName = " + reader.GetString(0)); sTaskName = reader.GetString(0); // TaskName sFrameMakerLoc = reader.GetString(3); // FrameMakerLocation sApproved = (reader.GetBoolean(11) ? "Y" : "N"); // Status sApprovalCycle = reader.GetString(12); // Approval_Cycle // construct a new data row drTask = dtTasks.NewRow(); drTask["Task Name"] = sTaskName; drTask["Frame Maker Location"] = sFrameMakerLoc; drTask["Approved"] = sApproved; drTask["Approval Cycle"] = sApprovalCycle; // add new row to table dtTasks.Rows.Add(drTask); } dgdTask.DataSource = dtTasks; // attach data source to grid Hope it helps Khang Nguyen ;)

you can use a flexi grid in C# , just add it to the toolbox : VB: Private void button6_Click(Object sender, System.EventArgs e) { For (int i=0;i<20;i++) { axMSFlexGrid1.AddItem("item\t" + i,0); } } hope that helps.:) Private void ExpectingTwins(string twins) { switch(twins) { Case ("twins on the way"): MessageBox.Show("for mr and mrs dynamic","twins on the way"); break; } }

Thank you for your answer, but I want to convert a string to a class/struct because I write an application using Socket, Server module wrote in MFC 6.0 and client module I write in C#, data from Server send to Client are records which converted to string and pass throught metwork. Now, I want convert this data to struct/class after receive string data from server. Please help me. It very importance for me. Thanks.