ADO.NET 刪除資料

標籤：mic   net   where   str   1.5   添加   adl   exec   database   

Console.Write("請輸入要刪除的編號：");string ucode = Console.ReadLine();SqlConnection conn = new SqlConnection("server=.;database=Data0504;user=sa;pwd=123;");SqlCommand cmd = conn.CreateCommand();cmd.CommandText = "delete from Users where Ucode=‘" + ucode + "‘";conn.Open();int count = cmd.ExecuteNonQuery();conn.Close();if (count > 0){Console.WriteLine("刪除成功");}else{Console.WriteLine("刪除失敗！");}Console.ReadLine();

//這裡記得添加命名空間 using System.Data.SqlClient;

ADO.NET 刪除資料