GridView绑定功能的实现

方法一

1. VIEW层

//====================================================================================
/// <summary>
/// 将UserInfo的相关内容绑定到GridView上
/// </summary>
/// <returns></returns>
/// <originated>Shawn Qiu</originated>
/// <date>2010-04-01</date>
private void ShowUserInfo2GridView()
{
    try
    {
        connection = SqlDBHelper.GetNewSqlConnection(DB.ConnectionString);
        BT_TW_UserInfo.ShowUserInfo2GridView(connection, gv_UserInfoList);
        if (gv_UserInfoList.Rows.Count == 0)
        {
            gv_UserInfoList.Visible = false;
        }
        else
        {
            gv_UserInfoList.Visible = true;
        }

    }
    catch (Exception ex)
    {
        ShowMsg(ex.ToString());
    }
    finally
    {
        SqlDBHelper.Close(connection);
    }

}

2. BUSINESS层

//====================================================================================
/// <summary>
/// 将UserInfo表中所有的数据显示在DBGrid中
/// </summary>
/// <returns></returns>
/// <originated>Shawn Qiu</originated>
/// <date>2010-04-01</date>
public static void ShowUserInfo2GridView(SqlConnection connection, GridView gv_UserInfoList)
{
    string sql = SQL_UserInfo_Select_Union();

    SqlDataAdapter daUserInfo = new SqlDataAdapter(sql, connection);
    DataSet dsUserInfo = new DataSet();
    daUserInfo.Fill(dsUserInfo, MT_TW_UserInfo.TableName);

    DataView dvUserInfo = new DataView();
    dvUserInfo.Table = dsUserInfo.Tables[MT_TW_UserInfo.TableName];

    DataTable tb_UserInfo = new DataTable("tb_UserInfo");

    tb_UserInfo.Columns.Add(new DataColumn(MT_TW_UserInfo.FldName.UserID, typeof(int)));
    tb_UserInfo.Columns.Add(new DataColumn(MT_TW_UserInfo.FldName.UserName, typeof(String)));
    tb_UserInfo.Columns.Add(new DataColumn(MT_TW_RoleInfo.FldName.RoleName, typeof(String)));
    tb_UserInfo.Columns.Add(new DataColumn(MT_TW_UserInfo.FldName.UserMemo, typeof(String)));

    foreach (DataRowView drvUserInfoTemp in dvUserInfo)
    {
        DataRow drUserInfoTemp = tb_UserInfo.NewRow();
        drUserInfoTemp = GettbRow_FromRowViewOfUserInfo(drvUserInfoTemp, tb_UserInfo);
        tb_UserInfo.Rows.Add(drUserInfoTemp);
    }

    if (tb_UserInfo.Rows.Count > 0)
    {
        gv_UserInfoList.DataSource = tb_UserInfo;
        gv_UserInfoList.DataBind();
    }
    else
    {
        DataTable dt_Empty = new DataTable();
        gv_UserInfoList.DataSource = dt_Empty.DefaultView;
        gv_UserInfoList.DataBind();
    }

}// end of Function:ShowUserInfo2GridView(SqlConnection connection, GridView gv_UserInfoList)

//====================================================================================
/// <summary>
/// 构造Select的基本数据的SQL语句
/// </summary>
/// <returns>SQL语句</returns>
/// <originated>Shawn Qiu</originated>
/// <date>2010-04-01</date>
private static string SQL_UserInfo_Select_Union()
{
    return string.Format(@"SELECT userid,username,rolename,usermemo FROM t_tw_UserInfo,t_tw_RoleInfo WHERE t_tw_UserInfo.userrole=t_tw_RoleInfo.RoleID ORDER BY userid ASC");

}//end of Function:SQL_UserInfo_Select_Union()

3. 其他函数

//====================================================================================
/// <summary>
/// 根据DataView行记录返回DataTable的一行
/// </summary>
/// <returns>DataRow</returns>
/// <originated>Shawn Qiu</originated>
/// <date>2010-04-01</date>
private static DataRow GettbRow_FromRowViewOfUserInfo(DataRowView drvUserInfo, DataTable tb_UserInfo)
{
    DataRow drUserInfoTemp = tb_UserInfo.NewRow();

    drUserInfoTemp["UserID"] = Convert.ToInt32(drvUserInfo[MT_TW_UserInfo.FldName.UserID].ToString());
    drUserInfoTemp["UserName"] = drvUserInfo[MT_TW_UserInfo.FldName.UserName].ToString();
    drUserInfoTemp["RoleName"] = drvUserInfo[MT_TW_RoleInfo.FldName.RoleName].ToString();
    drUserInfoTemp["UserMemo"] = drvUserInfo[MT_TW_UserInfo.FldName.UserMemo].ToString();

    return drUserInfoTemp;

}//end of Function:GettbRow_FromRowViewOfUserInfo(DataRowView drvUserInfo, DataTable tb_UserInfo)

方法二
1. VIEW层

//====================================================================================
/// <summary>
/// 将SubjectInfo的相关内容绑定到GridView上
/// </summary>
/// <returns></returns>
/// <originated>Shawn Qiu</originated>
/// <date>2010-05-28</date>	
private void ShowSubjectInfo2GridView()
{
    try
    {
        connection = SqlDBHelper.GetNewSqlConnection(DB.ConnectionString);
        BT_TW_SubjectInfo.ShowSubjectInfo2GridView(connection, gv_SubjectInfoList);
        if (gv_SubjectInfoList.Rows.Count == 0)
        {
            gv_SubjectInfoList.Visible = false;
        }
        else
        {
            gv_SubjectInfoList.Visible = true;
        }

    }
    catch (Exception ex)
    {
        ShowMsg(ex.ToString());
    }
    finally
    {
        SqlDBHelper.Close(connection);
    }

}//end of Function;ShowSubjectInfo2GridView()

2. BUSINESS层

//====================================================================================
/// <summary>
/// 将SubjectInfo表中所有的数据显示在DBGrid中
/// </summary>
/// <returns></returns>
/// <originated>Shawn Qiu</originated>
/// <date>2010-05-28</date>
public static void ShowSubjectInfo2GridView(SqlConnection connection, GridView gv_SubjectInfoList)
{
    string sql = SQL_SubjectInfo_Select();

    SqlDataAdapter daSubjectInfo = new SqlDataAdapter(sql, connection);
    DataSet dsSubjectInfo = new DataSet();
    daSubjectInfo.Fill(dsSubjectInfo, MT_TW_SubjectInfo.TableName);

    DataView dvSubjectInfo = new DataView();
    dvSubjectInfo.Table = dsSubjectInfo.Tables[MT_TW_SubjectInfo.TableName];

    if (dvSubjectInfo.Count > 0)
    {
        gv_SubjectInfoList.DataSource = dvSubjectInfo;
        gv_SubjectInfoList.DataBind();
    }
    else
    {
        DataTable dt_Empty = new DataTable();
        gv_SubjectInfoList.DataSource = dt_Empty.DefaultView;
        gv_SubjectInfoList.DataBind();
    }

}// end of Function:ShowSubjectInfo2GridView(SqlConnection connection, GridView gv_SubjectInfoList)
        
//====================================================================================
/// <summary>
/// 构造Select的基本数据的SQL语句（升序）
/// </summary>
/// <returns>SQL语句</returns>
/// <originated>Shawn Qiu</originated>
/// <date>2010-05-28</date>
private static string SQL_SubjectInfo_Select()
{
    return string.Format(@"SELECT subjectid,subjectinfo,subjectlv1,subjectlv2,subjectmemo FROM t_tw_subjectinfo ORDER BY subjectid ASC");

}//end of Function:SQL_SubjectInfo_Select()