Hi...
I am having one form in which payment mode have 2 radiobuttons cash and cheque when cash is there cheque panel remains in visible and when cheque is clicked panel opens in that there is cheuqe no,date and bank name.
my problem is that when i store cash data the cheque date by default stores date 1-jan-1900
but i dont want this to happen plz help me .....
HTML:
<asp:Panel ID="pnlcreate" Visible="false" runat="server">
<table width="100%">
<tr>
<td>
</td>
<td>
<asp:Label ID="lblmsg" runat="server" ForeColor="#CC0000" Visible="False"></asp:Label>
</td>
<td>
</td>
<td>
<asp:Label ID="lblReceipt_No" runat="server" Text="Receipt No:"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtRce_No" runat="server" ReadOnly="True"></asp:TextBox>
</td>
<td>
</td>
</tr>
<tr>
<td>
<asp:Label ID="lbldate" runat="server" Text="Date:"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtdate" runat="server"></asp:TextBox>
<asp:CalendarExtender ID="CalendarExtender1" runat="server" PopupButtonID="txtdate"
TargetControlID="txtdate">
</asp:CalendarExtender>
<asp:RequiredFieldValidator ID="RequiredFieldValidator8" runat="server" ControlToValidate="txtdate"
ErrorMessage="- Date" Font-Size="Large" ForeColor="#CC0000" Text="*"></asp:RequiredFieldValidator>
</td>
<td>
</td>
<td>
<asp:Label ID="lblEnroll" runat="server" Text="Enrollment No:"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtEnroll" runat="server" OnTextChanged="txtEnroll_TextChanged"
AutoPostBack="True"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="txtEnroll"
ErrorMessage="- Enrollment No" Font-Size="Large" ForeColor="#CC0000" Text="*"></asp:RequiredFieldValidator>
</td>
<td>
</td>
</tr>
<tr>
<td>
<asp:Label ID="lblStudname" runat="server" Text="Name Of Student:"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtStudname" Enabled="False" runat="server"></asp:TextBox>
</td>
<td>
</td>
<td>
<asp:Label ID="lblUni" runat="server" Text="University:"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtUni" runat="server" Enabled="False"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="lblCourse" runat="server" Text="Course:"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtCourse" Enabled="False" runat="server"></asp:TextBox>
</td>
<td>
</td>
<td>
<asp:Label ID="lblfeeoffered" runat="server" Text="Fees Offered:"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtfeeoffered" Enabled="False" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="lblfeepaid" runat="server" Text="Fees Paid:"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtfeepaid" Enabled="False" runat="server"></asp:TextBox>
</td>
<td>
</td>
<td>
<asp:Label ID="lblfeerem" runat="server" Text="Fees Outstanding:"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtfeerem" Enabled="False" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="lblAmount" runat="server" Text="Amount:"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtAmount" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator9" runat="server" ControlToValidate="txtAmount"
ErrorMessage="- Amount" Text="*" ForeColor="#CC0000" Font-Size="Large"></asp:RequiredFieldValidator>
</td>
<td>
</td>
<td>
<asp:Label ID="lblPayment_Mode" runat="server" Text="Mode Of Payment:"></asp:Label>
</td>
<td>
<asp:RadioButtonList ID="RadioButtonList2" runat="server" AutoPostBack="True" RepeatDirection="Horizontal"
OnSelectedIndexChanged="RadioButtonList2_SelectedIndexChanged">
<asp:ListItem>Cash</asp:ListItem>
<asp:ListItem>Cheque</asp:ListItem>
</asp:RadioButtonList>
</td>
</tr>
<tr>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
</table>
<br />
<asp:Panel ID="Panel1" runat="server" Visible="False">
<h4 style="color: #1876AF">
Cheque Details</h4>
<table width="700">
<tr>
<td>
<asp:Label ID="lblcheque_no" runat="server" Text="Cheque No:"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtcheque_no" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ControlToValidate="txtcheque_no"
ErrorMessage="- Cheque No" Text="*" ForeColor="#CC0000"></asp:RequiredFieldValidator>
</td>
<td>
<asp:Label ID="lblcheque_date" runat="server" Text="Cheque Date:"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtcheque_date" runat="server"></asp:TextBox>
<asp:ImageButton ID="ImageButton2" Height="20px" ImageUrl="~/images/Calendar icon.png"
Width="20px" CausesValidation="False" runat="server" />
<asp:CalendarExtender ID="CalendarExtender2" runat="server" TargetControlID="txtcheque_date"
PopupButtonID="ImageButton2">
</asp:CalendarExtender>
<asp:RequiredFieldValidator ID="RequiredFieldValidator7" runat="server" ControlToValidate="txtcheque_date"
ErrorMessage="- Cheque Date" Text="*" ForeColor="#CC0000"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>
<asp:Label ID="lblBank_Name" runat="server" Text="Bank Name:"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtBank_Name" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ControlToValidate="txtBank_Name"
ErrorMessage="- Bank Name" Text="*" ForeColor="#CC0000"></asp:RequiredFieldValidator>
</td>
</tr>
</table>
</asp:Panel>
<br />
<asp:Button ID="btnSave" runat="server" Text="Submit" CssClass="btn btn-primary"
OnClick="btnSave_Click" />
<asp:Label ID="lblsave" runat="server" Text=""></asp:Label>
<br />
<asp:ValidationSummary ID="ValidationSummary1" HeaderText="You must enter a value in the following fields:"
EnableClientScript="true" DisplayMode="BulletList" ShowSummary="true" runat="server"
ForeColor="#CC0000" />
<br />
</asp:Panel>
C#:
protected void btnSave_Click(object sender, EventArgs e)
{
qry = "Insert INTO PDC_Receipt Values('" + txtRce_No.Text + "','" + txtdate.Text + "','" + txtEnroll.Text + "','" + txtStudname.Text + "','" + txtUni.Text + "','" + txtCourse.Text + "','" + txtfeeoffered.Text + "','" + txtfeepaid.Text + "','" + txtfeerem.Text + "','" + txtAmount.Text + "','" + RadioButtonList2.Text + "','" + txtcheque_no.Text + "','" + txtcheque_date.Text + "','" + txtBank_Name.Text + "')";
conn.Open();
SqlCommand cmd = new SqlCommand(qry, conn);
cmd.ExecuteNonQuery();
conn.Close();
Response.Redirect("PDC_Receipt_Print.aspx?Date=" + txtdate.Text + "&PaymentMode=" + RadioButtonList2.Text + "&chequeno=" + txtcheque_no.Text + "&Bankname=" + txtBank_Name.Text + "&Studname=" + txtStudname.Text + "&course=" + txtCourse.Text + "&University=" +txtUni.Text + "&Receiptno=" + txtRce_No.Text + "&Feespaid=" + txtfeepaid.Text + "&Amount=" + txtAmount.Text +"&feesoffered=" + txtfeeoffered.Text+"&feesremain=" + txtfeerem.Text+"&Enrollno=" + txtEnroll.Text );
clearall();
ID_Incre();
}