using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Data;
using?System.Data.SqlClient;

namespace?ReadTable
{
????class?Program
????{
????????static?void?Main（string[]?args）
????????{
????????????//連接數據庫字符串
????????????String?m_ConnString?=?@“Data?Source=QXL;?Initial?Catalog=教學管理;?User?ID=sa;?Password=123456“;
????????????//創建數據庫連接對象
????????????SqlConnection?conn?=?new?SqlConnection（m_ConnString）;
????????????//Sql語句，以查詢位列
????????????string?sql?=?“select?*?from?教師“;
????????????//打開數據庫連接
????????????conn.Open（）;

????????????//創建數據庫操作對象
????????????SqlCommand?cmd?=?new?SqlCommand（sqlconn）;
????????????//創建數據庫填充對象
????????????SqlDataAdapter?myda?=?new?SqlDataAdapter（cmd）;
????????????//創建數據集DataSet用來臨時存儲數據
????????????DataSet?ds?=?new?DataSet（）;
????????????//往ds里面添加數據
????????????myda.Fill（ds）;
????????????
????????????Console.WriteLine（ds.Tables[0].Rows[0][“姓名“]）;
????????????Console.ReadLine（）;?
????????????
????????}
????}
}
//SqlCommand?cmd?=?conn.CreateCommand（）;
//cmd.CommandText?=?@“SELECT?ID?UserName?PasswordEmail?
//????????????????????FROM?USERS?WHERE?UserName=@UserName?AND?Password=@Password“;
//cmd.CommandType?=?CommandType.Text;
//cmd.Parameters.Add（new?SqlParameter（“@UserName“userName））;
//cmd.Parameters.Add（new?SqlParameter（“@Password“password））;

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????5120??2010-09-18?10:28??SQLTest\ReadTable\ReadTable\bin\Debug\ReadTable.exe

?????文件??????13824??2010-09-18?10:28??SQLTest\ReadTable\ReadTable\bin\Debug\ReadTable.pdb

?????文件??????14328??2011-10-06?21:13??SQLTest\ReadTable\ReadTable\bin\Debug\ReadTable.vshost.exe

?????文件????????490??2007-07-21?01:33??SQLTest\ReadTable\ReadTable\bin\Debug\ReadTable.vshost.exe.manifest

?????文件????????417??2011-10-06?21:13??SQLTest\ReadTable\ReadTable\obj\Debug\ReadTable.csproj.FileListAbsolute.txt

?????文件???????5120??2010-09-18?10:28??SQLTest\ReadTable\ReadTable\obj\Debug\ReadTable.exe

?????文件??????13824??2010-09-18?10:28??SQLTest\ReadTable\ReadTable\obj\Debug\ReadTable.pdb

?????文件???????1537??2010-09-18?10:28??SQLTest\ReadTable\ReadTable\Program.cs

?????文件???????1374??2010-09-18?10:05??SQLTest\ReadTable\ReadTable\Properties\AssemblyInfo.cs

?????文件???????2491??2010-09-18?10:05??SQLTest\ReadTable\ReadTable\ReadTable.csproj

?????文件????????917??2010-09-18?10:05??SQLTest\ReadTable\ReadTable.sln

????..A..H.?????11264??2011-10-06?21:14??SQLTest\ReadTable\ReadTable.suo

?????文件??????22016??2012-03-05?11:18??SQLTest\SQLTest\bin\Debug\SQLTest.exe

?????文件??????40448??2012-03-05?11:18??SQLTest\SQLTest\bin\Debug\SQLTest.pdb

?????文件??????14328??2012-05-22?17:38??SQLTest\SQLTest\bin\Debug\SQLTest.vshost.exe

?????文件????????490??2009-06-11?05:14??SQLTest\SQLTest\bin\Debug\SQLTest.vshost.exe.manifest

?????文件??????13911??2012-03-05?11:55??SQLTest\SQLTest\Form1.cs

?????文件??????20943??2012-03-05?11:18??SQLTest\SQLTest\Form1.Designer.cs

?????文件???????5814??2012-03-05?11:18??SQLTest\SQLTest\Form1.resx

?????文件???????4036??2012-05-22?17:38??SQLTest\SQLTest\obj\Debug\SQLTest.csproj.FileListAbsolute.txt

?????文件????????847??2012-03-05?11:18??SQLTest\SQLTest\obj\Debug\SQLTest.csproj.GenerateResource.Cache

?????文件??????22016??2012-03-05?11:18??SQLTest\SQLTest\obj\Debug\SQLTest.exe

?????文件????????180??2012-03-05?11:18??SQLTest\SQLTest\obj\Debug\SQLTest.Form1.resources

?????文件??????40448??2012-03-05?11:18??SQLTest\SQLTest\obj\Debug\SQLTest.pdb

?????文件????????180??2012-03-05?11:18??SQLTest\SQLTest\obj\Debug\SQLTest.Properties.Resources.resources

?????文件????????488??2011-03-28?20:36??SQLTest\SQLTest\Program.cs

?????文件???????1370??2011-03-28?20:36??SQLTest\SQLTest\Properties\AssemblyInfo.cs

?????文件???????2864??2011-03-28?20:36??SQLTest\SQLTest\Properties\Resources.Designer.cs

?????文件???????5612??2011-03-28?20:36??SQLTest\SQLTest\Properties\Resources.resx

?????文件???????1092??2011-03-28?20:36??SQLTest\SQLTest\Properties\Settings.Designer.cs

............此處省略24個文件信息