先导入依赖吧
第一步编写数据连接驱动
private readonly string sqlconnection =
//数据源配置
@"Data Source=.;Initial Catalog=test;User Id=sa;Password=123456;";
第二步,装入驱动打开连接
//将驱动放进去打开连接
public SqlConnection OpenConnection()
{
SqlConnection connection = new SqlConnection(sqlconnection); //这里sqlconnection就是数据库连接字符串
//connection.Open();
return connection;
}
第三步执行sql语句
//利用点击事件打开连接,并且执行sql返回数据
private void button5_Click(object sender, EventArgs e)
{
SqlConnection sqlConnection = OpenConnection();
if (sqlConnection != null)
{
Console.WriteLine("连接成功");
}
//sql语句
string sql = "select * from MyUser";
//Query用了dynamic修饰其作用是动态绑定get,set
var result = sqlConnection.Query(sql).ToList();
//遍历
foreach (var item in result)
{ //注意点:这里不像Java需要getXxx直接.属性名就可以了
Console.WriteLine(item.name);
Console.WriteLine(item.age);
}
//
List<string> x = new List<string>();
x.Add("你好");
x.Add("你好啊");
x.Add("你好澳澳");
Console.WriteLine(x[0]);
}