C# Class DarkEmu_GameServer.Systems.MsSQL

Show file Open project: CarlosX/DarkEmu Class Usage Examples

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
Close ( ) : void
Connection ( string connections ) : void
Count ( ) : int
DeleteData ( string command ) : void
GetData ( string sql, string column ) : string
GetDataDouble ( string sql, string column ) : double
GetDataInt ( string sql, string column ) : int
GetDataLong ( string sql, string column ) : long
GetRowsCount ( string command ) : int
InsertData ( string command ) : void
MsSQL ( string sql ) : System
Read ( ) : System.Data.SqlClient.SqlDataReader
UpdateData ( string command ) : void
Varsa ( string command ) : bool

Method Details

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

GetData() public static method

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

GetDataDouble() public static method

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

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

GetRowsCount() public static method

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

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

Varsa() public static method

public static Varsa ( string command ) : bool
command	string
return	bool

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