Breaking News: Grepper is joining You.com. Read the official announcement!

C# insert into database

dr4ft answered on January 7, 2021 Popularity 10/10 Helpfulness 9/10

answer C# insert into database

related c# sql insert into table

C# insert into database

Comment

using(var connection = new SqlConnection("connectionString"))
{
    connection.Open();
    var sql = "INSERT INTO Main(FirstName, SecondName) VALUES(@FirstName, @SecondName)";
    using(var cmd = new SqlCommand(sql, connection))
    {
        cmd.Parameters.AddWithValue("@FirstName", txFirstName.Text);
        cmd.Parameters.AddWithValue("@SecondName", txSecondName.Text);

        cmd.ExecuteNonQuery();
    }
}

Popularity 10/10 Helpfulness 9/10 Language csharp

Source: stackoverflow.com

Tags: c# database insert-into

Link to this answer
Share Copy Link

Contributed on Jan 07 2021

dr4ft

0 Answers Avg Quality 2/10

Closely Related Answers

c# sql insert into table

Comment

using System.Data.SqlClient;

// create a connection to the database
string connectionString = "Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=True";
SqlConnection connection = new SqlConnection(connectionString);

// define the query with parameters
string query = "INSERT INTO myTable (column1, column2) VALUES (@value1, @value2)";

// create a new SqlCommand object with the query and connection
SqlCommand command = new SqlCommand(query, connection);

// set the parameter values
command.Parameters.AddWithValue("@value1", "some value");
command.Parameters.AddWithValue("@value2", 123);

// open the connection to the database
connection.Open();

// execute the command
int rowsAffected = command.ExecuteNonQuery();

// close the connection
connection.Close();

myServerAddress and myDataBase should be replaced with the appropriate values for your database. The column1 and column2 values should be replaced with the names of the columns you are inserting data into. The @value1 and @value2 placeholders are the parameter names used in the query and should match the names used when setting the parameter values.

Popularity 9/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: c# sql sq

Link to this answer
Share Copy Link

Contributed on Mar 05 2023

SubZero

0 Answers Avg Quality 2/10

C# insert into database

Contents

More Related Answers

C# insert into database

Closely Related Answers

c# sql insert into table

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.