C#

<br />
string strSqlQuery="SELECT * FROM Table WHERE id=@id" ;<br />
sqlConnection cnn = new sqlConnection(ConnectionString) ;<br />
sqlCommand cmd = new sqlCommand(strSqlQuery) ;<br />
cmd.Parameters.Add(new sqlParameters("@id",sqlDbType.Int,4,"id"));<br />
cmd.Parameters[0].value = textBox1.Text ;   //String Value<br />
sqlDataAdapter da = new sqlDataAdapter ;<br />
da.SelectCommand = cmd ;<br />
da.Fill(ds,"Table") ;<br />
dgParts.DataSource = ds.Tables[0].TableName ;<br />
dgParts.Refresh() ;<br />

<br />
this.SetStyle( ControlStyles.UserPaint , true );<br />
this.SetStyle( ControlStyles.AllPaintingInWmPaint , true );<br />
this.SetStyle( ControlStyles.DoubleBuffer , true );<br />

"color: rgba(0, 0, 255, 1)"__^ cXYPosition
	{
		^__b style="color: blue"__^public int</b__^ X;
		^__b style="color: blue"__^public int Y;
	}
	^__b style="color: blue"__^public struct cWindowLocations
	{
		^__b style="color: blue"__^public <font style="color: teal">cXYPosition</font> Main;
		^__b style="color: blue"__^public <font style="color: teal">cXYPosition</font> Options;
	}
	^__b style="color: blue"__^public struct cMenuOptions
	{
		^__b style="color: blue"__^public bool ShowCheckMargin;
		^__b style="color: blue"__^public bool UseXPStyle;
	}
	
	^__b style="color: blue"__^public <font style="color: teal">cWindowLocations</font> WindowLocations;
	^__b style="color: blue"__^public <font style="color: teal">cMeenuOptions</font> MenuOptions;

	^__b style="color: blue"__^public appSettingsMemory()
	{
		^__i__^//initialize all members here
		WindowLocations.Main.X = 0;
		WindowLocations.Main.Y = 0;
		WindowLocations.Options.X = 0;
		WindowLocations.Options.Y = 0;
		MenuOptions.ShowCheckMargin = true;
		MenuOptions.UseXPStyle = false;	
	}
}

^__b style="color: blue"__^public void DumpToFile(<font style="color: teal">appSettinsMemory</font> mem, ^__b style="color: blue"__^string FilePath)
{
    ^__b style="color: blue"__^try
    {
	^__b style="color: blue"__^using (<font style="color: teal">FileStream</font> fs = ^__b style="color: blue"__^new <font style="color: teal">FileStream</font>(FilePath, FileMode.Create))
	{
		<font style="color: teal">XmlSerializer</font> xs = ^__b style="color: blue"__^new <font style="color: teal">XmlSerializer</font>(^__b style="color: blue"__^typeof(<font style="color: teal">appSettingsMemory</font>));
		xs.Serialize(fs, mem);
		fs.Close();
	}
    }
    ^__b style="color: blue"__^catch (<font style="color: teal">Exception</font> e)
    {
	^__i__^//Handle your serialization errors here
	<font style="color: teal">MessageBox</font>.Show(e.Message);
    }
}

^__b style="color: blue"__^public <font style="color: teal">appSettinsMemory</font> LoadFromFile(^__b style="color: blue"__^string FilePath)
{
	<font style="color: teal">appSettingsMemory</font> mem = ^__b style="color: blue"__^new <font style="color: teal">appSettinsMemory</font>();
	^__b style="color: blue"__^try
	{
		^__b style="color: blue"__^using (<font style="color: teal">FileStream</font> fs = ^__b style="color: blue"__^new <font style="color: teal">FileStream</font>(FilePath, FileMode.Open))
		{
			<font style="color: teal">XmlSerializer</font> xs = ^__b style="color: blue"__^new <font style="color: teal">XmlSerializer</font>(^__b style="color: blue">typeof(<font style="color: teal">appSettinsMemory</font>));
                        mem = (<font style="color: teal">appSettinsMemory</font>)xs.Deserialize(fs);
                        fs.Close();
		}
	}
	^__b style="color: blue">catch (<font style="color: teal">Exception</font> e)
	{
		^__i>// Perform any de-serialization error handling here
	}
	^__b style="color: blue">return mem;
}