24 lines
736 B
C#
24 lines
736 B
C#
|
using System.Data;
|
|||
|
|
using Microsoft.Data.SqlClient;
|
|||
|
|
using Test;
|
|||
|
|
|
|||
|
|
namespace SQLServerTest
|
|||
|
|
{
|
|||
|
|
internal class Program
|
|||
|
|
{
|
|||
|
|
static void Main(string[] args)
|
|||
|
|
{
|
|||
|
|
|
|||
|
|
string sssql = @"select B.ID HotelID,B.Code,A.RoomNumber,A.HostNumber,A.LanIP,A.LanPort,A.ID from tb_Hosts A
|
|||
|
|
inner join tb_Sys_Hotels B
|
|||
|
|
on A.HotelID=B.ID
|
|||
|
|
where MAC=@MAC;";
|
|||
|
|
|
|||
|
|
var sql = new SqlParameter("@MAC", "aa-bb-cc");
|
|||
|
|
DataTable dt = SQLServerDBHelper.GetTable(sssql, new SqlParameter[] { sql });
|
|||
|
|
Console.WriteLine("Hello, World!");
|
|||
|
|
Console.ReadKey();
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|