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();
}
