可以的,假设你的数据库名称是DataBase,你要读取表Student的Name那一列,那么代码如下:
string conStr = "Data Source=.;Initial Catalog=DataBase;Integrated Security=True";
using (SqlConnection connection = new SqlConnection(conStr))
{
connection.Open();
using (SqlCommand cmd = connection.CreateCommand())
{
cmd.CommandText = "select Name from Student";
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
string name = reader.GetString(reader.GetOrdinal("Name"));
textbox1.Text=name;
}
}
}
}