Редактирование, удаление, добавление данных в БД SQL

ChatGPT, Microsoft SQL

Onki, Хорошо, для работы с базой данных Microsoft SQL в C# мы можем использовать ADO.NET. Вот примеры кода для удаления, добавления и редактирования данных:

1. Удаление данных:

using System;
using System.Data.SqlClient;

public void DeleteData(int id)
{
string connectionString = "Data Source=YourServerName;Initial Catalog=YourDatabaseName;Integrated Security=True";
string query = "DELETE FROM YourTableName WHERE Id = @Id";

using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand(query, connection))
{
command.Parameters.AddWithValue("@Id", id);

connection.Open();
command.ExecuteNonQuery();
}
}
}

CSHARP

using System;

using System.Data.SqlClient;



public void DeleteData(int id)

{

    string connectionString = "Data Source=YourServerName;Initial Catalog=YourDatabaseName;Integrated Security=True";

    string query = "DELETE FROM YourTableName WHERE Id = @Id";



    using (SqlConnection connection = new SqlConnection(connectionString))

    {

        using (SqlCommand command = new SqlCommand(query, connection))

        {

            command.Parameters.AddWithValue("@Id", id);



            connection.Open();

            command.ExecuteNonQuery();

        }

    }

}

2. Добавление данных:

using System;
using System.Data.SqlClient;

public void InsertData(string name, int age)
{
string connectionString = "Data Source=YourServerName;Initial Catalog=YourDatabaseName;Integrated Security=True";
string query = "INSERT INTO YourTableName (Name, Age) VALUES (@Name, @Age)";

using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand(query, connection))
{
command.Parameters.AddWithValue("@Name", name);
command.Parameters.AddWithValue("@Age", age);

connection.Open();
command.ExecuteNonQuery();
}
}
}

CSHARP

using System;

using System.Data.SqlClient;



public void InsertData(string name, int age)

{

    string connectionString = "Data Source=YourServerName;Initial Catalog=YourDatabaseName;Integrated Security=True";

    string query = "INSERT INTO YourTableName (Name, Age) VALUES (@Name, @Age)";



    using (SqlConnection connection = new SqlConnection(connectionString))

    {

        using (SqlCommand command = new SqlCommand(query, connection))

        {

            command.Parameters.AddWithValue("@Name", name);

            command.Parameters.AddWithValue("@Age", age);



            connection.Open();

            command.ExecuteNonQuery();

        }

    }

}

3. Редактирование данных:

using System;
using System.Data.SqlClient;

public void UpdateData(int id, string name, int age)
{
string connectionString = "Data Source=YourServerName;Initial Catalog=YourDatabaseName;Integrated Security=True";
string query = "UPDATE YourTableName SET Name = @Name, Age = @Age WHERE Id = @Id";

using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand(query, connection))
{
command.Parameters.AddWithValue("@Id", id);
command.Parameters.AddWithValue("@Name", name);
command.Parameters.AddWithValue("@Age", age);

connection.Open();
command.ExecuteNonQuery();
}
}
}

CSHARP

using System;

using System.Data.SqlClient;



public void UpdateData(int id, string name, int age)

{

    string connectionString = "Data Source=YourServerName;Initial Catalog=YourDatabaseName;Integrated Security=True";

    string query = "UPDATE YourTableName SET Name = @Name, Age = @Age WHERE Id = @Id";



    using (SqlConnection connection = new SqlConnection(connectionString))

    {

        using (SqlCommand command = new SqlCommand(query, connection))

        {

            command.Parameters.AddWithValue("@Id", id);

            command.Parameters.AddWithValue("@Name", name);

            command.Parameters.AddWithValue("@Age", age);



            connection.Open();

            command.ExecuteNonQuery();

        }

    }

}

В этих примерах замени `YourServerName`, `YourDatabaseName` и `YourTableName` на соответствующие значения для твоей базы данных и таблицы. Также учти, что это только примеры, и тебе может потребоваться настроить код под свои нужды.

Если у тебя возникнут вопросы или нужна дополнительная помощь, не стесняйся задавать их. Я готов помочь!