Delete data from databases

Question

How can I delete table values from database using c#, but by asking from user not hard coded values ? I write the code but it's not working check it out....

Munesh Sharma · Answer

You can use for deleting your history from database based on ID private void delete_btn_Click( object sender, EventArgs e) { if (!(textBox1.Text == string .Empty && textBox2.Text == string .Empty)) { string str = "server = MUNESH;Database=data;UID=sa;Password=reladmin" ; SqlConnection con = new SqlConnection(str); string query = "Delete from registration where ID= '" + this .textBox1.Text + "' and Password = '" + this .textBox2.Text + "'" ; SqlCommand cmd = new SqlCommand(query, con); SqlDataReader myreader; try { con.Open(); myreader = cmd.ExecuteReader(); MessageBox.Show( "Deleted" , "user information" ); while (myreader.Read()) { } con.Close(); } catch (Exception ec) { MessageBox.Show(ec.Message); } } else { MessageBox.Show( "enter ID or password which you want to delete" ); } }

Abhay Shanker · Answer

Hello Ahsan, You can delete the records using C#.But you need to pass any way Table name and ID.If you could share the code then it would be good to point out the issue

Jignesh Trivedi · Answer

hi, Can you please provide more information like what technologies you are using win forms or web or mvc and ofcourse your code. also refer below link http://www.onlinebuff.com/article_step-by-step-select-insert-update-and-delete-using-aspnet-c-and-adonet_32.html http://www.dreamincode.net/forums/topic/238727-insert-update-and-delete-records-in-table-with-datagridview-using-c%23/ hope this will help you.

Shweta Lodha · Answer

Please post your code snippet here or let us know what error are you getting ?

Ahsan Abbas · Answer

Thanks for the help all of you...

Delete data from databases

Answers (5)