111,120
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Security;
using System.Security.Principal;
using System.Security.Cryptography;
using System.Text;
public interface IHous
{
/// <summary>
/// 获取机房详细信息
/// </summary>
/// <returns></returns>
SqlDataReader GetHousList();
}
/// <summary>
/// User 的摘要说明
/// </summary>
public class Hous : IHous
{
private static readonly string GETHOUS = "SELECT * FROM V_HOUS";
public Hous()
{
///
}
public SqlDataReader GetHousList()
{
///创建链接
SqlConnection myConnection = new SqlConnection(
ConfigurationManager.ConnectionStrings["SQLCONNECTIONSTRING"].ConnectionString);
///定义SQL语句
string cmdText = GETHOUS;
///创建Command
SqlCommand myCommand = new SqlCommand(cmdText, myConnection);
///定义DataReader
SqlDataReader dr = null;
try
{
///打开链接
myConnection.Open();
///读取数据
dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (SqlException ex)
{
///抛出异常vbg
throw new Exception(ex.Message, ex);
}
///返回DataReader
return dr;
}
}
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class UserManage : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if(!Page.IsPostBack)
{
BindUserData();
}
}
private void BindUserData()
{
///获取用户数据
IHous hous = new Hous();
SqlDataReader dr = hous.GetHousList();
///设置GridView的数据源,并绑定数据
UserView.DataSource = dr;
UserView.DataBind();
///关闭数据读取器
dr.Close();
}