• c#大圣之路笔记——绑定dropdown数据的基本方法


     1  
    //////通过DataTable 绑定数据

    BindRegion();
    2 3 4 private void BindRegion() 5 { 6 // ddlRgn.DataSource = Location.GetRegionByWWID(System.Configuration.ConfigurationManager.AppSettings["DSN"].DecodeBase64(), ViewState["WWID"].ToString().ToHtmlEncode()); 7 string type = "region"; 8 ddlRgn.DataSource = BindData(ddlQuarter.SelectedValue,string.Empty,string.Empty,string.Empty,string.Empty, type); 9 ddlRgn.DataValueField = "Key"; 10 ddlRgn.DataTextField = "Value"; 11 ddlRgn.DataBind(); 12 ddlRgn.Items.Insert(0, new ListItem("ALL", "ALL")); 13 } 14 15 16 17 private DataTable BindData(string quater, string rgn, string subrgn, string grid,string city, string type) 18 { 19 DataTable ddt = new DataTable(); 20 21 SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["DSN"].DecodeBase64()); 22 SqlCommand cmd = new SqlCommand(); 23 SqlDataAdapter da = new SqlDataAdapter(); 24 25 try 26 { 27 cmd.Connection = conn; 28 cmd.CommandText = "region_subregion_grid_pref_city_by_wwid_quarter"; 29 cmd.CommandType = CommandType.StoredProcedure; 30 31 cmd.Parameters.AddWithValue("@yyyyqq", quater); 32 if (ddlRgn.SelectedValue==string.Empty || ddlRgn.SelectedValue=="ALL") 33 { 34 cmd.Parameters.AddWithValue("@rgn_cd",DBNull.Value); 35 }else 36 { 37 cmd.Parameters.AddWithValue("@rgn_cd", rgn); 38 } 39 cmd.Parameters.AddWithValue("@subrgn_cd",DBNull.Value); 40 if (ddlGrid.SelectedValue==string.Empty || ddlGrid.SelectedValue=="ALL") 41 { 42 cmd.Parameters.AddWithValue("@grid_cd", DBNull.Value); 43 } 44 else 45 { 46 cmd.Parameters.AddWithValue("@grid_cd", grid); 47 } 48 cmd.Parameters.AddWithValue("@pref_cd", DBNull.Value); 49 if (ddlCity.SelectedValue==string.Empty || ddlCity.SelectedValue=="ALL") 50 { 51 cmd.Parameters.AddWithValue("@city_id", DBNull.Value); 52 } 53 else 54 { 55 cmd.Parameters.AddWithValue("@city_id", city); 56 } 57 cmd.Parameters.AddWithValue("@wwid", txtWWID.Text); 58 cmd.Parameters.AddWithValue("@type", type); 59 da.SelectCommand = cmd; 60 da.Fill(ddt); 61 } 62 catch //(Exception) 63 { 64 ddt = null; 65 } 66 finally 67 { 68 conn.Close(); 69 da.Dispose(); 70 cmd.Dispose(); 71 } 72 return ddt; 73 }


    //////通过 Dictionary 绑定数据


     1  private void BindRegion()
     2  5         {
     3  6             ddlRgn.DataSource = Location.GetRegionByWWID(System.Configuration.ConfigurationManager.AppSettings["DSN"].DecodeBase64(), ViewState["WWID"].ToString().ToHtmlEncode());
     4  7             string type = "region";
     5  8            // ddlRgn.DataSource = BindData(ddlQuarter.SelectedValue,string.Empty,string.Empty,string.Empty,string.Empty, type);
     6  9             ddlRgn.DataValueField = "Key";
     7 10             ddlRgn.DataTextField = "Value";
     8 11             ddlRgn.DataBind();
     9 12             ddlRgn.Items.Insert(0, new ListItem("ALL", "ALL"));
    10 13         }
     1   public static Dictionary<string, string> GetRegionByWWID(string connectionString, string wwId)
     2         {
     3             SqlParameter[] paraList = new[]
     4             {
     5                 new SqlParameter("@rgn_cd", DBNull.Value),
     6                 new SqlParameter("@subrgn_cd", DBNull.Value),
     7                 new SqlParameter("@grid_cd", DBNull.Value),
     8                 new SqlParameter("@pref_cd", DBNull.Value),
     9                 new SqlParameter("@city_id", DBNull.Value),
    10                 new SqlParameter("@wwid", wwId),
    11                 new SqlParameter("@type", "region")
    12             };
    13             Dictionary<string, string> list = new Dictionary<string, string>();
    14             using (IDataReader reader = SqlHelper.ExecuteReader(connectionString, "region_subregion_grid_pref_city_by_wwid", paraList))
    15             {
    16                 while (reader.Read())
    17                 {
    18                     list.Add(reader["rgn_cd"].ToString().Trim(), reader["rgn_nm"].ToString().Trim());
    19                 }
    20             }
    21             return list;
    22         }

     1 /////Dictionary
     2 
     3    private void BindRegion()
     4         {
     5             //string sSQL = String.Format("select distinct a.rgn_cd, a.rgn_nm from ext_prc_v_rgn_subrgn_grid_pref_city a left join prc_slsprs_city_asgn b on b.city_id=a.city_id order by rgn_nm");
     6             //ddlRegion.DataSource = SqlHelper.ExecuteDataset(Application["DSN"].ToString(), CommandType.Text, sSQL);
     7             //ddlRegion.DataBind();
     8             //ddlRegion.Items.Insert(0, new ListItem("ALL", String.Empty));
     9             ddlRegion.DataSource = Location.GetRegion(Application["DSN"].ToString());
    10             ddlRegion.DataBind();
    11         }
    12 
    13 
    14  public static Dictionary<string, string> GetRegion(string connectionString)
    15         {
    16             SqlParameter[] paraList = new[]
    17             {
    18                 new SqlParameter("@rgn_cd", DBNull.Value),
    19                 new SqlParameter("@subrgn_cd", DBNull.Value),
    20                 new SqlParameter("@grid_cd", DBNull.Value),
    21                 new SqlParameter("@pref_cd", DBNull.Value),
    22                 new SqlParameter("@city_id", DBNull.Value),
    23                 new SqlParameter("@type", "region")
    24             };
    25             Dictionary<string, string> list = new Dictionary<string, string>();
    26             using (IDataReader reader = SqlHelper.ExecuteReader(connectionString, "region_subregion_grid_pref_city_type", paraList))
    27             {
    28                 while (reader.Read())
    29                 {
    30                     list.Add(reader["rgn_cd"].ToString().Trim(), reader["rgn_nm"].ToString().Trim());
    31                 }
    32             }
    33             return list;
    34         }





  • 相关阅读:
    页面笔记
    RestTemplate
    Spring中使用HibernateCallback
    工作中的小零碎
    hibernate核心思想 体系结构(转)
    db2备份和导入单个表操作
    MSB-STRUTS-课堂笔记
    设计模式:策略模式(转)
    java中的匿名内部类总结(转)
    struts2.0中Action的对象生命周期详解!!(转)
  • 原文地址:https://www.cnblogs.com/allenzhang/p/5194936.html
Copyright © 2020-2023  润新知