Before we started the project we checked and found strong typed datasets the most fitting solution, Though some people strongly advised against it. I works fine in a different area of my project (With mysql), So I don't know why people dislike it so much, But I have little experience with databases so I guess you have your reasons. Anyway, For my specific problem I will do as you suggested and further my research in to the DALs. Thank you very much you really helped me.
Sincerely yours Y.R.
Hi, Thanks for your reply. I ran the sql query: DELETE FROM table1 WHERE id = 1 on both access and ms sql and it worked fine. But I don't create the queries manually, It is created by the adapter (I think) of my strong typed database ( so I don't know whats really going there). Is there a way I can view the query created by it?
Sincerely yours Y.R.
Hi, I have a c# (.Net 2) program that connects to access mdb file. I use strong typed dataset to do this. Now I have searched the web and found ms sql connection string I replaced what was generated by the wizard with the new one and now I can successfully connect to MS SQL server (with the same table). The problem starts when I try to delete rows from the table. In access it works great obviously, But with MS SQL I get exception when calling udpate (Wrong syntax near '.'). Is it possible at all to use strong typed datasets to connect to both MS SQL and ACESS. If yes how? Thanks, Yaniv
Hi, I am new in the field of databases. I am trying to create a strong typed dataset (using vs 2005 add data set wizard). The table in my data base include foreign keys (relations). When the wizard finishes the dataset is created with all the necessary tables and fields, EXCEPT for data relations. When I am performing the same thing with access data base the relations are loaded well. Does anyone have an idea of what it could be.
Sincerely yours Y.R.
I thought that this is the only way. It strange that such a powerful language don't have this simple features. Thanks for your help.
Sincerely yours Y.R.
Whats wrong with overriding OnMouseXXX events? There is a nice mechanism called Hooks (Hooks Chain). You can use it to catch mouse, keyboard and probably a few more things. http://msdn2.microsoft.com/en-us/library/ms644959.aspx[^] Good luck
Sincerely yours Y.R.
Thanks for your reply. I thought of that but there are two problems: First, I don't think there is an easy way to make array a contant (except for basic types arrays). Second, my bits values are not 1, 2, 3, 4... (which would fit to an array). They are 1, 2, 4, 8, ... (Which requires some logic to be implemented in an array). I thought of constant dictionary but I don't think there is a way to make the dictionary constant or readonly.
Sincerely yours Y.R.
Greetings, Mostly I use enumerations to specify a list of constants that are connected. However, recently I needed to create a code that does the following: Paint a line with a specific color that is set by the value of the bits in a variable. The bits values are arranged in enumeration: enum bits { Switch1 = 1, Switch2 = 2, Switch3 = 4, switch4 = 8, } What is the best way to assign a color to each switch? I thought of two ways: --------------------------------------------- creating a dictionary and set its values in runtime: Dictionary Bits_Colors = new Dictionary; Bits_Colors.Add(switch1, Color.Red); Bits_Colors.Add(switch2, Color.Ivory); .. But this solution because the dictionary is not constant and readonly would not help here. ------------------------------------------------- Creating another enumeration for the colors and using thier names as params to Color. enum BitsColors { Red = 1, Ivory = 2. Blue = 4, Green = 8 } string name = Enum.GetNames(bits, (int) switch2 ); // name = Ivory. Color c = Color.MakeByName(name); ----------------------------------------------------------- I wrote the code from my memory so it might be a little not working.
Sincerely yours Y.R.
I guess you are using MFC.... Where I have written CTab I should have written CTab... (I didnt checked the full name). Anyway after a little check in the msdn site I found this page http://msdn2.microsoft.com/en-us/library/hfshke78(VS.80).aspx It contains info about the CTabCtrl. Though the site is good I prefer the help in the program(VS) (just write CTabCtrl in the index). If you still having troubles try to search for CTabCtrl in CodeProject they have a lot of usefull articles. Hope I helped.
Sincerely yours Y.R.
Hi, If I understands correct what you are seeking is a way to create a Tab whitout a dialog. You can just put a tab control in your View class and than create that control with its Create method. Just check the MSDN for the tab control (CTab). They have really good explanations. If you still having trobules tell me and I will try to find a program that will help you.
Sincerely yours Y.R.
I have one cpu and one internet connection (750 k). But it should not matter because when one is downloading file from a server that is slow multiple http connections to this server will raise the overall speed like many existing download accelators(e.g. Get Right, DAP, etc..) I think the problem is in my multithreading part. Sincerely yours Y.R.
Hello, I am trying to build a download accelarator (a program which downloads a file through several connections to increase the speed). I have created four threads. Each thread downloads the file from diffrent offset and finallly I join al this parts. The problem is that when I use one thread( without changing the thread's code) it much faster. It like the additional threads are slowing one another. In each thread I initialize the connection (CInternetSession->CHttpSession) and later in the thread I have put a loop which downloads the files. The initialization part is in a critical section. Can anyone tell whats wrong. Did anyone encountered similar problem? Sincerely yours Y.R.
Hello, I am trying to build a download accelarator (a program which downloads a file through several connections to increase the speed). I have created four threads. Each thread downloads the file from diffrent offset and finallly I join al this parts. The problem is that when I use one thread( without changing the thread's code) it much faster. It like the additional threads are slowing one another. In each thread I initialize the connection (CInternetSession->CHttpSession) and later in the thread I have put a loop which downloads the files. The initialization part is in a critical section. Can anyone tell whats wrong. Did anyone encountered similar problem? Sincerely yours Y.R.
Thank you very much. After posting this message I searched in code project and indeed got to your article "Enumerate Installed Devices Using Setup API[^]". I loved it very much very intresting. I will read the second one now. Regards Y.R.
Hello, Can anyone know how can I query windows for its devices. What I mean is that my program needs to know which modems are installed on the pc and thier ports, etc.. The windows device manager is a good example, I want to know how to get data the device manager displays. Thanks Y.R.
Thank you for your replay but I have seen this previously and I want somthing for general (for hard drives too). Sincerely yours Y.R.
Hi all I have searched for a way to read a specified sector from a drive and found nothing can someone know how can I read a sector or know about a mosule I can use. Tanks Regards Y.R.