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)
Top Level Statements in C#
C# Top-Level Statements vs. Main Method C# Top-Level Statements vs. Main Method In C# 9 and later, you can use ...
-
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...
-
Getting into Equation Mode use <alt> and = to get into the equation editor. Radicals : $\sum_{i=0}^n i^2 = \frac{(n^2+n)(2n+1)}{6}$ ...
No comments:
Post a Comment