C#

My Code<br />
// Initialize database connection.<br />
OleDbConnection _connection = new OleDbConnection( @"Provider=VFPOLEDB.1;Data Source=C:\DataFolder\;");<br />
<br />
// SQL select statement<br />
string strSelect = "SELECT * FROM table1";<br />
<br />
// Create data adapter, command builder and dataset<br />
OleDbDataAdapter _dataAdapter = new OleDbDataAdapter(strSelect, _connection);<br />
OleDbCommandBuilder _commandBuilder = new OleDbCommandBuilder(_dataAdapter);<br />
DataSet _dataset = new DataSet();<br />
<br />
// Fill the dataset with the data<br />
_dataAdapter.FillSchema(_dataset, SchemaType.Source);<br />
_dataAdapter.Fill(_dataset);<br />
<br />
// Loop through each of the rows in the dataset<br />
foreach(DataRow dr in _dataset.Tables[0].Rows)<br />
{<br />
    // object contains a blank string ...<br />
    // no options to convert to a character array<br />
   // cannot extract ANY other character values.<br />
    object thisField = dr["myField"];<br />
}<br />

<br />
// Example of what I mean with strings and embedded nulls<br />
<br />
// create a string<br />
string myStr = "Hello World";<br />
<br />
// create a unicode-null character (ASCII = 0)<br />
char myChar = Convert.ToChar(0);<br />
<br />
// replace the characters<br />
myStr = myStr.Replace("l", myChar);<br />
<br />
Console.Writeline ( myStr );<br />
<br />
// writes "He"<br />
// as the string is terminated at the first "null" character ..<br />

<br />
string connString = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;<br />
SqlConnection conn = new SqlConnection(connString);<br />

<br />
     //  set transparant color <br />
     Bitmap bmp = new Bitmap(this.ImgBackground.Image); <br />
     bmp.MakeTransparent(Color.FromArgb(255,0,255)); <br />
     this.ImgBackground.Image= bmp;<br />