Exemplos de Libary_Ver0._1 stBookData em C# (CSharp)

Exemplo n.º 1

Arquivo: BookDB.cs Projeto: mujeensung/ProjectLMS

        public DataSet GetData(eItem item, string str)
        {
            stBookData bookData = new stBookData(0, "", "");
            bookList = new ArrayList();
            DataSet ds = new DataSet();

            using (var conn = new SQLiteConnection(connStr))
            {
                conn.Open();
                string sql = "SELECT * FROM Book WHERE " + item.ToString() + "='" + str + "'";
                SQLiteDataAdapter adapter = new SQLiteDataAdapter(sql, conn);
                adapter.Fill(ds);
            }
            return ds;
        }

Exemplo n.º 2

Arquivo: BookDB.cs Projeto: mujeensung/ProjectLMS

        public DataSet GetData(eItem item, string str)
        {
            stBookData bookData = new stBookData(0, "", "");

            bookList = new ArrayList();
            DataSet ds = new DataSet();

            using (var conn = new SQLiteConnection(connStr))
            {
                conn.Open();
                string            sql     = "SELECT * FROM Book WHERE " + item.ToString() + "='" + str + "'";
                SQLiteDataAdapter adapter = new SQLiteDataAdapter(sql, conn);
                adapter.Fill(ds);
            }
            return(ds);
        }

Exemplo n.º 3

Arquivo: BookDB.cs Projeto: mujeensung/ProjectLMS

        public ArrayList Select_Reader(eItem item, string str)
        {
            stBookData bookData = new stBookData(0, "", "");

            bookList = new ArrayList();

            using (var conn = new SQLiteConnection(connStr))
            {
                conn.Open();
                string sql = "SELECT * FROM Book WHERE " + item.ToString() + "=" + str + "";

                SQLiteCommand    cmd = new SQLiteCommand(sql, conn);
                SQLiteDataReader rdr = cmd.ExecuteReader();
                while (rdr.Read())
                {
                    bookData.author = rdr["author"].ToString();
                    bookData.title  = rdr["title"].ToString();
                    bookList.Add(bookData);
                }
                rdr.Close();
            }
            return(bookList);
        }

Exemplo n.º 4

Arquivo: BookDB.cs Projeto: mujeensung/ProjectLMS

        public ArrayList Select_Reader(eItem item, string str)
        {
            stBookData bookData = new stBookData(0, "", "");
            bookList = new ArrayList();

            using (var conn = new SQLiteConnection(connStr))
            {
                conn.Open();
                string sql = "SELECT * FROM Book WHERE " + item.ToString() + "=" + str + "";

                SQLiteCommand cmd = new SQLiteCommand(sql, conn);
                SQLiteDataReader rdr = cmd.ExecuteReader();
                while (rdr.Read())
                {
                    bookData.author = rdr["author"].ToString();
                    bookData.title = rdr["title"].ToString();
                    bookList.Add(bookData);
                }
                rdr.Close();
            }
            return bookList;
        }