using System;
using System.Data.SqlClient;
class Sample
{
static void Main()
{
string connectionString = "Server=tcp:yourserver.database.windows.net,1433;Database=yourdatabase;User ID=yourlogin@yourserver;Password={your_password_here};Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;";
using (var conn = new SqlConnection(connectionString))
{
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = @"
SELECT
c.CustomerID
,c.CompanyName
,COUNT(soh.SalesOrderID) AS OrderCount
FROM SalesLT.Customer AS c
LEFT OUTER JOIN SalesLT.SalesOrderHeader AS soh ON c.CustomerID = soh.CustomerID
GROUP BY c.CustomerID, c.CompanyName
ORDER BY OrderCount DESC;";
conn.Open();
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
Console.WriteLine("ID: {0} Name: {1} Order Count: {2}", reader.GetInt32(0), reader.GetString(1), reader.GetInt32(2));
}
}
}
}
using (var conn = new SqlConnection(connectionString))
{
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = @"
INSERT SalesLT.Product (Name, ProductNumber, StandardCost, ListPrice, SellStartDate)
OUTPUT INSERTED.ProductID
VALUES (@Name, @Number, @Cost, @Price, CURRENT_TIMESTAMP)";
cmd.Parameters.AddWithValue("@Name", "SQL Server Express");
cmd.Parameters.AddWithValue("@Number", "SQLEXPRESS1");
cmd.Parameters.AddWithValue("@Cost", 0);
cmd.Parameters.AddWithValue("@Price", 0);
conn.Open();
int insertedProductId = (int)cmd.ExecuteScalar();
Console.WriteLine("Product ID {0} inserted.", insertedProductId);
}
}
}
}
C# Microsoft SQL 带参数例子
于 2022-05-08 22:04:01 首次发布