//tim ca si public Singer findSinger(int SingerID) { SqlConnection cnn = new SqlConnection(strConnection); string SQL = "Select SingerID, SingerName, SingerAge, SingerEmail from Singer where SingerID=@SingerID"; SqlCommand cmd = new SqlCommand(SQL, cnn); cmd.Parameters.AddWithValue("@SingerID", SingerID); if (cnn.State == ConnectionState.Closed) { cnn.Open(); } Singer s = null; SqlDataReader reader = cmd.ExecuteReader(); { while (reader.Read()) { Console.WriteLine(String.Format("{0}, {1}, {2}, {3}", reader[0], reader[1], reader[2], reader[3])); var ID = reader[0]; var Name = reader[1]; var Age = reader[2]; var Email = reader[3]; s = new Singer { SingerID = (int)ID, SingerName = (string)Name, SingerAge = (int)Age, SingerEmail = (string)Email }; break; } } return(s); }
//Them ca si public bool addSinger(Singer singer) { SqlConnection cnn = new SqlConnection(strConnection); string SQL = "Insert Singer values(@SingerID,@SingerName,@SingerAge,@SingerEmail)"; SqlCommand cmd = new SqlCommand(SQL, cnn); cmd.Parameters.AddWithValue("@SingerID", singer.SingerID); cmd.Parameters.AddWithValue("@SingerName", singer.SingerName); cmd.Parameters.AddWithValue("@SingerAge", singer.SingerAge); cmd.Parameters.AddWithValue("@SingerEmail", singer.SingerEmail); if (cnn.State == ConnectionState.Closed) { cnn.Open(); } int count = cmd.ExecuteNonQuery(); return(count > 0); }