1. 要在项目中添加一个基于服务的数据库或本地数据库文件;
2. 在代码执行开始先运行如下代码,否则数据库表中看不到执行的语句
string dataDir = AppDomain.CurrentDomain.BaseDirectory;
if(dataDir.EndsWith(@"\bin\Debug\") || dataDir.EndsWith(@"\bin\Release\"))
{
dataDir = System.IO.Directory.GetParent(dataDir).Parent.Parent.FullName;
AppDomain.CurrentDomain.SetData("DataDirectory", dataDir);
}
3. 定义连接字符串:@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True"
4. 编写程序:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
namespace 数据库1
{
class Program
{
static void Main(string[] args)
{
string dataDir = AppDomain.CurrentDomain.BaseDirectory;
if(dataDir.EndsWith(@"\bin\Debug\") || dataDir.EndsWith(@"\bin\Release\"))
{
dataDir = System.IO.Directory.GetParent(dataDir).Parent.Parent.FullName;
AppDomain.CurrentDomain.SetData("DataDirectory", dataDir);
}
string connStr=@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True";
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
string username = Convert.ToString(System.DateTime.Now.Millisecond);
cmd.CommandText = "insert into t_user (username,password) values ('" + username + "', '3333')";
cmd.ExecuteNonQuery();
Console.WriteLine("执行成功");
cmd.CommandText = "select * from t_user where username='" + username + "'";
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
string password = reader.GetString(reader.GetOrdinal("password"));
Console.WriteLine("用户: " + username + ", 密码: " + password);
}
else
{
Console.WriteLine("没有这个用户 " + username);
}
}
}
}
Console.ReadKey();
}
}
}