MKEEITTOPSUPERMENT.mkeitsuperment
1.0.0
dotnet add package MKEEITTOPSUPERMENT.mkeitsuperment --version 1.0.0
NuGet\Install-Package MKEEITTOPSUPERMENT.mkeitsuperment -Version 1.0.0
<PackageReference Include="MKEEITTOPSUPERMENT.mkeitsuperment" Version="1.0.0" />
<PackageVersion Include="MKEEITTOPSUPERMENT.mkeitsuperment" Version="1.0.0" />
<PackageReference Include="MKEEITTOPSUPERMENT.mkeitsuperment" />
paket add MKEEITTOPSUPERMENT.mkeitsuperment --version 1.0.0
#r "nuget: MKEEITTOPSUPERMENT.mkeitsuperment, 1.0.0"
#:package MKEEITTOPSUPERMENT.mkeitsuperment@1.0.0
#addin nuget:?package=MKEEITTOPSUPERMENT.mkeitsuperment&version=1.0.0
#tool nuget:?package=MKEEITTOPSUPERMENT.mkeitsuperment&version=1.0.0
ПОДКЛЮЧЕНИЕ
static string connectionString = @"database = upzad2; datasource = localhost;
user = root; password = qwerty;
charset = utf8mb4";
public static MySqlConnection myConnect;
public static MySqlCommand myCommand;
public static MySqlDataAdapter myDataAdapter;
public static MySqlDataReader myReader;
static public bool ConnectBD()
{
try
{
myConnect = new MySqlConnection(connectionString);
myConnect.Open();
myCommand = new MySqlCommand();
myCommand.Connection = myConnect;
myDataAdapter = new MySqlDataAdapter(myCommand);
return true;
}
catch
{
return false;
}
}
static public bool CloseBD()
{
try
{
myConnect.Close();
return true;
}
catch
{
return false;
}
}
ВЫВОД
static public DataTable dtTable = new DataTable();
static public void ViewTable()
{
try
{
DBConnection.myCommand.CommandText = "select * from table";
dtTable.Clear();
DBConnection.myDataAdapter.Fill(dtTable);
}
catch (MySqlException err)
{
MessageBox.Show("Ошибка при просмотре записей!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
static public bool SCUDAction(string field, int field2)
{
try
{
DBConnection.myCommand.CommandText = "query;";
if (DBConnection.myCommand.ExecuteNonQuery() > 0)
{
MessageBox.Show("Действие успешно!");
return true;
}
else
{
MessageBox.Show("Действие неуспешно!");
return false;
}
}
catch (Exception err)
{
MessageBox.Show("Ошибка при действии!");
return false;
}
}
// DELETE: обработать err.Number == 1451
// DUPLICATE: обработать err.Number == 1062
РАБОТА С USERCONTROL
public static bool GetInfo(FlowLayoutPanel panel)
{
try
{
panel.Controls.Clear();
DBConnection.myCommand.CommandText = "select * from table";
DBConnection.myReader = DBConnection.myCommand.ExecuteReader();
while (DBConnection.myReader.Read())
{
Usercontrol usercontrol1 = new Usercontrol(DBConnection.myReader["Field"].ToString());
panel.Controls.Add(usercontrol1);
}
DBConnection.myReader.Close();
return true;
}
catch (Exception e)
{
MessageBox.Show("Ошибка получения информации!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
return false;
}
}
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET Framework | net471 is compatible. net472 was computed. net48 was computed. net481 was computed. |
This package has no dependencies.
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
| Version | Downloads | Last Updated |
|---|---|---|
| 1.0.0 | 125 | 4/17/2026 |