/** private void MenuViewContacts_Click(object sender, System.Windows.RoutedEventArgs e)
* view Contacts
*/
public void createUserControlContact()
{
int i = 0;
UserControlExpanderContact[] uc = new UserControlExpanderContact[200];
SQLiteConnection new_con = new SQLiteConnection(customwindow.Properties.Settings.Default.ConnectionString.ToString());
new_con.Open();
SQLiteCommand get = new SQLiteCommand("SELECT * FROM contact_detail ORDER BY firstname ASC LIMIT 0 , 30", new_con);
SQLiteDataReader reader;
reader = get.ExecuteReader();
String header;
while (reader.Read())
{
header = reader[1].ToString() + "\t\t\t" + reader[2].ToString();
uc[i] = new UserControlExpanderContact();
uc[i].setContent(Convert.ToInt32(reader[0].ToString()), reader[2].ToString(), reader[3].ToString(), reader[5].ToString(), reader[4].ToString(), header);
WrapPanel1.Children.Add(uc[i]);
i++;
}
new_con.Close();
}
void System.Windows.Markup.IComponentConnector.Connect(int connectionId, object target) {
switch (connectionId)
{
case 1:
this.UserControl = ((customwindow.UserControlExpanderContact)(target));
return;
case 2:
this.LayoutRoot = ((System.Windows.Controls.Grid)(target));
return;
case 3:
this.ExpanderContact = ((System.Windows.Controls.Expander)(target));
return;
case 4:
this.UserControlExpanderContactGrid = ((customwindow.UserControlExpanderContactGrid)(target));
return;
}
this._contentLoaded = true;
}
