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