private void btnCreateIndex_Click(object sender, EventArgs e) { SQLIndexCreator creator = new SQLIndexCreator(); string sql = "SELECT VerseID, VerseText FROM Verse"; using (SqlCeConnection conn = new SqlCeConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString)) { conn.Open(); SqlCeDataReader rdr = new SqlCeCommand(sql, conn).ExecuteReader(); creator.CreateIndex("Bible", IndexDir, rdr, new CultureInfo("en-US"), "VerseID", "VerseText"); rdr.Close(); } }
private void button1_Click_1(object sender, EventArgs e) { IndexInfo index; index = ExtractIndex(); // Populate the Database using (SqlCeConnection connection = new SqlCeConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString)) { connection.Open(); string sql = string.Empty; foreach (Book b in index.Books) { sql = string.Format("INSERT INTO Book (BookNum, BookName) VALUES ({0}, '{1}')", b.BookNumber, b.Name.Replace("'", "''")); SqlCeCommand cmd = new SqlCeCommand(sql, connection); cmd.ExecuteNonQuery(); sql = "SELECT MAX(BookID) FROM Book"; cmd.CommandText = sql; int bookId = (int)cmd.ExecuteScalar(); foreach (Verse v in b.Verses) { sql = string.Format("INSERT INTO Verse (BookID, ChapterNum, VerseNum, VerseText) VALUES ({0}, {1}, {2}, '{3}')", bookId, v.Chapter, v.VerseNum, v.Text.Replace("'", "''")); cmd.CommandText = sql; cmd.ExecuteNonQuery(); } } } // Now Create the Index SQLIndexCreator creater = new SQLIndexCreator(); }