hey guys im editing a released source and iam trying to make SQL connection
read from config.cfg file but when i do it like this
PHP Code:
public static SqlConnection con = new SqlConnection(@"Server="+sqlCon.server+";Database="+sqlCon.db+";User Id="+sqlCon.id+";Password="+sqlCon.pw+";MultipleActiveResultSets=True;Trusted_Connection=true");
and config.cfg like this
PHP Code:
[Connection]
IP=127.0.0.1
LoginPort=15779
Locale=22
Version=188
[Client]
Username=gm123
Password=gm123
CharName=[GM]BOT
Captcha=0
[SQL]
ServerName=WIN-123WIN\SQLEXPRESS
id=sa
pw=123456
db=LOG_DB
it wont work
Full sqlCon.cs
PHP Code:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Threading.Tasks;
using System.Data.SqlClient;
namespace Yuri
{
public static class sqlCon
{
public static string server = "";
public static string db = "";
public static string id = "";
public static string pw = "";
public static SqlConnection con = new SqlConnection(@"Server="+sqlCon.server+";Database="+sqlCon.db+";User Id="+sqlCon.id+";Password="+sqlCon.pw+";MultipleActiveResultSets=True;Trusted_Connection=true");
public static void ChangeDB(string DBName)
{
try
{
switch (DBName)
{
case "Acc":
con.ChangeDatabase("SRO_VT_ACCOUNT");
break;
case "Shard":
con.ChangeDatabase("SRO_VT_SHARD");
break;
case "Log":
con.ChangeDatabase("LOG_DB");
break;
case "Event":
con.ChangeDatabase("Yuri");
break;
}
}
catch (Exception ex)
{
Console.WriteLine("ChangeDB function has some errors." + ex.ToString());
}
}
public static void exec(string query)
{
try
{
SqlCommand com = new SqlCommand(query, con);
com.ExecuteNonQuery();
}
catch (SqlException Ex)
{
Agent.TypeLog("MSSQL Error -> Function exec(" + query + "), exception catched : " + Ex.ToString());
}
}
//read string
public static string ReadString(string query)
{
string strResult = null;
try
{
SqlCommand com = new SqlCommand(query, con);
com.CommandType = CommandType.Text;
strResult = (string)com.ExecuteScalar();
}
catch (SqlException Ex)
{
Agent.TypeLog("MSSQL Error -> Function ReadString(" + query + "), exception catched : " + Ex.ToString());
}
return strResult;
}
public static int ReadInt(string query)
{
int nResult = 0;
try
{
SqlCommand com = new SqlCommand(query, con);
com.CommandType = CommandType.Text;
nResult = (int)com.ExecuteScalar();
}
catch (SqlException Ex)
{
Agent.TypeLog("MSSQL Error -> Function ReadInt(" + query + "), exception catched : " + Ex.ToString());
}
return nResult;
}
public static string[] getSingleArray(string query)
{
try
{
SqlDataAdapter SqlAD = new SqlDataAdapter();
SqlAD.SelectCommand = new SqlCommand(query, con);
DataSet ds = new DataSet();
SqlAD.Fill(ds);
DataTable dt = ds.Tables[0];
if(dt.Rows.Count != 0)
{
string[] arr = new string[dt.Rows[0].ItemArray.Length];
arr = InitializeArrays.InitStringArray(arr);
DataRow row = dt.Rows[0]; //first array
for (int i = 0; i < dt.Rows[0].ItemArray.Length; i++)
{
arr[i] = row[i].ToString();
}
return arr;
}
}
catch (SqlException Ex)
{
Agent.TypeLog("MSSQL Error -> Function getStringArray(" + query + "), exception catched : " + Ex.ToString());
}
return null;
}
}
}
config.cs
PHP Code:
sqlCon.server = cfg.IniReadValue("SQL", "ServerName");
sqlCon.id = cfg.IniReadValue("SQL", "id");
sqlCon.pw = cfg.IniReadValue("SQL", "pw");
sqlCon.db = cfg.IniReadValue("SQL", "db");
any hint how to make it read server name from the .cfg ?
****************
but like this it works
PHP Code:
public static SqlConnection con = new SqlConnection(@"Server=WIN-123WIN\SQLEXPRESS"+sqlCon.db+sqlCon.id+sqlCon.pw+"; MultipleActiveResultSets=True;Trusted_Connection=true");
