int i;

protected void ddlCat_SelectedIndexChanged(object sender, EventArgs e)
    {
        ddlScat.Items.Clear();

        SqlConnection connect = dbConnection.GetConnection();
        SqlCommand cmd2 = new SqlCommand("select c_id from categories where c_name=@catname", connect);
        cmd2.Parameters.AddWithValue("@catname", ddlCat.SelectedValue.ToString());
        //cmd2.Parameters.AddWithValue("@catname", ddlCategory.SelectedItem.Value);
        connect.Open();
        SqlDataReader rdr2 = cmd2.ExecuteReader();

        while (rdr2.Read())
        {
            i = Int32.Parse(rdr2.GetValue(0).ToString());
        }
        connect.Close();
        connect.Open();
        SqlCommand command2 = new SqlCommand("select s_name,s_id from subcategories where c_id=@i", connect);
        command2.Parameters.AddWithValue("@i", i);

        SqlDataAdapter da = new SqlDataAdapter(command2);
        DataTable dt = new DataTable();

        da.Fill(dt);

        ddlScat.DataSource = dt;
        ddlScat.DataTextField = "s_name";
        ddlScat.DataValueField = "s_id";
        ddlScat.DataBind();

        connect.Close();

    }