Crstel report based on the dropdownlist

sathish kumar

14y1.4k.NET

hi Frnds...i want to generate crystal report to display itemcode ,batch no, expiry date based on t location and itemcode. I get Location and Item code in dropdownlist...Any1 help me plz...its very urgent....

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

sathish kumar14y ago
i have attached my project here bro...The form called Reports.aspx inwhich i have to create crystal report...cud u help me pls... very urgent....
Kunal Vaishya14y ago
Dear

Fill dataset with any table like Code and Name

after

Set DataSource into DropDown Like this

private void FillDropDownList()
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString);

        SqlCommand cmd = new SqlCommand("Select * from students", con);

        SqlDataAdapter da = new SqlDataAdapter(cmd);

        DataSet ds = new DataSet();
        da.Fill(ds);

        DropDownList1.DataTextField = ds.Tables[0].Columns["FullName"].ToString();
        DropDownList1.DataValueField = ds.Tables[0].Columns["id"].ToString();

        DropDownList1.DataSource = ds.Tables[0];
        DropDownList1.DataBind();
    }