C#

rehab1 wrote:

but sql server is not supporting the unicode

try
{
    connection.Open() ;

    MySqlCommand command = new MySqlCommand
    (
        "INSERT INTO test(itemcode,description,quantity,unit) VALUES (@itemcode,@description,@quantity,@unit)"
    , 
        connection
    ) ;
    
    foreach ( DataGridViewColumn col in dataGridView4.Columns )
    {
        command.Parameters.Add ( new MySqlParameter ( "@" + col.DataPropertyName , col.ValueType ) ;
    }

    command.Transaction = connection.BeginTransaction() ;

    foreach(DataGridViewRow row in dataGridView4.Rows)
    {
        foreach ( DataGridViewCell cel in row.Cells )
        {
            command.Parameters [ "@" + cel.DataPropertyName ].Value = cel.Value ;
        }

        command.ExecuteNonQuery() ;
    }

    command.Transaction.Commit ;
}
catch ( MySqlException mse ) 
{ 
    command.Transaction.Rollback ;
    MessageBox.Show ( mse.Message ) ;
}
finally
{
    connection.Close() ;
}

balanjingot wrote:

String query = "INSERT INTO test(itemcode,description,quantity,unit) VALUES (itemcode,description,quantity,unit)";