I use this code to fill a grid.
SqlConnection conn = null;
string TableName="";
conn = new
SqlConnection(sConn);
conn.Open();
SqlCommand cmd = new SqlCommand("RecepiesSearch", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
cmd.Parameters.Add (new SqlParameter ("@Name", tbName.Text ));
cmd.Parameters.Add( new System.Data.SqlClient.SqlParameter( "@tbl",
System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Output,
true, ((System.Byte)(0)), ((System.Byte)(0)), "tbl",
System.Data.DataRowVersion.Current, null));
cmd.ExecuteNonQuery();
TableName = cmd.Parameters["@tbl"].Value.ToString();
gridSearch.DataMember = "";
SqlDataAdapter adap = new SqlDataAdapter();
adap.SelectCommand = cmd;
DataSet ds = new DataSet ();
adap.Fill (ds, TableName);
gridSearch.DataSource = ds;
gridSearch.DataMember = TableName;
But, I get an error after gridSearch.DataMember = TableName : " Cannot
create a child list for field Cakes".
Hrcko