how to rotate images in cycle with link.
iam developing project to the musium.There various type of ancient type Categoriesare available. I have devided all in 6 Categories,so i like to rotate all Categoriesin cycle with picture.further more each Category has link that related to other information. Please give Ideas to begin project.
Does anyone know how to synchronize two databases (prefarebly mySQL) on different servers through C#?
What confuses me most is the comparing of the two databases. Note that the two databases can have the same data due to previous synchronizations. Also, the two databases can have different data but the same primary key.
I already worked with C# a while and I'd like to generate documentation. I've seen you can use '///' to add info in XML-style. So the XML can be parsed by using for example NDoc.
Is NDoc the best tool to use to generate C# Documentation? Any other software that I should use? (NDoc projet is not being update lately...)
I second NDoc, but as you have noticed they haven't released a binary for a while. Although there are currently working on a release for 2.0 framework features (like generics). I have a few c# 2.0 projects which could do with this.
Thanks for your time to read my request for a help. I developed my windows application with C#, which has many background workers working at the same time, opening and closing sql databases, modifying sql tables etc. Now, very often I get this error message, " There is already an open DataReader associated with this Command which must be closed first.". I dont know why its happenning sometimes and sometimes not. Is that the reason one thred and another thread conflicting each other when they try to read or modify same sql database ? And sometimes, I get some weired error saying "in order to execute the sqlcommand, connection must be open. ", And I dont see any reason why connection is getting closed before that sqlcommand execution. Now I had to place if(myConn.State == ConnectionState.Close) myConn.Open() ; before every sqlcommand. Even after that I am getting same error sometimes. Can anyone please give me some clue to solve and seal this problem permanently.
You can have any number of connections open to the database, so that is not the problem. The problem is most likely how you use the connection objects in your code. You can't share connetions between threads.
Thanks for your reply. Actually I am using same instance of sqlconnection all over my code because, when I used different instance of sqlconnection, I face another problem. If One connection made a change in the database, another connection doesn't reflect the change. It still retrieive old values from SQL unless that connection itself did not do the changes in SQL. Is there any way to synchronize all changes made by different sql connection instances ?
Hello eyad al akhras ,
Thanks a lot for the reply.
Actually in one of my thread, I have a dataGrid bounded with a daasource, so, my application is considering that databounded datagrid as an open active datareader. And at the same time another thread is executing SQL command. And sometimes, When another thread is executing SQL command, when I try to click Update (or SAve) button of a databinding navigator (for my datagridview) I get the same error saying "already datareader open.". Is there any snippet available to solve this problem either using mutext or something else. I have never used lock, mutex etc in my code, I dont know how to use those.