C#

"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar

"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)

<br />
if (<br />
  cboCeaseType.SelectedValue.ToString() == "2" || <br />
  cboCeaseType.SelectedValue.ToString() == "5")<br />

Image img = new Bitmap("myimage.bmp");
MemoryStream ms = new MemoryStream();
img.Save(ms);
ms.Seek(0, SeekOrigin.Begin);
StringBuilder sb = new StringBuilder(ms.Length * 2);
byte[] buffer = new byte[4096];
int read = ms.Read(buffer, 0, buffer.Length);
while (read != 0)
{
  for (int i=0; i<read; i++) sb.AppendFormat("{0:x2}", buffer[i]);
  read = ms.Read(buffer, 0, buffer.Length);
}
string hex = sb.ToString();

<br />
//Creating a file and writing <br />
 string strfileName = "PicInHex.rtf";<br />
 FileStream MyStream = new FileStream("c:\\" + strfileName, FileMode.Create);<br />
 System.IO.StreamWriter MyWriter =<br />
      new System.IO.StreamWrite(MyStream,System.Text.Encoding.Default);<br />
//<br />
		<br />
  Image img = new Bitmap("myimage.bmp");<br />
  MemoryStream ms = new MemoryStream();<br />
  //<br />
  //Added System.Drawing.Imaging.ImageFormat.Bmp in the line below(there was compilation err)<br />
  //<br />
  img.Save(ms,System.Drawing.Imaging.ImageFormat.Bmp);<br />
  ms.Seek(0, SeekOrigin.Begin);<br />
 //<br />
 //Added Convert.ToInt32 in the below line(there was compilation err)<br />
 //<br />
  StringBuilder sb = new StringBuilder(Convert.ToInt32(ms.Length * 2));<br />
  byte[] buffer = new byte[4096];<br />
  int read = ms.Read(buffer, 0, buffer.Length);<br />
  while (read != 0){ <br />
 //<< ...is less than sign,<br />
 // modified since it interfares with the HTML tags<br />
   for (int i=0; i<<read; i++)<br />
   sb.AppendFormat("{0:x2}", buffer[i]); <br />
   read = ms.Read(buffer, 0, buffer.Length);<br />
  }<br />
  string hex = sb.ToString();<br />
  MyWriter.Write(hex);<br />
<br />
 //<br />
 MyWriter.Close();<br />
 MyStream.Close();<br />
//<br />

//For running the sample code paste the following in button click event
private void button1_Click(object sender, System.EventArgs e)
{
	string strImageToRTF ="";// string to hold rtf code

	//create the file where rtf code has to be written
	string strfileName = "ImageInRTFfile.rtf";
	FileStream MyStream = new FileStream("c:\\" + strfileName, FileMode.Create);
	System.IO.StreamWriter MyWriter =new System.IO.StreamWriter(MyStream,System.Text.Encoding.Default);
	//

	//Prepare image object from image file 
	Image img = new Bitmap(@"c:\myimage.bmp");
        //

	//get the RTF string from the method  ImageToRTF   
	strImageToRTF = this.ImageToRTF(img);
        //

	//write the generated RTF string into the file
	MyWriter.Write(strImageToRTF);
        //

	//close Stream Writer and File Stream
	MyWriter.Close();
	MyStream.Close();
	//
}
//

//
// Method to get the rtf code string from the image object
private  string ImageToRTF(Image img)
{
	RichTextBox rtf = new RichTextBox();
	Clipboard.SetDataObject(img);
	rtf.Paste();
	return rtf.Rtf;
}
//
//

listBox1.DataSource = ds; // your DataSet instance
listBox1.DataMember = "MyTable"; // your table name
listBox1.DisplayMember = "Name"; // column name for display data
listBox1.ValueMember = "ID"; // column name for value data

private void removebutton_Click(object sender, System.EventArgs e)
		{
			oleDbDataAdapter1.Fill(dataset);
			try
			{
				
			string strSQL = "DELETE  FROM Movie WHERE Title = '" + comboBox1.Text.ToString() + "'";
			oleDbDeleteCommand1.CommandText = strSQL;
			oleDbDataAdapter1.DeleteCommand = oleDbDeleteCommand1;
 
			oleDbDeleteCommand1.Connection = oleDbConnection1;
			oleDbDeleteCommand1.Connection.Open();
			oleDbDeleteCommand1.ExecuteNonQuery();
			oleDbDeleteCommand1.Connection.Close();
			MessageBox.Show(comboBox1.Text.ToString() + " has been removed");
			oleDbDataAdapter1.Update(dataset);
			
			
			}
			catch (Exception ex)
			{
				MessageBox.Show("Not found");
				MessageBox.Show(ex.ToString());
			}
			
			
			
			
			
		} 

OleDbDataAdapter1.Update(dataset); // I assume this updates the Dataset<br />

private void removebutton_Click(object sender, System.EventArgs e)
		{
			
			
			try
			{
				
			string strSQL = "DELETE  FROM Movie WHERE Title = '" + comboBox1.Text.ToString() + "'";
			oleDbDeleteCommand1.CommandText = strSQL;
			oleDbDataAdapter1.DeleteCommand = oleDbDeleteCommand1;
 
			oleDbDeleteCommand1.Connection = oleDbConnection1;
			oleDbDeleteCommand1.Connection.Open();
			oleDbDeleteCommand1.ExecuteNonQuery();
			
			MessageBox.Show(comboBox1.Text.ToString() + " has been removed");
			oleDbDataAdapter1.Update(dataset);			oleDbDeleteCommand1.Connection.Close();
			
			
			}
			catch (Exception ex)
			{
				MessageBox.Show("Not found");
				MessageBox.Show(ex.ToString());
				oleDbDeleteCommand1.Connection.Close();
			}
			
			
			oleDbDataAdapter1.Fill(dataset);
			
			comboBox1.DataSource = dataset;		
}