Updation of some column values of a table in mysql procedure

Question

I have one procedure written in Mysql, which i access from asp.net application.
I have an update and insert query in it for some columns of a table and i want remaining column values as it is. what should i do? please HEEEEELLLLP.....

Answer 1

 I found somewhere that I have to save it in rtf file. In source code to this library I found a RtfWriter class. Like a paramether method to generate rtf needs TextArea object. But I have my TextEditorControl only. How to convert it?

Answer 2

There is a TextEditorControlBase.Text and with it I can copy the text to Word but without colors.
http://img155.imageshack.us/my.php?image=beztytuuccxke0.png

This is the reason why I posted this topic.

Answer 3

I am not familiar with that text editor control but with other controls such as a rich text box control, there are methods used to select all of the text, if select all of the text and copy it to the clipboard, you should be able to paste the contents with the formatting.  For a rich text box control, the code would look like this:

private void copyToolStripMenuItem_Click(object sender, EventArgs e)

{

rtbDoc.SelectAll();

Clipboard.SetText(rtbDoc.SelectedRtf, TextDataFormat.Rtf);

}