C# Class LoginServer.Systems.MsSQL

Show file Open project: CarlosX/DarkEmu

Public Properties

Property Type Description
SQL string
cmd1 System.Data.SqlClient.SqlCommand
connection System.Data.SqlClient.SqlConnection
connection1 System.Data.SqlClient.SqlConnection
da System.Data.SqlClient.SqlDataAdapter
reader System.Data.SqlClient.SqlDataReader

Public Methods

Method Description
CharacterData ( string charname, string toGet ) : string
CharacterDataInt ( string charname, string toGet ) : int
Close ( ) : void
Connection ( string connections ) : void
Count ( ) : int
DeleteData ( string command ) : void
GetByte ( string column ) : byte
GetData ( string sql, string column ) : string
GetDataDouble ( string column ) : double
GetDataDouble ( string sql, string column ) : double
GetDataFloat ( string column ) : float
GetDataInt ( string sql, string column ) : int
GetDataLong ( string sql, string column ) : long
GetDouble ( string column ) : double
GetInt16 ( string column ) : short
GetInt32 ( string column ) : int
GetInt64 ( string column ) : long
GetRowsCount ( string command ) : int
GetSingle ( string column ) : float
GetString ( string column ) : string
InsertData ( string command ) : void
MsSQL ( string sql ) : System
Read ( ) : System.Data.SqlClient.SqlDataReader
UpdateData ( string command ) : void

Method Details

CharacterData() public static method

public static CharacterData ( string charname, string toGet ) : string
charname string
toGet string
return string

CharacterDataInt() public static method

public static CharacterDataInt ( string charname, string toGet ) : int
charname string
toGet string
return int

Close() public method

public Close ( ) : void
return void

Connection() public static method

public static Connection ( string connections ) : void
connections string
return void

Count() public method

public Count ( ) : int
return int

DeleteData() public static method

public static DeleteData ( string command ) : void
command string
return void

GetByte() public method

public GetByte ( string column ) : byte
column string
return byte

GetData() public static method

public static GetData ( string sql, string column ) : string
sql string
column string
return string

GetDataDouble() public method

public GetDataDouble ( string column ) : double
column string
return double

GetDataDouble() public static method

public static GetDataDouble ( string sql, string column ) : double
sql string
column string
return double

GetDataFloat() public method

public GetDataFloat ( string column ) : float
column string
return float

GetDataInt() public static method

public static GetDataInt ( string sql, string column ) : int
sql string
column string
return int

GetDataLong() public static method

public static GetDataLong ( string sql, string column ) : long
sql string
column string
return long

GetDouble() public method

public GetDouble ( string column ) : double
column string
return double

GetInt16() public method

public GetInt16 ( string column ) : short
column string
return short

GetInt32() public method

public GetInt32 ( string column ) : int
column string
return int

GetInt64() public method

public GetInt64 ( string column ) : long
column string
return long

GetRowsCount() public static method

public static GetRowsCount ( string command ) : int
command string
return int

GetSingle() public method

public GetSingle ( string column ) : float
column string
return float

GetString() public method

public GetString ( string column ) : string
column string
return string

InsertData() public static method

public static InsertData ( string command ) : void
command string
return void

MsSQL() public method

public MsSQL ( string sql ) : System
sql string
return System

Read() public method

public Read ( ) : System.Data.SqlClient.SqlDataReader
return System.Data.SqlClient.SqlDataReader

UpdateData() public static method

public static UpdateData ( string command ) : void
command string
return void

Property Details

SQL public property

public string SQL
return string

cmd1 public property

public SqlCommand,System.Data.SqlClient cmd1
return System.Data.SqlClient.SqlCommand

connection public static property

public static SqlConnection,System.Data.SqlClient connection
return System.Data.SqlClient.SqlConnection

connection1 public property

public SqlConnection,System.Data.SqlClient connection1
return System.Data.SqlClient.SqlConnection

da public static property

public static SqlDataAdapter,System.Data.SqlClient da
return System.Data.SqlClient.SqlDataAdapter

reader public property

public SqlDataReader,System.Data.SqlClient reader
return System.Data.SqlClient.SqlDataReader