C#操作Sql Server（读取）
using System;using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace SqlServerTest
{
class Program
{
static void Main(string[] args)
{
string strDataBase = "Server=.;DataBase=Test;Uid=sa;pwd=admin12345;";
SqlConnection conn = new SqlConnection(strDataBase);
string sqlStatement = "select * from Table_1";
SqlCommand sqlcmd = new SqlCommand(sqlStatement, conn); //设置参数
conn.Open();
SqlDataReader sdr = sqlcmd.ExecuteReader(); //执行SQL语句
int cols = sdr.FieldCount; //获取结果行中的列数
object[] values = new object;
while (sdr.Read())
{
sdr.GetValues(values); //values保存一行数据
for (int i = 0; i < values.Length; i++)
{
Console.Write(values.ToString() + " ");
}
Console.WriteLine();
}
sdr.Close();
conn.Close();
}
}
}
页:
[1]