SqlConnection myConnection =
new SqlConnection(connstring );
SqlDataAdapter myAdapter =
"SELECT ProductID, ProductName, QuantityPerUnit, UnitPrice FROM Products",
//Fill the DataSet
DataSet ds = new DataSet();
//DataBind the Repeater
// MyRepeater.DataSource = ds.Tables["Products"].DefaultView;
// Populate the repeater control with the Items DataSet
PagedDataSource objPds = new PagedDataSource();
objPds.DataSource = ds.Tables.DefaultView;
objPds.AllowPaging = true;
objPds.CurrentPageIndex = CurrentPage;
I tmeans that the first table in the dataset is to be attached to the datasource of the control...DefaultView property returns a DataView you can use to sort, filter, and search a DataTable...
for eg... ds.Tables.DefaultView.RowFilter = "city='New York'"
I am doing the project of electronic PO form, and I got stuck. I am using wins 2000 server, front end ASP version 3.0, back end SQL database.
I have 2 questions to ask if anybody knows any of these, please let me know I really appreciate.
1/. To the PO form, do you know how to display PO # on
the form. This # usually shows up at the top right
corner of the form (6 digit # such as 026191). I set
up in database by using identity increment in PO #
column so that every time the user adds new orders,
the PO # will automatically increase.
To ASP file, how can I display the #?
2/. After the user fill out the form, they will submit to whoever approves the orders like a manager, it should be default. At the left bottom it shows the name of the person who orders. At the right bottom it shows the name of the approval person like manager. Do you know how to set up this?
If you have any ideas, please let me know.
Thank you very much for your help.