private void Click_Insert(object sender, RoutedEventArgs e)
{
if (this.Insert_Name.Text.Equals(string.Empty))
{
System.Windows.MessageBox.Show("Empty Name Inserted!");
}
else
{
using (SqlConnection con = new SqlConnection(Properties.Settings.Default.DataBaseConnectionString))
{
try
{
SqlCommand cmd = new SqlCommand("SELECT Name,City,Tel,QQ,Belong FROM Contactors WHERE Belong='" + Sign_in.Get_Confidential_User_ID().Trim() + "'", con);
SqlDataAdapter AutoSda = new SqlDataAdapter();
AutoSda.SelectCommand = cmd;
SqlCommandBuilder ComBuild = new SqlCommandBuilder(AutoSda);
con.Open();
DataTable dt = new DataTable();
AutoSda.Fill(dt);
DataRow [] Rows_Selected = dt.Select("Name='" + this.Insert_Name.Text.Trim() + "'");
if (Rows_Selected.Count() == 0)
{
Insert_Detail Item = new Insert_Detail(this.Insert_Name.Text.Trim(), Insert_Verifycode);
this.Insert_Name.Text = "输入名字";
Object[] temp = new Object[5];
temp[0] = ContactData.Get_Name();
temp[1] = ContactData.Get_City();
temp[2] = ContactData.Get_Tel();
temp[3] = ContactData.Get_QQ();
temp[4] = Sign_in.Get_Confidential_User_ID();
dt.LoadDataRow(temp, true);
dt.AcceptChanges();
AutoSda.Update(dt);
Contact_Book_View.ItemsSource = dt.DefaultView;
}
else
{
System.Windows.MessageBox.Show(Name + " is already existed!");
}
}
catch (Exception ex)
{
System.Windows.MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
}
}
}
private void Click_Insert(object sender, RoutedEventArgs e)
{
if (this.Insert_Name.Text.Equals(string.Empty))
{
System.Windows.MessageBox.Show("Empty Name Inserted!");
}
else
{
DataTable Dt = new DataTable();
SqlDataAdapter Temp_DataAdapter = new SqlDataAdapter();
SqlConnection Temp_Link = Get_Connect_DataBase();
Temp_DataAdapter.SelectCommand = new SqlCommand("select * from Contactors where Belonging='" + Sign_in.Get_Confidential_User_ID() + "';", Temp_Link);
SqlCommandBuilder SCB = new SqlCommandBuilder(Temp_DataAdapter);
try
{
Temp_DataAdapter.Fill(Dt);
}
catch (Exception ex)
{
System.Windows.MessageBox.Show(ex.Message + "\t4wefsdf8647");
}
try
{
DataRow Insert_Row = Dt.NewRow();
Insert_Row["Name"] = ContactData.Get_Name();
Insert_Row["City"] = ContactData.Get_City();
Insert_Row["Tel"] = ContactData.Get_Tel();
Insert_Row["QQ"] = ContactData.Get_QQ();
Insert_Row["Belonging"] = Sign_in.Get_Confidential_User_ID();
Dt.ImportRow(Insert_Row);
Temp_DataAdapter.Update(Dt);
Dt.AcceptChanges();
}
catch (Exception ex)
{
System.Windows.MessageBox.Show(ex.Message + "\t489797");
}
finally
{
Temp_Link.Close();
}
}
}
private void FillDataGrid()
{
//大概过程---先配置数据库ConString（因为配置文件App.config把数据库名字改成了这个）,作用是说明在配置文件里直接就可以修改数据库的参数而不用麻烦的在代码里改
//--然后定义一个字符串用作写T-SQL语句,然后初始化数据库连接(使用配置文件ConString)，字符串放T-sql语句
//--再然后数据库命令，作用是使得上一句的字符串的命令生效
//--再然后实例化SqlDataAdapter
//---再然后实例化数据表DataTable
//---再然后SqlDataAdapter填充数据表DataTable的东西
//--最后把填充好的数据的基础视图赋值给DataGrid的ItemSource
using (SqlConnection con = new SqlConnection(Properties.Settings.Default.DataBaseConnectionString))
{
SqlCommand cmd = new SqlCommand("SELECT Name,City,Tel,QQ,Belong FROM Contactors WHERE Belong='" + Sign_in.Get_Confidential_User_ID().Trim() + "'", con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
Contact_Book_View.ItemsSource = dt.DefaultView;
}
}
private void Click_Search(object sender, RoutedEventArgs e)
{
//System.Windows.MessageBox.Show("Searching "+this.Search_Name.Text);
if (this.Search_Name.Text.Trim().Equals(string.Empty))
{
System.Windows.MessageBox.Show("Empty Name Inserted!");
}
else
{
using (SqlConnection con = new SqlConnection(Properties.Settings.Default.DataBaseConnectionString))
{
try
{
SqlCommand cmd = new SqlCommand("SELECT Name,City,Tel,QQ,Belong FROM Contactors WHERE Belong='" + Sign_in.Get_Confidential_User_ID().Trim() + "'", con);
SqlDataAdapter AutoSda = new SqlDataAdapter();
AutoSda.SelectCommand = cmd;
SqlCommandBuilder ComBuild = new SqlCommandBuilder(AutoSda);
con.Open();
DataTable dt = new DataTable();
AutoSda.Fill(dt);
DataRow[] Rows_Selected = dt.Select("Name='" + this.Search_Name.Text.Trim() + "'");
if (Rows_Selected.Count() == 0)
{
System.Windows.MessageBox.Show(this.Search_Name.Text.Trim() + " not Found");
}
else
{
Searched_Detail temp = new Searched_Detail(Rows_Selected[0]);
dt.AcceptChanges();
AutoSda.Update(dt);
Contact_Book_View.ItemsSource = dt.DefaultView;
}
Search_Name.Text = "输入名字";
}
catch (Exception ex)
{
System.Windows.MessageBox.Show(ex.Message);
}
finally
{
con.Close();
}
}
}
}
private void Refresh_DataGrid()
{
using (SqlConnection Link = new SqlConnection(Properties.Settings.Default.SqlPath))
{
try
{
Link.Open();
}
catch (Exception e)
{
System.Windows.MessageBox.Show(e.Message + "\n##Link Error##");
}
//SqlCommand Operation = Link.CreateCommand();
string CommandText = "select * from Contactors where Belonging = '" + Sign_in.Get_Confidential_User_ID().Trim() + "';";
SqlDataAdapter DataAdapter = new SqlDataAdapter(CommandText, Link);
DataTable Dt = new DataTable();
try
{
DataAdapter.Fill(Dt);
Contact_Book_View.ItemsSource = Dt.DefaultView;
}
catch (Exception e)
{
System.Windows.MessageBox.Show(e.Message + "425735");
}
Link.Close();
}
}