protected void GvProjects()
{
string username = Session["UserNameDB"].ToString();
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "select P_Name,P_Key,P_Cat,P_AssignTo from Projects where AssignBy='" + username + "'";
cmd.Connection = con;
con.Open();
GvProject.DataSource = cmd.ExecuteReader();
GvProject.DataBind();
con.Close();
}
}
}
private void LoadDataToGridView()
{
GvProject.DataSource = _rep.ProjectRepository.LoadProject();
GvProject.DataBind();
}
