|
Dear All,
I am using Visual Studio 2010 ultimate, C# language and MySql as backend database.
I've a Voucher Form, which is Master Detail. After user enters voucher data, he save the data in database by clicking save button. Now I need to add a post button, which when click perform a update to Voucher record and mark it as POSTED. This is not an issue as it simply required an Sql update statement.
What I need is a way, that after POSTED is marked, no one can edit the record, even when it is search by any user. What is the best way to do it? Are programmers do it by setting readonly property of controls true/false? Or there are other options available?
Any ideas/suggestions/samples much appreciated.
Best regards
Ahmed
|
|
|
|
|
ahmed_one wrote: What I need is a way, that after POSTED is marked, no one can edit the record, even when it is search by any user.
Can this be clarified a little please? There are a few different potential problems here. First off, what do you mean by "no one can edit the record"? The database admin is going to be able to edit the record, one way or another. If you mean users should not be able to edit the record, then you are in control of what they do in the application, so you must have enabled the ability to updated? I don't know why searching alters the record (as your comment seems to suggest) - this sounds like something is very wonky to me, or you don't mean database record. It might be better to expand on your question.
ahmed_one wrote: Are programmers do it by setting readonly property of controls true/false? Or there are other options available?
Yes, it is possible and normal to do this (normally a check-box). The other options depend on what you need so no-one can answer that for you, you might want to consult the people you are writing the software for.
|
|
|
|
|
Keith Barrow wrote: ahmed_one wrote: What I need is a way, that after POSTED is marked, no one can edit the record, even when it is search by any user.
Can this be clarified a little please? There are a few different potential problems here. First off, what do you mean by "no one can edit the record"? The database admin is going to be able to edit the record, one way or another. If you mean users should not be able to edit the record, then you are in control of what they do in the application, so you must have enabled the ability to updated? I don't know why searching alters the record (as your comment seems to suggest) - this sounds like something is very wonky to me, or you don't mean database record. It might be better to expand on your question.
By "No one can edit the record" I mean users. Database admin surely can alter the data. That's not a problem. At present, searching is not altering the record, my requirement is: when POSTED is marked users are restricted to Add/Edit/Delete/Update that POSTED record. This means when user use find function to display record (which is POSTED now) in Winforms, it should be locked for ADD/EDIT/DELETE/UPDATE.
|
|
|
|
|
It's been a long time since I've done any winforms, but in principal I'd:
- Extract the UI that allows viewing/adding/updating the record as a control.
- Set the control from above's enabled state to false - this will disable the control
- Show/hide buttons in the control as appropriate
Another option is to create two controls - one for add/edit the other for view only and display the relevant one. Depending on what you are doing, you can usually improve the user experience, though at the cost of extra work, so you need to balance these off with eachother.
|
|
|
|
|
Thanks for your reply,
Are there any option available via Sql, when user find the record, the find function should call a function which fetch data from MySql Db in read-only mode.
|
|
|
|
|
ahmed_one wrote: Are there any option available via Sql, when user find the record, the find function should call a function which fetch data from MySql Db in read-only mode.
If you only "SELECT" data it will always be readonly. Simply don't update the data.
No, MySQL has no magic functions.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Thanks....I will try this...
|
|
|
|
|
how do displayed word 360 view rotational
kumar
|
|
|
|
|
|
how to create continue rotational word
|
|
|
|
|
|
|
A standard textbox automatically rotates a word throught 360 degrees - it's just to fast for you to see, as rotating something 360 degrees brings it back to its start position!
=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================
|
|
|
|
|
Sadly you see the result only, not the process...
Well, judging from your signature, you might see the process too, even if it is not visible to the rest of us.
|
|
|
|
|
I need to send sms from my windows application i tried with many dl and gateway but ended in vain pls help me
|
|
|
|
|
Google has lots of samples and links, try some of them. But if you have a problem with your code, then please provide proper details and explanation.
Veni, vidi, abiit domum
|
|
|
|
|
{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang16393{\fonttbl{\f0\fnil\fcharset0 Calibri;}}
{\*\generator Riched20 6.3.9600}\viewkind4\uc1\pard\sa200\sl276\slmult1\f0\fs22\lang9\\hello \\\\ r u there \\\\\\\\ with your family \\\\\par
}
plz tell me how to detect text as : \hello\\ r u there \\\\ with your family from the given rtf file
|
|
|
|
|
Do some research, here is some google foo[^]
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
The simplest solution is to just use a RichTextBox: add your RTF string to it; and, read back its 'Text Property:
YourRichTextBox.Rtf = YourRTFString;
string YourPlainText = YourRichTextBox.Text; Or, you could use this:
private char[] cleanRTF = new char[] {'\\', ' ', '{', '}', '\r', '\n'};
string[] sAry = str.Split(cleanRTF, StringSplitOptions.RemoveEmptyEntries);But, then, you've got to do something with the resulting string[], like combining it back into a continuous string, in which case you will still have lots of the RTF formatting codes.
For more sophisticated "cleaning" you should consider using a RegEx; but even that is not easy, as you can read about here: [^].
“But I don't want to go among mad people,” Alice remarked.
“Oh, you can't help that,” said the Cat: “we're all mad here. I'm mad. You're mad.”
“How do you know I'm mad?” said Alice.
“You must be," said the Cat, or you wouldn't have come here.” Lewis Carroll
|
|
|
|
|
|
Am back again with another issue in my tool.
i need to grade out a text box, on selecting an option in a combo box drop down.
A part of my tool looks like this:
Label1 (Status) Combobox1 (In-progress, On-Hold,
Label2 (Result) Combobox2 (Pass, Fail)
i need the Combobox2 need to be Disabled only when i select "In-Progress or On-Hold" in the combo box1
i tried with implementing checkbox instead of combobox (if checkbox1.checked = true) etc. it works.
But i donot want to implement the same using combox box.
please assist.
|
|
|
|
|
And what is the problem?
You clearly know how to disable a Textbox, and you presumably know that the ComboBox has SelectionChanged events - so what part of this do you need help with?
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
Try this:
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
comboBox2.Enabled = ! (comboBox1.SelectedItem == "In-progress" || comboBox1.SelectedItem == "On-Hold");
}Here the assumption is made that there are other selectable Items in comboBox1 which, if selected, should enable the use of comboBox2.
“But I don't want to go among mad people,” Alice remarked.
“Oh, you can't help that,” said the Cat: “we're all mad here. I'm mad. You're mad.”
“How do you know I'm mad?” said Alice.
“You must be," said the Cat, or you wouldn't have come here.” Lewis Carroll
|
|
|
|
|
..how to grab coordinates from video screen and automatically save the longitude and latitude then it,,this coordinates will be used for mapping..pls. help me.
|
|
|
|
|
Your question is too vague. What screen are we talking about here?
/ravi
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
