Delete user

Question

Hello all I have written code for deleting particular Id entered by the user in the text box. What i need is when i press on Delete button it should display if the Entered Id delete or not. can any one give me the code. I am able to delete but that condition i am unable to get. Please help

Kirtan Patel · Answer

Suppose i Have Table with three Column IDNameAge Then Code will be like below private void button1_Click(object sender EventArgs e) { SqlConnection con = new SqlConnection(@Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True); con.Open(); SqlCommand comm = new SqlCommand(select * from Users Where Id= + textBox1.Text con); SqlDataAdapter da = new SqlDataAdapter(comm); DataSet ds = new DataSet(); da.Fill(ds Vtable); if (ds.Tables[0].Rows.Count > 0) { comm = new SqlCommand(delete from users where id= + textBox1.Textcon); comm.ExecuteNonQuery(); MessageBox.Show(Record Deleted!!); } else { MessageBox.Show(Record Not Exist); } }

Kirtan Patel · Answer

VTable is Table Name in DataSet You can name it Anything But I call it Virtual Table so called VTable

Dorababu Meka · Answer

Thanks Kitran and what u mean by vtable in that data adapter.