13.02.04 C# Linq 添加、修改 带有richTextBox格式的内容到数据库

<SPAN style="COLOR: #3366ff"><STRONG>修改</STRONG></SPAN>
                        //db.RTUs.AsEnumerable().ElementAt(listBox_rtu.SelectedIndex).RTU_ID = textBox_rtuID.Text;
                        //db.RTUs.AsEnumerable().ElementAt(listBox_rtu.SelectedIndex).X = Convert.ToInt32(textBox_PosX.Text);
                        //db.RTUs.AsEnumerable().ElementAt(listBox_rtu.SelectedIndex).Y = Convert.ToInt32(textBox_PosY.Text);
                        //db.RTUs.AsEnumerable().ElementAt(listBox_rtu.SelectedIndex).GPRS_ID = textBox_PosX.Text;

                        //var stream = new System.IO.MemoryStream();
                        //richTextBox_rtuDescription.SaveFile(stream, RichTextBoxStreamType.RichText);
                        //stream.WriteByte(13);
                        //byte[] buffer = stream.GetBuffer();
                        //db.RTUs.AsEnumerable().ElementAt(listBox_rtu.SelectedIndex).rtf = buffer;

                        //
                        //先删除，
                        //
                        var rs = from rtu in db.RTUs
                                 where rtu.RTU_ID == listBox_rtu.SelectedItem.ToString()
                                 select rtu;
                        db.RTUs.DeleteAllOnSubmit(rs);
                        db.SubmitChanges();

                        //
                        //再添加
                        //
                        RTUs newrtu = new RTUs();
                        newrtu.RTU_ID = textBox_rtuID.Text;
                        newrtu.X = Convert.ToInt32(textBox_PosX.Text);
                        newrtu.Y = Convert.ToInt32(textBox_PosY.Text);
                        newrtu.GPRS_ID = textBox_gprsNum.Text;
                        var stream = new System.IO.MemoryStream();
                        richTextBox_rtuDescription.SaveFile(stream, RichTextBoxStreamType.RichText);
                        stream.WriteByte(13);
                        byte[] buffer = stream.GetBuffer();
                        newrtu.rtf = buffer;
                        db.RTUs.InsertOnSubmit(newrtu);

                        db.SubmitChanges();

。。。。。

删除

var results = from r in db.RTUs
              where r.RTU_ID == listBox_rtu.SelectedItem.ToString()
              select r;
db.RTUs.DeleteAllOnSubmit(results);
db.SubmitChanges();

。。。。。

添加

RTUs newRtu = new RTUs();

newRtu.RTU_ID = textBox_rtuID.Text;
newRtu.X = Convert.ToInt32(textBox_PosX.Text);
newRtu.Y = Convert.ToInt32(textBox_PosY.Text);
newRtu.GPRS_ID = textBox_PosX.Text;

var stream = new System.IO.MemoryStream();
richTextBox_rtuDescription.SaveFile(stream, RichTextBoxStreamType.RichText);
stream.WriteByte(13);
byte[] buffer = stream.GetBuffer();
newRtu.rtf = buffer;

db.RTUs.InsertOnSubmit(newRtu);
db.SubmitChanges();