예제 #1
0
    public void getApplications(object sender, EventArgs e)
    {
        if (Session["Username"] == null)
        {
            return;
        }
        string        connStr = ConfigurationManager.ConnectionStrings["iwork"].ToString();
        SqlConnection conn    = new SqlConnection(connStr);
        SqlCommand    cmd     = new SqlCommand("getApplications", conn);

        cmd.CommandType = CommandType.StoredProcedure;

        cmd.Parameters.Add(new SqlParameter("@username", Session["Username"].ToString()));

        SqlDataAdapter sda = new SqlDataAdapter(cmd);
        DataTable      dt  = new DataTable();

        sda.Fill(dt);

        Applications.DataSource = dt;
        Applications.DataBind();
    }