private void NewSearch()
{
System.Web.Security.MembershipUser usr = System.Web.Security.Membership.GetUser();
SqlConnection conn;
SqlCommand comm;
SqlDataReader reader;
string connectionString =
ConfigurationManager.ConnectionStrings[
"Assignment4"].ConnectionString;
conn = new SqlConnection(connectionString);
comm = new SqlCommand(
"Select RecipeName, CookingTime, Portions, Description, UserName, Privacy " +
"From [Assignment4].[dbo].[User] " +
"inner Join UserRecipe on UserRecipe.UserId = [Assignment4].[dbo].[User].UserId " +
"inner Join Recipe on Recipe.RecipeId=UserRecipe.RecipeId " +
"where Privacy = 0" +
"Union " +
"Select RecipeName, CookingTime, Portions, Description, UserName, Privacy " +
"From [Assignment4].[dbo].[User] " +
"inner Join UserRecipe on UserRecipe.UserId = [Assignment4].[dbo].[User].UserId " +
"inner Join Recipe on Recipe.RecipeId=UserRecipe.RecipeId " +
"where privacy = 1 and UserName="******"Search Results:";
//myRepeater.Visible = true;
}
catch
{
dbErrorLabel.Text =
"Error loading the details!<br />";
}
finally
{
conn.Close();
}
}
