Databound DropDownList Filter

See more:

ASP.NET

I have a ddl on a form that is databound to a SqlDataSource. I am trying to filter the ddl to only show data depending on the user that is currently logged in. How will I go by doing this? Is it possible to do this with a databound ddl?

using System;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Text;
using System.Collections.Generic;
using System.Linq;
using System.Configuration;
using System.Drawing.Printing;
 
public partial class FinancialProfileFormA : System.Web.UI.Page
{
 
    protected void Page_Load(object sender, EventArgs e)
    {
        ButtonPrint.Attributes.Add("onclick", "window.print(); return false");
    }
    
 
    protected void DropDownListSchool_SelectedIndexChanged1(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["PasswordConnectionString"].ConnectionString);
        con.Open();
 
        SqlConnection con2 = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["PasswordConnectionString"].ConnectionString);
        con2.Open();
 

        SqlCommand scmd = new SqlCommand("Select User_ID from TableCOCINST where User_ID = " + DropDownListSchool.SelectedValue.ToString(), con);
        SqlCommand scmd2 = new SqlCommand("Select User_ID, INSTRUCTIO, RESEARCH, PUBLIC_SER, ACADEMIC_S, STUDENT_SE, INSTITUTIO, PHYSICAL_P, SCHOLARSHI, AUXILIARY_, HOSPITALS, INDEPENDEN, OTHEREXP, TOTASSETS, TOTLIABILITY, NoNEXPPERMRESASSETS, UNRNETASSETS, TOTALREV, TUITFEES, CURRDEBT, LONGTERMDEBT from TableFIN2012 where User_ID = " + DropDownListSchool.SelectedValue.ToString(), con2);
        SqlDataReader dr = scmd.ExecuteReader();
        SqlDataReader dr2 = scmd2.ExecuteReader();
        if (dr.Read())
        if (dr2.Read())
            {
 
            TextBoxLYInstr.Text = dr2["INSTRUCTIO"].ToString();
            TextBoxLYRes.Text = dr2["RESEARCH"].ToString();
            TextBoxLYPubS.Text = dr2["PUBLIC_SER"].ToString();
            TextBoxLYAcad.Text = dr2["ACADEMIC_S"].ToString();
            TextBoxLYStudS.Text = dr2["STUDENT_SE"].ToString();
            TextBoxLYInstiS.Text = dr2["INSTITUTIO"].ToString();
            TextBoxLYOperM.Text = dr2["PHYSICAL_P"].ToString();
            TextBoxLYSFEDA.Text = dr2["SCHOLARSHI"].ToString();
            TextBoxLYAuxE.Text = dr2["AUXILIARY_"].ToString();
            TextBoxLYHosS.Text = dr2["HOSPITALS"].ToString();
            TextBoxLYIndeO.Text = dr2["INDEPENDEN"].ToString();
            TextBoxLYOED.Text = dr2["OTHEREXP"].ToString();
            TextBoxLYTA.Text = dr2["TOTASSETS"].ToString();
            TextBoxLYTL.Text = dr2["TOTLIABILITY"].ToString();
            TextBoxLYNPRNA.Text = dr2["NoNEXPPERMRESASSETS"].ToString();
            TextBoxLYTUNA.Text = dr2["UNRNETASSETS"].ToString();
            TextBoxLYTR.Text = dr2["TOTALREV"].ToString();
            TextBoxLYTFN.Text = dr2["TUITFEES"].ToString();
            TextBoxLYCD.Text = dr2["CURRDEBT"].ToString();
            TextBoxLYLTD.Text = dr2["LONGTERMDEBT"].ToString();
            TextBoxINST_ID.Text = dr["INST_ID"].ToString();
        
             }
        dr.Close();
        con.Close();
        dr2.Close();
        con2.Close();
        {
 
        }
    }
 
}