34,593
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using System.Data.Common;
namespace ConsoleApplication12
{
class Program
{
static void Main(string[] args)
{
string connString = @"Data Source=.\sqlserver2005;Initial Catalog=master;Integrated Security=True";
string sql = @"SELECT TOP 3 number FROM [master].dbo.spt_values AS sv WHERE sv.[type]='P' ORDER BY NEWID()";
DataTable dt = new DataTable();
try
{
using (SqlConnection conn = new SqlConnection(connString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(dt);
Console.WriteLine("执行成功。");
}
Console.WriteLine("输出取得的数值:");
foreach (DataRow dr in dt.Rows)
{
Console.WriteLine(dr[0].ToString());
}
}
catch (Exception ex)
{
Console.WriteLine("执行失败:" + ex.Message);
}
Console.Read();
}
}
}