public static SqlConnection GetDBConnection()
{
string datasource = @"DESKTOP-5QPRQC5\SQLEXPRESS";
string database = "BizappsTest";
return(DBSQLServerUtils.GetDBConnection(datasource, database));
}
public static SqlConnection GetDBConnection()
{
string datasource = @"laptop-j5h40kmv";
string database = "Year2";
return(DBSQLServerUtils.GetDBConnection(datasource, database));
}
public static SqlConnection GetDBConnection()
{
string datasource = @"DESKTOP-5TGIQQC\SQLEXPRESS";
string database = "RG_database";
string username = "******";
string password = "******";
return(DBSQLServerUtils.GetDBConnection(datasource, database, username, password));
}
public static SqlConnection GetDBConnection()
{
string datasource = @"IP\SQLEXPRESS";
string database = "simplehr";
string username = "******";
string password = "******";
return DBSQLServerUtils.GetDBConnection(datasource, database, username, password);
}
public static SqlConnection GetDBConnection()
{
string datasource = @"127.0.0.1";
string database = "PolitDV";
string username = "******";
string password = "******";
return(DBSQLServerUtils.GetDBConnection(datasource, database, username, password));
}
public static SqlConnection GetDBConnection()
{
string datasource = @"DESKTOP-RPK6PAD\SQLEXPRESS";
string database = "QuanLyBanHang";
string username = "******";
string password = "******";
return(DBSQLServerUtils.GetDBConnection(datasource, database, username, password));
}
static void Main(string[] args)
{
SqlConnection connection = DBSQLServerUtils.GetDBConnection();
connection.Open();
try
{
// Команда Insert.
string sql = "Insert into Salary_Grade (Grade, High_Salary, Low_Salary) "
+ " values (@grade, @highSalary, @lowSalary) ";
SqlCommand cmd = connection.CreateCommand();
cmd.CommandText = sql;
// Создать объект Parameter.
SqlParameter gradeParam = new SqlParameter("@grade", SqlDbType.Int);
gradeParam.Value = 3;
cmd.Parameters.Add(gradeParam);
// Добавить параметр @highSalary (Написать короче).
SqlParameter highSalaryParam = cmd.Parameters.Add("@highSalary", SqlDbType.Float);
highSalaryParam.Value = 20000;
// Добавить параметр @lowSalary (Написать короче).
cmd.Parameters.Add("@lowSalary", SqlDbType.Float).Value = 10000;
// Выполнить Command (Используется для delete, insert, update).
int rowCount = cmd.ExecuteNonQuery();
Console.WriteLine("Row Count affected = " + rowCount);
}
catch (Exception e)
{
Console.WriteLine("Error: " + e);
Console.WriteLine(e.StackTrace);
}
finally
{
connection.Close();
connection.Dispose();
connection = null;
}
Console.Read();
}