Hi , I am trying to read an MS Excel file in my C# class. But problem is its not showing me the column values. I have checked in actual excel file , those columns do contain values but due to some reason my code is not reading it. here is what i m doing : Code Blockstring filename = "xmp.xls;"; strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source= " + filename + "Extended Properties=Excel 8.0;"; OleDbConnection ObjConn = new OleDbConnection(strConn); ObjConn.Open(); object[] objArrRestrict; objArrRestrict = new object[] {null, null, null, "TABLE"}; DataTable schemaTbl; schemaTbl = ObjConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,objArrRestrict); Hashtable ht = new Hashtable(); int index = 0; foreach (DataRow row in schemaTbl.Rows) { ht.Add( index, row["TABLEX] ); index++; } string sheetName = (string)ht[0]; OleDbCommand ObjCmd = new OleDbCommand( "SELECT * FROM [" + sheetName + "]", ObjConn); OleDbDataAdapter objDA = new OleDbDataAdapter(); objDA.SelectCommand = ObjCmd; objDA.Fill(recordsDT); ObjConn.Close(); DataRow rowx= recordsDT.Rows[14]; // and now if i try to read value of 6th column rowx[5].ToString(); // gives empty string rowx["6th Col"].ToString(); // it returns me empty string and actually this column do contain value and similary i can't get values of col 7,8 but I do get the values of Col 1-5 and after Col 9. But if I try to same column values of row 1,2 it works fine. It starts to get funny after row no 7. ( each row contains 80 coumns) Thanks ZINK

Thanks Giorgi -- modified at 15:34 Saturday 23rd June, 2007

Hi , I want to add a new user account to windows using C#, its a stand alone pc , not on domain , no AD. I found some examples on internet , which uses "Netapi32.dll" , and its not working for me. I cant seem to get error code that why its failing !!! Is there any .NET API to add user ? Or any working example of using Netapi32.dll API ? Thankz ZINK

HI Shy , Thanks for your reply. Yeh I have socket application runing on client and server. And I want that when client want to access data on cd on Server's CD Drive , server reads that data and send to client . But not sure how to do this ??? Regards, ZINK

Hi , Shy Thanx for your reply. Actually I dont want to get just the Devices name , but the actual device when u share your CD rom drive on netwrok , any one on netwrok can use ur drive and access th CD data in that CD rom drive. So I want something like that . Any sugestions ? Thanks ZINK

Hi , I want to access remote machines hardware , like CD-ROM Drive , WebCam etc. But I am not sure where to look and frm where to start. So can any one plz guide me to right direction ? I am using sockets to access remote machine , so I am assuming streams are only way to get these hardware resourses , but how ? Need help , thanks. ZINK

Hi , I am having a problem runing .NET remoting when I use IPC channel , if I use same code and change channel to TCP in my configuration file then it runs fine, And my problem is under IPC channel , i cant connect simultaneously my two clients to remoting server , but if I change channel to TCP , it works fine with 2 or more channels ? Can I user ports with IPC chanle for my multiple clients ? Thanks, ZINK

Hi , I have a windows service qith my class X, now is it possible to make a mehtod call with parameters to that service ? what I have found on net is that u have to use 'OnCustomCommand' but I want to call a method with parametrs from my service controlling application ... Is it possible to do ??? And is it possible to fire events from class X (my windows service class) and i would be able to capture these events within my service controlling application ??? Thanks Thanks ZINK

Thanks , But I am using Sockets and dont want to use Remoting. So what If I put my assembly in GAC and App A and App B access it from there ? would not it be shared among these 2 applications ? and If I put singlton patteren on Class X to create only object then shoudl't App A and App B get same object ? OR even if u put assembly in GAC , everny App creates its own instance of assembly ? Thanks

Hi , I have question about .NET assemblies , say I have a Assembly 'X' and that conatins class 'xx' and my two different seperate applications uses this assembly , say Appl'A' and App'B' . Then is it possible that I could share the object of class 'xx' in two applications ? Like App'A' initiate object of class 'xx' and later on when App'B' comes, somehow I could tell that application that object of class 'xx' is already created and use that same object which App'A' has created. Is it possible to do ? I will really apprecaite if you could help me out here Thanks, ZINK ZINK

Hi , I have written an assembly in C# which uses threads, and I want to add the reference of this assembly in both Windows Form and ASP.NET Web Form. There is a method in a thread of my assembly which should send the current status of processing to Windows Form and Web Form . My problem is, I first used the 'invoke and delegates' mechanism from my assembly to update WindowForm control , but this technique did't work on WebForm control as I could't find any equiavalent of 'Invoke' in WebForm . Now I tried to use the Delegates and Events , I fire events from my assembly and try to catch those events in my WIndow Form , but getting error that "cross-thread operation is not valid" as I am trying to update GUI control frm my own thread.... Is there any way around to this ? I want to use technique through which I can update my both Win Form and Web Form controls ! Please I need help I m realy very badly struck here... Thanks in advance. ZINK

HELLO

Hi, I want to serialize my class object to XML and send through AsynChronous socket. I looked on net and I found an exmaple, it uses FileStreamwriter class to write serialized object to file. I want to use netwrokStream to send to this object to Socket . But in socket's BeginSend() method there is no way to send netwrokstream ... ? there is byte array argument in this method ... Do I need to convert stream class to byet array and send to this to byte[] in BeginSend() method ??? If it so then is there any example to convert to byte[] ??? Thanks, ZINK

Like If I have DataGrid on web page , I want to add or remove the enteries of that data grid from my class library ... Is it possible to do ? and if if yes then how.. ???

Hi , I want to update controls on web page from my C# class library. I am using this same library for my desktop GUI application and I solved this same problem by creating delegates and using Invoke() mechanism in my Form class. But could't find any equivalent for Web Page controls. is there any way around to update my web page control like textBox from my Class library ? ( I dont want to write that class in my CodeBehind class ) Thanks in Advance, ZINK

C#

I am using Asynchronous methods in my extern class and trying to update UI from these methods . I have created a delegate and delegate method in Form1 class and when I tried to invoke delegate from external class it says definition of invoke does't exist in current reference ... ??? What I m doing wrong here ? Thanks

I have control Lable on Form , I wanted to update text propertrty of that control from another class in same namepsace so I expose that label control visa public property . and now I m using that property in my other class for setting text fro that lable .. but the new text is not displaying on Form ??? What I am doing wrong here ??? Class Form1 { public string updatelable { get { return label.text ; } set { label.Text = (string)value; } and using it in my other class as Form1 f = new Form1(); f.updatelable = "abc"; but its not working... what I m doing wrong here ??? Thanks

HELLO

???

HELLO

HI , Is there some wayaround to update Form's control from Class Library ? I have a classlibrary as a seprate project and GUI (Form) as a separate project in same solution. And have aded reference of Class Libaray to my GUI project from where I access its functionality. Now I want that when ever any particualr event happen in ClassLibrary (new data is aded from database or some exception caught)I write this to my LogFile but also WANT TO DISPLAY ON LABEL on Form.. , how can I acheive this thing ? Any sugestions ??? And If i have ran an application from Visual Studio by clicking 'play button' , while that application is runing , that play button stays disable .. what if I want to run one more instance of that application from Visual studio ??? Thanks in advance. zink

Yeh I know that , but my question was which technique I shd use ? and why ? because I have seen some exampls of client-server written using Asynch methods and it looks very easy n good , but not sure how much stable and efficent it is ... So please any one who knos the diff between these 3 techniques and reason... ?

HELLO

Hi , I am developing a Client-Server application , I have done some research and found there are three ways to handle multiple client requests. 1. To use old style multithreaded server 2. To use .NET threadPoll worker threads 3. Asynchronous Socket programing But I am confused that which appproch I shld go.... ? :confused: My clients will run and provide all local info to main application ( Server ) so its the clients who actually will provide info to server/the Main Monitoring application(server) . Any guidence please to which approch I shd go ? Clients will be less than 50 ... and the Info they will provide on based on Events generated by Server. Thanks in advance. ZINK -- modified at 8:46 Saturday 3rd March, 2007

HELLO