8,834
社区成员
发帖
与我相关
我的任务
分享
private void table1_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
DataRowView mySelectedItem = table1.SelectedItem as DataRowView;
textBlock1.Text = mySelectedItem.Row[0].ToString();
}
//此处做sql的查询
cmd.CommandText = "delete from course where courseid=@id";
cmd.Parameters.AddWithValue("@id", textBlock1.Text);
private void display()
{
con = new SQLiteConnection("Data Source=Mydatabase.s3db");
con.Open();
cmd.Connection = con;
cmd.CommandText = "select * from course";
cmd.ExecuteNonQuery();
//绑定
courseDt = new DataTable("course");
adapter = new SQLiteDataAdapter(cmd);
adapter.Fill(courseDt);
table1.ItemsSource = courseDt.DefaultView;
adapter.Update(courseDt);
con.Close();
}
if(mySelectedItem!=null){
textBlock1.Text = mySelectedItem.Row[0].ToString();
}