Hi I want to compare the data entered in a textbox to the data I have in DataTable but I am getting this error: Cannot find column [Date].
T-Sql code:
<pre lang="sql">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</pre>
and c# code:
<pre lang="cs">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;
}</pre>
and this the code inside my class:
<pre lang="sql">public DataSet GetCreditCard()
{
return SqlHelper.ExecuteDataset(SqlHelper.GetConnection(), "[getCreditCard]");
}</pre>
As u can see I want to get it from Datatable.
Can someone help!