Wednesday, April 22, 2020

Reading from SQL server and assigning the value to a variable in a custom class.

using System;
using System.Data.SqlClient;

namespace CSharpConnectToSQLServer
{
    class Program
    {
        static void Main(string[] args)
        {
            dboFrank result = new dboFrank();
            Console.WriteLine("Hello World!");
            string connetionString = null;
            SqlConnection cnn;
            connetionString = @"Server = JOHN-PC\TEW_SQLEXPRESS; Database=myDB; Trusted_Connection=Yes;";
            cnn = new SqlConnection(connetionString);
            try
            {
                cnn.Open();
                Console.WriteLine("Connection Open ! ");
                SqlCommand command = new SqlCommand("SELECT PersonID, LastName, LargeNumber FROM dbo.Frank",cnn);
                SqlDataReader reader = command.ExecuteReader();
                while (reader.Read())
                {
                    result.LastName = reader["LastName"] as string;
                    Console.WriteLine("the last name is: " + result.LastName);
                }
            }
            catch (Exception ex)
            { 
                Console.WriteLine("Can not open connection ! " + ex.Message);
            }
            Console.ReadLine();
        }
    }

    public class dboFrank
    {
        public int PersonID { get; set; }
        public string LastName { get; set; }
        public double LargeNumber { get; set; }
    }
}




No comments:

Post a Comment

Cocktail Jazz for Beginners

  https://pianowithjonny.com/piano-lessons/how-to-play-beginner-cocktail-piano-in-3-steps/ https://www.pianogroove.com/jazz-piano-lessons/co...