C# Data Binding

[karenRoss]

I'm trying to bind my repeater control to a SQLCommand Object...but I dont think I'm anywhere close...

myConnection.Open();
Repeater1.DataSource = searchCommand.ExecuteReader(CommandBehavior.CloseConnection);
Repeater1.DataBind();
 

[nateraaaa]

The DataSource property will load the Repeater control with data. What you need to do is run a stored procedure to return rows of data then fill this data into a dataset. Then use a dataset as the datasource of your repeater.

Try this.

DataSet ds = new DataSet();
connection.Open();
SqlCommand oCmd = new SqlCommand();
oCmd.Connection = oConn;
oCmd.CommandType = CommandType.StoredProcedure;
oCmd.CommandText = "nameofyourstoredprocedure";
ds.Clear();
SqlDataAdapter oDataAdapter = new SqlDataAdapter();
oDataAdapter = new SqlDataAdapter(oCmd.CommandText, connection.ConnectionString);
oDataAdapter.SelectCommand = oCmd;
oDataAdapter.Fill(ds);
 
 
Repeater1.DataSource = ds;
Repeater1.DataBind();

This should get you on the right track.

Nathan

[karenRoss]

The DataSource property will load the Repeater control with data. What you need to do is run a stored procedure to return rows of data then fill this data into a dataset. Then use a dataset as the datasource of your repeater.

Try this.

DataSet ds = new DataSet();
connection.Open();
SqlCommand oCmd = new SqlCommand();
oCmd.Connection = oConn;
oCmd.CommandType = CommandType.StoredProcedure;
oCmd.CommandText = "nameofyourstoredprocedure";
ds.Clear();
SqlDataAdapter oDataAdapter = new SqlDataAdapter();
oDataAdapter = new SqlDataAdapter(oCmd.CommandText, connection.ConnectionString);
oDataAdapter.SelectCommand = oCmd;
oDataAdapter.Fill(ds);
 
 
Repeater1.DataSource = ds;
Repeater1.DataBind();

This should get you on the right track.

Nathan

Thank you so much. I'd buy you a cappuccino (from some independent shop, not starbucks) if I could.

I'm so glad you were on the internet today ;)

[Plater]

You can use DataSets (and maybe DataTable)

DataSet retval= new DataSet();
string myq="SELECT ...";//your sql statement
SqlDataAdapter dba = new SqlDataAdapter(myq, dbcon);//dbcon is my SqlConnection object
dba.Fill(retval);