I need HELP!!!?

Question

i am using asp.net and access. I need to display several product information on the web page..how do i do this?? do i use datagrids, or what?? can someone please help me with this?? i am desperate!!!

Answer 1

you have many options with asp.net

My preference is a datarepeater, but datagrid's work just as well.

Here you go in brief (if you need details email me):

1) Put a datagrid/datarepeater on your page
2) set up your data control to display the neccessary information
3) In the code behiond: Create a conenction to your access database
4) Query for your data and place it in a dataset
5) Set the data control's source to be your dataset
6) call the databind method for your data control.

Answer 2

I'm using Datagrid to retrieve data from the database.
Fist u place a datagrid on the page.

in the codebehind section u pls follow like this

grdProduct.Datasource = GetProducts();
grdProduct.DataBind();

public static OleDBDataReader GetProducts()
{
OleDBConnection myCon = new OleDBConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
try
{
OleDBCommand cmd = new OleDBCommand("select * from tblProduct",myCon);
cmd.CommandType = CommandType.StoredProcedure;

myCon.Open();
OleDBDataReader Result = cmd.ExecuteReader(CommandBehavior.CloseConnection);
return Result;

}
catch(Exception ex)
{
throw(ex);
}
}


Good Luck

Answer 3

aaaaaaaa... such a horrible aplications

Answer 4

have no clue