I have a DataGrid, bound to database table customer.Here is my database query
sqlitecon.Open();
string Query = "Select Card_Number,Clients_Title,Address_Current,Phone_Number,Mobile_Number from Customer_New "; SQLiteCommand createCommand = new SQLiteCommand(Query, sqlitecon); createCommand.ExecuteNonQuery();
SQLiteDataAdapter dataAdp = new SQLiteDataAdapter(createCommand);
DataTable dt = new DataTable("Customer_New");
dataAdp.Fill(dt);
datagrid_cindex.ItemsSource = dt.DefaultView; dataAdp.Update(dt);
sqlitecon.Close();
I need to select the primary key ID value from database table of selected row in DataGrid.
How to do it ? please Help ..