messageManagement/send_M.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

namespace Eclipse.HRM.UI.messageManagement
{
    public partial class send_M : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                //BindGridView(DropReceiver);
                //TxtSender.Text = Session["S_name"];
            }
        }
        static public void BindGridView(DropDownList d)
        {
            d.DataSource = QueryForDptDataSet();
            d.DataTextField = "S_name";
            d.DataValueField = "S_ID";
            d.DataBind();
        }
        static private DataSet QueryForDptDataSet()
        {
            String strConn = "Data Source=.;Initial Catalog=Eclipse_HRM;Persist Security Info=True;User ID=sa;Password=51Aspx";
            SqlConnection conn = new SqlConnection(strConn);
            String strSql = "SELECT * FROM stafflist ORDER BY S_ID DESC";
            SqlCommand command = new SqlCommand(strSql, conn);
            SqlDataAdapter sda = new SqlDataAdapter(command);
            DataSet ds = new DataSet();
            sda.Fill(ds);
            return ds;
        }

        protected void Button1_Click(object sender, EventArgs e)
        {

        
        
        }
    }
}