你的位置：首页 » 学习收藏 » 正文

C#技术学习之-DataReader到ListBox

选择字号：超大标准 发布时间：2008-9-28 9:19:5 | 作者：admin | 0个评论 | 人浏览

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Configuration;
using System.Xml;
namespace Mirror.AutoWeb.HelpCSharp.DataBase
{
/// <summary>
/// StudyDataReaderListBox 的摘要说明。
/// </summary>
public class StudyDataReaderListBox : System.Web.UI.Page
{
  protected System.Web.UI.WebControls.Literal Literal1;
  protected System.Web.UI.WebControls.Literal ScalarLabel;
  protected System.Web.UI.WebControls.ListBox ReaderList;
  protected System.Web.UI.WebControls.Literal Literal3;
  protected System.Web.UI.WebControls.Button AddOneBtn;
  protected System.Web.UI.WebControls.Button AddAllBtn;
  protected System.Web.UI.WebControls.Button DelOneBtn;
  protected System.Web.UI.WebControls.Button DelAllBtn;
  protected System.Web.UI.WebControls.ListBox ReaderListOther;
  protected System.Web.UI.WebControls.Literal SuccessMessage;
  protected System.Web.UI.WebControls.DropDownList DropDownList1;
  private readonly string connstr = ConfigurationSettings.AppSettings["MySQLConnString1"].ToString();
  private void Page_Load(object sender, System.EventArgs e)
  {
   if(!Page.IsPostBack)
   {
    ScalarLabel.Text = ExecuteScalarMySqlCommand().ToString();
    ExecuteXmlReaderMySqlCommand();
   }
  }

  private object ExecuteScalarMySqlCommand()
  {
   string cmdText = "Select Count(*) From Role";
   SqlConnection MyConn = new SqlConnection(connstr);
   SqlCommand MyCmd = new SqlCommand(cmdText,MyConn);
   MyConn.Open();
   object objectInfo = MyCmd.ExecuteScalar();
   MyConn.Close();
   return objectInfo;

  }
  private void ExecuteXmlReaderMySqlCommand()
  {
   string cmdText = "Select * From Role";
   SqlConnection MyConn = new SqlConnection(connstr);
   SqlCommand MyCmd = new SqlCommand(cmdText,MyConn);
   MyConn.Open();
   System.Data.SqlClient.SqlDataReader MyDataReader = MyCmd.ExecuteReader();
   this.ReaderList.Items.Clear();
   while(MyDataReader.Read())
   {
    ListItem List = new ListItem(MyDataReader["Role_Name"].ToString());
    //List.Attributes.Add("style","background-color:#EEEEEE");
    this.ReaderList.Items.Add(List);
    this.DropDownList1.Items.Add(List);
   }
   //this.ReaderList.Items[1].Attributes.Add("style","background-color:#EEEEEE");
   //this.DropDownList1.Items[1].Attributes.Add("style","background-color:#EEEEEE");
   int i;
   for(i=0;i<this.ReaderList.Items.Count;i++)
   {
    if((i%2)==0)
    {
     ReaderList.Items[i].Attributes.Add("style","background-color:#EEEEEE");
    }
   }
   MyConn.Close();

  }

  private void AddAndDeleteBtn_Command(object sender,System.Web.UI.WebControls.CommandEventArgs e)
  {
   string commandName = ((Button)sender).CommandName;
   //htm = htm&("命令："+commandName);
   switch(commandName.ToLower())
   {
    case "addone":
    {
     if(this.ReaderList.SelectedIndex>-1)
     {
      this.ReaderListOther.Items.Add(this.ReaderList.SelectedItem);
      SuccessMessage.Visible = false;
     }
     else
     {
      SuccessMessage.Visible = true;
     }
     break;
    }
    case "addall":
    {
     this.ReaderListOther.Items.Clear();
     foreach(ListItem item in this.ReaderList.Items)
     {
      this.ReaderListOther.Items.Add(item);
     }
     break;
    }
    case "delone":
    {
     if(this.ReaderListOther.SelectedIndex>-1)
     {
      this.ReaderListOther.Items.Remove(this.ReaderListOther.SelectedItem);
      SuccessMessage.Visible = false;
     }
     else
     {
      SuccessMessage.Visible = true;
     }
     break;
    }
    case "delall":
    {
     this.ReaderListOther.Items.Clear();
     break;
    }
    default:break;

   }
   this.ReaderList.SelectedIndex = -1;
   this.ReaderListOther.SelectedIndex = -1;

  }
  #region Web 窗体设计器生成的代码
  override protected void OnInit(EventArgs e)
  {
   //
   // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
   //
   InitializeComponent();
   base.OnInit(e);
  }

  /// <summary>
  /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  /// 此方法的内容。
  /// </summary>
  private void InitializeComponent()
  {
   this.AddAllBtn.Command += new System.Web.UI.WebControls.CommandEventHandler(this.AddAndDeleteBtn_Command);
   this.DelAllBtn.Command += new System.Web.UI.WebControls.CommandEventHandler(this.AddAndDeleteBtn_Command);
   this.DelOneBtn.Command += new System.Web.UI.WebControls.CommandEventHandler(this.AddAndDeleteBtn_Command);
   this.AddOneBtn.Command += new System.Web.UI.WebControls.CommandEventHandler(this.AddAndDeleteBtn_Command);
   this.Load += new System.EventHandler(this.Page_Load);

}
#endregion

}
}

标签：DataList ListBox C#

C#技术学习之-DataReader到ListBox

猜你喜欢

发表评论