Which code is better to use

[hime]

hello all,

i am programming a webform which include a dropdownlist bind to DB to show the entries in a certain column in a table the user can chose an item and insert or update the tables I have two codes one thet used a dataset and the other code i used datareader to bind the list to the needed items and am not sure which one is beter to use in the webform

MySqlDataAdapter depada = new MySqlDataAdapter("select * from dep1",con);
	DataSet ds = new DataSet();
	depada.Fill(ds);
	lstdepa.DataSource = ds;
	lstdepa.DataMember = ds.Tables[0].TableName;
	lstdepa.DataTextField = "depname";
	lstdepa.DataValueField = "depid";
	lstdepa.DataBind();

MySqlCommand MySqlComm = new MySqlCommand("SELECT * FROM dep", con);
	con.Open();
	ddDR = MySqlComm.ExecuteReader(CommandBehavior.CloseConnection);
	lstdepe.DataSource = ddDR;
	lstdepe.DataTextField = "depname";
	lstdepe.DataValueField = "depid";
	lstdepe.DataBind();
	con.Close();

[kenobewan]

Define better... Have you tested them, does either of them work?

[hime]

Define better... Have you tested them, does either of them work?

Hi;

yes both codes does work but i need to know which one is more efficient for the program. i mean in which case should we use dataset and dataadapter and in which should we use datareader and command in other words i want to know exactly when to use each one of them

thanx

[kenobewan]

Here is an article that may help:
DataSet Vs. DataReader