public void display()
{
using (SqlConnection ConObj = new SqlConnection(constr))
{
ConObj.Open();
try
{
SqlCommand cmd = new SqlCommand("Display_StickyNotes", ConObj);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@uname", SqlDbType.VarChar).Value = uname.Trim();
SqlDataReader reader = null;
reader = cmd.ExecuteReader();
NoteGrid.DataSource = reader;
NoteGrid.DataBind();
}
catch (Exception exp)
{
note.Text += exp.Message;
}
}
}
