Are you trying to filter records ?

kss

Add the Following to the beginning of your Applications Main() # region For UnInstaller string[] arguments = Environment.GetCommandLineArgs(); foreach (string argument in arguments) { if (argument.Split('=')[0].ToLower() == "/u") { string guid = argument.Split('=')[1]; string path = Environment.GetFolderPath(Environment.SpecialFolder.System); ProcessStartInfo si = new ProcessStartInfo(path + "\\msiexec.exe", "/x " + guid); Process.Start(si); Application.Exit(); Environment.Exit(0); } } # endregion Go to the Installer project and add a shortcut to the Primary output and rename it to Uninstall <Application Name> Go to the Properties of the newly added shortcut and Set the Arguments property to "/u=[ProductCode]" Place the shortcut in the user's programs menu. Create a build and your application is ready with Uninstaller. thanks

kss

Check this[^] Hope it helps

kss

this will do.... for (intCounter = 1; intCounter;= 50000; intCounter++) { lblShowCount.Text = intCounter.ToString(); **Application.DoEvents();** oEmployee.AddRecord(); }

KSS

Hi, I have a Datatable which has a couple of Columns with "Expression" property set. I have set that Datatable as a DataSource to a DataGridview. Now when I am trying to set a value into one of the column for all the Rows in a loop, it is not calulating the values as set in "Expression" on a single row. if there are 10 rows then for 9 rows it shows correct value but 1 row it doesn't calulate at all I checked the loop index but everything is fine. I am also doing some custom calculations on the "CellValueChangedEvent". Is this because of the event handled separately ?? Can anyone help me on this ? please thanks in advance

KSS

modified on Wednesday, March 12, 2008 11:10 AM

SJSaranya wrote:

populate checkbox in gridview to delete records.

Add a column to the datatable, which you want to assign as a data source to the gridview like the following dataTable1.Columns.Add("Name of My Column for the checkbox",typeof(bool),"0"); assign it as datasource.

kss

Hi, Thanks for the reply but i was looking for another handler for the rollback part. Like : Declare Exit handler for SQLEXCEPTION ROLLBACK; I want my proc to roll back in case of any error. because once i find any error it will throw an exception to my application which can never rollback-ed thanks Siva

kss

Hi I am using a MySql 5.0 DB. am trying to implement a transaction inside a stored procedure which uses cursors. but the problem is the way the cursor closes it self. it throws an exception, i have written a handler for any sqlexception inside the procedure which simply rolls back, and because of the cursor , transaction gets rolled back without completing the task. Has anybody ever worked on MySql with transactions. Please Help. thanks

KSS

Dave Kreskowiak wrote:

Basically, you've got a HUGE problem to fix, but no time to do it. I think it's time to tell management to face reality, because you're going to need more time to redesign your applications data layer. I'd tell them after you read this stuff and show them a plan of attack on the problem, 'cause there is no "quick fix" for this.

Thank you very much Dave. Yes there is no immediate solution to this problem. and i will go through the links. i will let you know once i am done with the links thanks again

KSS

Hi All, I am working on a C# windows application which uses a MySql db as back-end. it is a huge solution with 100 forms. Everything was fine until last week When I was told, " there is a chance this application will be used my multiple users and same forms can be opened simultaneously(from different machines)". so My application was not designed in such a manner that it can handle multiple user access same data and modify it at the same time. For ex: if one user creates/edits/deletes a record then the other user can not know that a record is created/edited/deleted on the same form. I thought of using remoting. A windows service on the DB server will have the "users + forms opened" list. As the user logs in and tries to open a form, my application will connect to service and check for, if that form is already opened by some one else. if true, then it will open form in a lock mode. But the problem is, if some one opens the form in lock mode and then the form should be notified once it is unlocked. How should i implement this? I read few articles on Remoting and invoking events but everybody says that it is not a suitable way. What can be other ways please suggest ? Added to this now i came to know that the application will be run on a terminal server :doh:. I tested it on terminal server to see if there are any issue, I found, when my application if run by multiple users can't write to the config file. Only the user who installed it can write into the config file. I thought it is a permission issue which can be resolved. Then i read few posts stating .Net application performance degrades when run on a terminal server. in the sense that Memory consumption is too high. Well i have not tested it for sure. but Will there be any problem with the Remotng part if both the service and my application run on the same terminal server ? Will there be any performance issue ?:confused: I am worried because my application is already using 100 mb of memory. I have very little time left please help Thanks

KSS

Well I Have never worked on Remoting and if this will help me then i Would not mind Working. I will look into this , if you have any good links of this kind of implementation then can please let me know, it will be of great help Thanks again

kss

Can MessageQueue be used in this Context ?

kss

Thanks but I using MySQL 5.0.

kss

Hi, Thanks for the reply, I think , what i have written earlier is a little confusing. I am using MySql provider. and there is no problem with MySql provider. But what i want is: for eaxmple: if Two users "Chris" and "Sally" open the same form. suppose Chris Modifies the record no.13 and the record is updated to database but Sally's screen still shows the Old data. I can refresh the whole screen by re-fetching the data from the DB but is time consuming. but i want some other solution may be an network event kind, whenever change occurs in other machine. it(machine) sends a message kind to all the peers(who have the same form opened). so that i can manage it on the frontend itself. as the data is huge so it is not possible for me to refresh again and again. How far this is possible ? thanks again

kss

Hi, I am bulding a simple windows application. the forms read data from the database and show it. the user can modify the data through the forms and the data is updated. it works fine as long as it is used by single user on a single machine. But I want this to be used by different users on the network. There may be an instance where two or more users can open the same form. So any changes made to a record by one user can not be reflected on the other end :(. but i want changes to be reflected on all machines where the same form is opened. How can i achieve this :confused: ? Please suggest me a way ? thanks in advance

kss

Hi, I am bulding a Windows application through C# and I want to integrate that with ActiveDirectory(AD), also i want users(not part of AD) to login into my application. that i have done with a simple .mdb. but i want my AD users to simply double Click my Application and get started. How can i do this in C#? I mean how can i authenticate those users(I can not ask them for password). Also, I have alredy added some 40 around forms. and i want those forms to be launched if the user is of a specific type(for ex: Admin,Site Admin,General User.. etc). How can i put the minimum amount of code within these froms so that i need not change the whole code.:confused: Please advice. Thanks In Advance

kss

Are you disposing the connection object and DataAdapter object as well?

No i am not disposing them , as they are dragged on to a component. and from that Adapter ->Right Click ->Generate Dataset.then i refer that dataset from my UI project.

What happens when you open and dispose a bunch of datasets, does the memory size of the exe keep going up?

No the size of the Exe remains the same.

how vital enterprise application are for proactive organizations
leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that
focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the
bottom-line. But of course, that's all a "high level" overview of things
--thedailywtf 3/21/06

This really is cool but High Level also... :-D Thanks for the answer.

KSS

Hi All, I am generating a set of datasets from few DataAdapters, and those generated datasets are referred in another project space as referenced dataset. When i say DataAdapter.Fill(datasetX, "tbl"); it does the task for me. The Memory size of the Exe in the runtime grows from 10mb to 20mb,but once i close the form the size never comes down. Even if i say datasetX.Dispose(); System.GC.Collect(); And i was thinking of using 20 to 30 such datasets but will it not increase the size of my application ? How can I bring down the runtime memory consumption ? How can I Dispose the Dataset ? Please help with this. Thanks in advance

KSS

Hai Shylaja, I have been looking for similar solution but on different grounds, and also posted a Question on to the forum and found no answer.:(( I need to Communicate to a website on HTTPS and supply some login information and Emulate the Login Button click on the Server it self. i was able to achive it on the local machine but on the remote it says Authentication failed.:doh: Any ways ... All i can suggest you to look into HTTPWebRequest and HTTPWebResponse classes and do some research and you might get it done. there are few good articles on CodeProject like "How to use HTTPWebRequest and HTTPWebResponse". search for this you will find it i Hope this will serve the purpose....:) Regards, _K_SS

Thanks a lot, i got it resolvesd, actually the RecvThread was sending to a sockaddr_in that was with in the sender thread and that SendThread was killed by the time it got the mrssage. any ways thanks KSS