ASP.NET

1. use an AccessDataSource control on your page, including an InsertCommand, establishing ControlParameters tied to your text boxes; then code the button to execute the AccessDataSource control's .Insert() method...
2. create a custom class that handles your data access; in it, create an .Insert() method of your own that accepts two parameters; use OleDbConnection, OleDbCommand, and OleDbParameter classes to issue the SQL INSERT statement to your database; then code the button to execute the .Insert() method in your custom class...
3. create the custom class as before, then use an ObjectDataSource on your page with the associated class. In your button's code, execute the .Insert() method on the ObjectDataSource...
4. create a custom class and ObjectDataSource as before, and substitute for your existing textboxes/button a FormView or DetailsView control. Associate the FormView/DetailsView to your ObjectDataSource through the DataSourceID property, and let it handle all the data access for you...
5. for that matter, you could associate an AccessDataSource to a FormView or DetailsView as well, and not use a custom class (or coding at all)...

2hdass wrote:

Recently i created my own web control. I want to make it so that i will recieve arguments like

<.uc1:treeFrame ID="TreeFrame1" runat= "server" argument1= "blah1" argument2= "blah2"/>

2hdass wrote:

when i add my own user control to a html page by dragging it onto the designer, it puts this at the top of the html

<%@ Register Src="treeFrame.ascx" TagName="treeFrame" TagPrefix="uc1" %>

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();