C#.NET and MS Access database...

Question

Hello...

I`m using C#.NET, MS Access base and my table is "ID | Name | Age | City | Country ", and now... How can I search the base but not by ID, but by Name. When I write the Name to get the rest information

Thanks.

Sky Driver · Answer

Thanks a lot for the help. I`m using this tutorial: http://www.codeproject.com/KB/cs/simple_movie_database.aspx But I have one problem, when I press the edit button it doesn't open the EditingForm and when I press the delete button it doesn't delete the selected movie, neither of the buttons works. Insert button on the dataGrid code: editButton = new DataGridViewButtonColumn(); editButton.HeaderText = "Edit"; editButton.Text = "Edit"; editButton.UseColumnTextForButtonValue = true; editButton.Width = 80; dataGridView1.Columns.Add(editButton); // insert delete button to datagridview deleteButton = new DataGridViewButtonColumn(); deleteButton.HeaderText = "Delete"; deleteButton.Text = "Delete"; deleteButton.UseColumnTextForButtonValue = true; deleteButton.Width = 80; dataGridView1.Columns.Add(deleteButton); On press Edit button code: if (dataGridView1.Columns[e.ColumnIndex] == editButton && currentRow >= 0) { string title = dataGridView1[1, currentRow].Value.ToString(); string publisher = dataGridView1[2, currentRow].Value.ToString(); string previewed = dataGridView1[3, currentRow].Value.ToString(); string year = dataGridView1[4, currentRow].Value.ToString(); string type = dataGridView1[5, currentRow].Value.ToString(); //runs form 3 for editing Form3 f3 = new Form3(); f3.title = title; f3.publisher = publisher; f3.previewed = previewed; f3.year = year; f3.type = type; f3.movieID = movieIDInt; f3.Show(); dataGridView1.Update(); } On press Delete button code: else if (dataGridView1.Columns[e.ColumnIndex] == deleteButton && currentRow >= 0) { // delete sql query string queryDeleteString = "DELETE FROM movie where movieID = " + movieIDInt + ""; OleDbCommand sqlDelete = new OleDbCommand(); sqlDelete.CommandText = queryDeleteString; sqlDelete.Connection = database; sqlDelete.ExecuteNonQuery(); loadDataGrid(queryString); } } Where I`m vrong ? Thanks.

Vijaya Kadiyala · Answer

Hi You can simply use NAME in your where condition. but it would be good if you re-write your question. Thanks -- Vijaya Kadiyala http://dotnetvj.blogspot.com

Rajendra Deopura · Answer

Dear Write a select statement like this : select * from where name='" & TextBox1.Text &" ' where, is the name of table in database. Thanks

C#.NET and MS Access database...

Answers (3)