ALTER PROC [dbo].[getCreditCard] AS BEGIN IF NOT EXISTS(SELECT CardNumber,NameOnCard,ExpiresEnd As MyDate FROM [dbo].[CardBank] ) begin PRINT N'Request failed!' return 0 end else begin select * from [dbo].[CardBank] PRINT N'Request succeeded' return 1 end END
DataTable dt = _CreditCardInfo.GetCreditCard().Tables[0]; _CreditCardInfo.CardNumber = TextBoxCardNumber.Text.Trim(); string dropDowlistYear = DropDownListYears.SelectedValue; string dropDowlistMonth = DropDownListMonth.SelectedValue; DataRow[] drCardNumber = dt.Select("CardNumber='" + TextBoxCardNumber.Text.ToString().Trim() + "'"); DataRow[] drNameOnCard = dt.Select("NameOnCard='" + TextBoxNameOnCard.Text.ToString() + "'"); DataRow[] drValidFrom = dt.Select("MyDate='" + dropDowlistYear + "/" + dropDowlistMonth + "'"); //DataRow[] ExpiresEnd = dt.Select("ExpYear='" + dropDowlistMonth1 + "'"); if (drCardNumber.Length > 0 && drNameOnCard.Length > 0 && drValidFrom.Length > 0) { Response.Redirect("Default.aspx"); } else { LabelMessage.Text = "The Card name or Card Number are invalid."; LabelMessage.ForeColor = Color.Red; return; }
public DataSet GetCreditCard() { return SqlHelper.ExecuteDataset(SqlHelper.GetConnection(), "[getCreditCard]"); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)