Add row To SqlConnection - CSharp System.Data.SqlClient

CSharp examples for System.Data.SqlClient:SqlConnection

  1. HOME
  2. CSharp
  3. System.Data.SqlClient
  4. SqlConnection

Description

Add row To SqlConnection

Demo Code


using System.Web;
using System.Linq;
using System.Data.SqlClient;
using System.Data;
using System.Collections.Generic;
using System;//from w  ww  . ja  v a2s  . co  m

public class Main{
        public static void AddToLog(string action)
        {
            try
            {
                SqlConnection sqlConnection1 = new SqlConnection("Server=tcp:plps.database.windows.net,1433;Initial Catalog=PLPS;Persist Security Info=False;User ID=tomasoft;Password=Tomason18,;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;");
                SqlCommand cmd = new SqlCommand();
                SqlDataReader reader;

                cmd.CommandText = "INSERT INTO t (Tresc) VALUES ('" + action + " " + DateTime.Now.ToString() + "')";
                cmd.CommandType = CommandType.Text;
                cmd.Connection = sqlConnection1;

                sqlConnection1.Open();
                cmd.ExecuteNonQuery();

                sqlConnection1.Close();
            }
            catch (Exception ex)
            {
                SqlConnection sqlConnection1 = new SqlConnection("Server=tcp:plps.database.windows.net,1433;Initial Catalog=PLPS;Persist Security Info=False;User ID=tomasoft;Password=Tomason18,;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;");
                SqlCommand cmd = new SqlCommand();
                SqlDataReader reader;

                cmd.CommandText = "INSERT INTO t (Tresc) VALUES ('" + "Blad dodawania wiadomosci do Loga" + " " + DateTime.Now.ToString() +" "+ex.Message.ToString()+ "')";
                cmd.CommandType = CommandType.Text;
                cmd.Connection = sqlConnection1;

                sqlConnection1.Open();
                cmd.ExecuteNonQuery();

                sqlConnection1.Close();
            }
        }
}

Related Tutorials