ASP.NET

dtMyDataTable.Clear();

loadDDL("tapas");<br />
			loadDDL("paellas");<br />
			loadDDL("postres");<br />
			loadDDL("desserts");<br />
			loadDDL("bebidas");<br />
			loadDDL("vinos");

private void loadDDL(string input)<br />
		{<br />
			string checksql="SELECT * FROM tbl_Orders WHERE orderTableID = '"+tmpTable+"' AND orderUserID = '"+tmpCustLast+"' AND orderCategory = '"+input+"' AND (OrderTime BETWEEN '"+preDate+"' AND '"+dateNow+"')  ORDER BY orderTime DESC, orderUpdated DESC";<br />
			//load data<br />
			myAdapter.SelectCommand.CommandText=checksql;<br />
			myAdapter.Fill(dataSet11, "tbl_orders");<br />
			//which dropdownlist?<br />
			switch(input)<br />
			{<br />
				case "tapas":<br />
				{<br />
					DataList1.DataSource= dataSet11;<br />
					DataList1.DataBind();<br />
					break;<br />
				}<br />
				case "paellas":<br />
				{<br />
					DataList2.DataSource= dataSet11;<br />
					DataList2.DataBind();<br />
					break;<br />
				}<br />
				case "postres":<br />
				{<br />
					DataList3.DataSource= dataSet11;<br />
					DataList3.DataBind();<br />
					break;<br />
				}<br />
				case "desserts":<br />
				{<br />
					DataList4.DataSource= dataSet11;<br />
					DataList4.DataBind();<br />
					break;<br />
				}<br />
				case "bebidas":<br />
				{<br />
					DataList5.DataSource= dataSet11;<br />
					DataList5.DataBind();<br />
					break;<br />
				}<br />
				case "vinos":<br />
				{<br />
					DataList6.DataSource= dataSet11;<br />
					DataList6.DataBind();<br />
					break;<br />
				}<br />
				<br />
<br />
			}<br />
			<br />
		}

Jakob Lund Krarup wrote:

10 kinds of people in the world:
- Those who understand binary
- Those who don't

munklefish wrote:

myAdapter.SelectCommand.CommandText=checksql;
myAdapter.Fill(dataSet11, "tbl_orders");

myAdapter.SelectCommand.CommandText=checksql;
dataSet11.Clear();
myAdapter.Fill(dataSet11, "tbl_orders");

munklefish wrote:

P.s Jakob,

Jakob Lund Krarup wrote:
10 kinds of people in the world:
- Those who understand binary
- Those who don't


I saw one of your posts ages ago and thought id add the binary joke as my footer in response to yours! I see you've adopted it now.

Jakob Lund Krarup wrote:

dataSet11.Clear();

Jakob Lund Krarup wrote:

You might consider storing the different tables in one dataset, and then storing the DataSet in Application, to make it easier on the database?

protected void LoadData()
{
  //if we don't have any data in Application
  if(Application["myData"] == null)
  {
    //then we need to load it from the database
    //so we create a fresh dataset
    dsMyData = new DataSet();

    //and a new adapter for each of the tables we want in the dataset
    SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM orders", strConnectionString);
    //we fill the table
    adapter.Fill(sdMyData, "orders");
    //fill more tables as needed
    // .. etc ..
    // .. etc ..

    //Finally store the dataset in Application state
    Application["myData"] = dsMyData;
  }
  //otherwise, we have data in Application (from a previous call to the page)
  //and we just get a reference to the DataSet
  else
    dsMyData = (DataSet)Application["myData"];
}

SqlConnection connection = new SqlConnection("server=(local);database=shop;user=me;password=secret");
SqlCommand command = connection.CreateCommand();
command.CommandText = "SELECT * FROM orders WHERE ...yadayadayada...";
connection.Open();
dlOrders.DataSource = command.ExecuteReader();
dlOrders.DataBind();
connection.Close();

munklefish wrote:

Happy Easter!

Jakob Lund Krarup wrote:

hehe .. yup - I have it on a T-shirt.......

Mike Ellison wrote:

Hi Dario. What does your Application_Error code look like?

Mike Ellison wrote:

Another possibility is if the exception is generated on a different thread than the main ASP.NET thread.