C# insert into database

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();
    }
}

Source: stackoverflow.com

Similar codes

0 vote284 views2 answers
As keyword c#
C#
1 vote370 views1 answer
Undefined constant 'STDIN'
C#
0 vote349 views1 answer
Unpacking c # tuple
C#
2 votes344 views3 answers
Remove multiple items from list c#
C#
0 vote364 views1 answer
If vlaue exists don't enter event c#
C#
7 votes420 views1 answer
Built in methods to order a list c#
C#
14 votes342 views4 answers
One line condition c#
C#
0 vote346 views3 answers
Assets\PlayerMovement.cs(5,44): error CS1003: Syntax error, ',' expected
C#
0 vote346 views1 answer
Order by length descending C#
C#
1 vote321 views1 answer
C# how to refreshyour bindingsource
C#