C#操作Sql Server(読み出し)
1320 ワード
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[cols];
while (sdr.Read())
{
sdr.GetValues(values); //values
for (int i = 0; i < values.Length; i++)
{
Console.Write(values[i].ToString() + " ");
}
Console.WriteLine();
}
sdr.Close();
conn.Close();
}
}
}