Question

C#连接数据库，用DataGridview ，显示数据表，对表内容进行删除，添加，修改

Answer 1

using System.Data;
using System.Data.SqlClient;
//需要添加这两个引用
string SqlConStr = "Server=servername;database=Test;user id=userId;password=password;";
string sqlString="select * from V-test;";
SqlConnection SqlCnt = new SqlConnection(SqlConStr);
SqlCnt.Open();
SqlCommand SqlCmd = SqlCnt.CreateCommand();
SqlCmd.CommandType = CommandType.Text;
SqlCmd.CommandText = sqlString;
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(SqlCmd);
DataSet sqlDataSet = new DataSet();
sqlDataAdapter.Fill(sqlDataSet);
DataTable MyTable = sqlDataSet.Tables[0];
SqlCnt.Close();
SqlCnt.Dispose();这段代码执行完后，MyTable
就是执行了"select
*
from
V-test;"语句后返回的结果集