不知道为什么总是出错
private void Button_Click(object sender, RoutedEventArgs e)
{
// int result = -2;
// DbManager manager = new DbManager();
// result = manager.ExecuteNonQuery("INSERT INTO Password (ID, User,password) VALUES (0,\"Magnus\", 27)");
// C:\Project Code\C#\HotelMangementSystem(WPF)\HotelMangementSystem(WPF)\DataBase\HotelMangermentDataBase.sqlite
// SQLiteConnection sqlite_conn = new SQLiteConnection("Data Source=C:/Project Code/C#/HotelMangementSystem(WPF)/HotelMangementSystem(WPF)/DataBase/HotelMangermentDataBase.sqlite;");
SQLiteConnection conn = new SQLiteConnection("Data Source=DataBase/HotelMangermentDataBase.sqlite.sqlite;");
conn.Open();
SQLiteCommand cmd = conn.CreateCommand();
}
点击就出错 ，是不是连接的字符串有问题？
------解决方案--------------------
//private static string _connString = "Data Source =\"" + Application.StartupPath + @"\DB\Examation.db" + "\"";
private static SQLiteConnectionStringBuilder connstr = new SQLiteConnectionStringBuilder();
/// <summary>
/// 返回数据库链接字符串
/// </summary>
public static string ConnString
{
get
{
connstr.DataSource = Application.StartupPath + @"\User\" + SysConstants.UserInfo["account"] + "\\db";
connstr.Password = "************";//设置密码，SQLite ADO.NET实现了数据库密码保护
return connstr.ToString();
}
}