C#è¿æ¥æ°æ®åºæ以ä¸å 个æ¥éª¤ï¼
1ï¼ä½¿ç¨é
ç½®çæ°æ®åºè¿æ¥ä¸²ï¼å建æ°æ®åºè¿æ¥ Connection 对象
2ï¼æ建æä½çsqlè¯å¥
3ï¼å®ä¹command对象
4ï¼æå¼æ°æ®è¿æ¥
5ï¼æ§è¡å½ä»¤
举ä¸ä¸ªä¾åï¼å é¤æä½
public class StudentService
{
//ä»é
ç½®æ件ä¸è¯»åæ°æ®åºè¿æ¥å符串
private readonly static string connString = ConfigurationManager.ConnectionStrings["accpConnectionString"].ToString();
private readonly static string dboOwner = ConfigurationManager.ConnectionStrings["DataBaseOwner"].ToString();
AdoNetModels.Student model = new Student();
#region å é¤æ°æ®1
public int DeleteStudent(int stuID)
{
int result = 0;
// æ°æ®åºè¿æ¥ Connection 对象
SqlConnection connection = new SqlConnection(connString);
// æ建å é¤çsqlè¯å¥
string sql = string.Format("Delete From Student Where stuID={0}", stuID);
// å®ä¹command对象
SqlCommand command = new SqlCommand(sql, connection);
try
{
connection.Open();
result = command.ExecuteNonQuery(); // æ§è¡å½ä»¤
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
connection.Close();
}
return result;
}
#endregion