C#

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.

ahmed_one wrote:

Are programmers do it by setting readonly property of controls true/false? Or there are other options available?

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.

• 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.


PB 369,783 wrote:

I just find him very unlikeable, and I think the way he looks like a prettier version of his Mum is very disturbing.[^]

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.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

YourRichTextBox.Rtf = YourRTFString;

string YourPlainText = YourRichTextBox.Text;

// in Form scope 
private char[] cleanRTF = new char[] {'\\', ' ', '{', '}', '\r', '\n'};

// in a Method
string[] sAry = str.Split(cleanRTF, StringSplitOptions.RemoveEmptyEntries);

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
    comboBox2.Enabled = ! (comboBox1.SelectedItem == "In-progress" || comboBox1.SelectedItem == "On-Hold");
}