Click here to Skip to main content
15,881,248 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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?

C#
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();
        {
 
        }
    }
 
}
Posted

1 solution

This should help you. Storing User in Session or getting it by parameter.

http://stackoverflow.com/questions/9459118/save-the-user-name-in-session-from-the-login-page[^]

Please approve solution if it helps.

Thanks.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900