ASP.NET

<br />
<br />
using System;<br />
using System.Collections;<br />
using System.ComponentModel;<br />
using System.Data;<br />
using System.Data.OleDb;<br />
using System.Drawing;<br />
using System.Web;<br />
using System.Web.SessionState;<br />
using System.Web.UI;<br />
using System.Web.UI.WebControls;<br />
using System.Web.UI.HtmlControls;<br />
using WinPbMove;<br />
namespace WebPbMove<br />
{<br />
	/// <summary><br />
	/// </summary><br />
	public class WebProdSelect : MetaBuilders.WebControls.DialogPage<br />
	{<br />
		protected System.Web.UI.WebControls.TextBox TextBox1;<br />
		protected System.Web.UI.WebControls.Label Label1;<br />
		protected System.Web.UI.WebControls.ListBox ListBox1;<br />
		protected System.Web.UI.WebControls.Button cmdFilter;<br />
		protected System.Web.UI.WebControls.Button cmdReturn;<br />
		private PbMove dl = null;<br />
		const string MYSTRING = "-------";<br />
	<br />
		private void Page_Load(object sender, System.EventArgs e)<br />
		{<br />
			string strSQL = "";<br />
			if (!Page.IsPostBack)<br />
			{<br />
				if (dl == null)<br />
					dl = new PbMove();<br />
				if (dl.OpenConnection() == false)<br />
					throw(new SystemException("Connect Oracle Failed!"));<br />
				OleDbConnection cn = dl.Connection;<br />
				<br />
				if (TextBox1.Text == "")<br />
				{<br />
					strSQL = "Select t.prdct_name || '" + MYSTRING + "' || t.dscr From ip_prdct t";<br />
				}<br />
				else<br />
				{<br />
					//TextBox1.Text = Session["UserFilterString"].ToString();<br />
					strSQL = "Select t.prdct_name || '" + MYSTRING + "' || t.dscr From ip_prdct t"<br />
						+ " Where t.dscr like '%" + TextBox1.Text + "%'";<br />
				}<br />
				OleDbDataAdapter adpter = new OleDbDataAdapter(strSQL,cn);<br />
				DataSet ds = new DataSet();<br />
				adpter.Fill(ds,"IP_PRDCT");<br />
				DataTable dtProdct = ds.Tables["IP_PRDCT"];<br />
				ListBox1.DataSource = dtProdct;<br />
				ListBox1.DataTextField = dtProdct.Columns[0].ColumnName;<br />
				ListBox1.DataValueField = dtProdct.Columns[0].ColumnName;<br />
				ListBox1.DataBind();<br />
			}<br />
		}<br />
<br />
		#region Web <br />
		override protected void OnInit(EventArgs e)<br />
		{<br />
			//<br />
			//<br />
			InitializeComponent();<br />
			base.OnInit(e);<br />
		}<br />
		<br />
		/// <summary><br />
		/// </summary><br />
		private void InitializeComponent()<br />
		{    <br />
			this.cmdFilter.Click += new System.EventHandler(this.cmdFilter_Click);<br />
			this.cmdReturn.Click += new System.EventHandler(this.cmdReturn_Click);<br />
			this.Load += new System.EventHandler(this.Page_Load);<br />
<br />
		}<br />
		#endregion<br />
<br />
		private void cmdFilter_Click(object sender, System.EventArgs e)<br />
		{			<br />
			if (dl == null)<br />
				dl = new PbMove();<br />
			if (dl.OpenConnection() == false)<br />
				throw(new SystemException("Connect Oracle Failed!"));<br />
			OleDbConnection cn = dl.Connection;<br />
				<br />
			string strSQL = "Select t.prdct_name || '" + MYSTRING + "' || t.dscr From ip_prdct t"<br />
				+ " Where t.dscr like '%" + TextBox1.Text + "%'";<br />
			OleDbDataAdapter adpter = new OleDbDataAdapter(strSQL,cn);<br />
			DataSet ds = new DataSet();<br />
			adpter.Fill(ds,"IP_PRDCT");<br />
			DataTable dtProdct = ds.Tables["IP_PRDCT"];<br />
			ListBox1.DataSource = dtProdct;<br />
			ListBox1.DataTextField = dtProdct.Columns[0].ColumnName;<br />
			ListBox1.DataValueField = dtProdct.Columns[0].ColumnName;<br />
			ListBox1.DataBind();<br />
		}<br />
<br />
		private void cmdReturn_Click(object sender, System.EventArgs e)<br />
		{<br />
			string sRet = "";<br />
			string str = ListBox1.SelectedItem.Text;<br />
			int i = str.IndexOf(MYSTRING);<br />
			if (i != -1)<br />
				sRet = str.Substring(0,i).Trim();<br />
			this.Close(sRet);		<br />
		}<br />
	}<br />
}<br />
<br />

SELECT AVG(/*Price Field*/) AS AverageSalesPrice, /* Fields */ FROM  /* Bill Item Table */<br />
INNER JOIN /* Bill Table */ ON (/* Bill Item -> Bill ID */ = /* Bill ID */)<br />
WHERE /* Bill Date Field*/ BETWEEN /* Lower Bound */ AND /* Upper Bound */<br />
GROUP BY /* Selected Fields */

using(SqlConnection conn = new SqlConnection(connectionString)) <br />
{<br />
  conn.Open();<br />
  using(SqlCommand cmd = conn.CreateCommand())<br />
  {<br />
    cmd.CommandText = //Insert query here<br />
    cmd.CommandType = //Set the correct commandtype<br />
<br />
    using(IDataReader reader = cmd.ExecuteReader()) <br />
    {<br />
      //Read the field<br />
    }<br />
  }<br />
}