String nowPath = @"taxi.db";
void SelectStu()
{
using (SQLiteConnection cn = new SQLiteConnection(@"data source=" + nowPath + ";pooling=true;failifmissing=false"))
{
cn.Open();
using (SQLiteCommand cmd = new SQLiteCommand())
{
cmd.Connection = cn;
cmd.CommandText = "select from Student";
using (SQLiteDataReader dr = cmd.ExecuteReader())
{
List<Student> stuList;
while (dr.Read())
{
Student node = new Student();
//Response.Write("<script>alert('" + dr.GetValue(1).ToString() + "')</script");
node.Str_pass = dr.GetValue(0).ToString();
node.Stu_name = dr.GetValue(1).ToString();
node.Stu_num = dr.GetValue(2).ToString();
}
}
}
}
}