[.net] .NET 코드 모음

//## Explicit
string query = string.Empty;     //쿼리문 초기화        
MySqlCommand cmd = null;
MySqlDataReader dr = null;
 
using( MySqlConnection conn = new MySqlConnection( Base.commDBString ) ) {
 
    conn.Open( ref cmd );
 
    //카운트
    query = " select * from TEST";
    cmd.Query( query );
    int rows = cmd.ExecuteScalar().ConInt();
 
    //페이지 설정
    int record_cnt = 10;     //한 페이지당 출력되는 게시물 수
    int block_cnt = 10;      //한 블록당 페이지 수
    Paging paging = new Paging( B.Page, rows, record_cnt, block_cnt );
    B.PageNum = paging.Num;
    paging_section.Text = paging.GetPaging();
 
    //내용을 불러온다.
    query = " select * from TEST";
    cmd.Query( query );
    cmd.Parameters.AddWithValue( "@paging_start", paging.GetStartNum() - 1 );
    cmd.Parameters.AddWithValue( "@paging_end", paging.GetEndNum() );
    dr = cmd.ExecuteReader();
 
    if( dr.HasRows ) {
 
        list_RT.DataSource = dr;
        list_RT.DataBind();
 
    } else {
 
        empty_tr.Visible = true;
 
    }
 
    dr.CloseDispose();
    conn.Close( ref cmd );
 
}
 
 
//카운트구하기
conn.Open( ref cmd );
 
query = " select count(A.NO) as COUNT from TEST";
cmd.Query( query );
int rows = cmd.ExecuteScalar().ConInt();
 
conn.Close( ref cmd );
 
 
 
//조회하기
conn.Open( ref cmd );
 
query = " select NO from TEST where MEMBER_ID = @member_id limit 1";
cmd.Query( query );
cmd.Parameters.AddWithValue( "@member_id", B.User.ID );
cmd.ExecuteReader().CloneStringDic( B.StrDic ).CloseDispose();
 
conn.Close( ref cmd );