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; }
}
}
Wednesday, April 22, 2020
Reading from SQL server and assigning the value to a variable in a custom class.
Subscribe to:
Post Comments (Atom)
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...
-
In a regular annotation note, create a stack that looks the way you like. It will take a couple of trial and error attempts since there...
-
I just finished a 1 hour marketing meeting with an organization that I volunteer with. They are trying to create an new website and the look...
No comments:
Post a Comment