Hi i am creating an application in which i have home page where i have a drop-down list. On selecting value from the list a form will appear accordingly, now when i press on submit button entered data in form stored in my database On my second page i have a drop-down list with same value, from and to date text-box to select dates and a grid-view. now what i want is when i select drop-down list and select dates in the text-box i get the data in my grid for the particular dates and value selected from drop-down list in grid.
Code:
<form id="form1" runat="server">
<div id="FirstForm" style="margin-left: 80px">
<asp:TextBox ID="tbid" runat="server" Enabled="false"
Visible="false" Width="137px"></asp:TextBox>
<br />
<asp:ValidationSummary ID="vdm" runat="server" ForeColor="Red" />
<table class="style1">
<tr>
<td class="style13">
<asp:Label ID="lblPortal" runat="server" Text="Select Portal"></asp:Label>
</td>
<td class="style5">
<asp:DropDownList ID="ddlPortal" runat="server" AutoPostBack="True"
onselectedindexchanged="ddlPortal_SelectedIndexChanged">
<asp:ListItem>TRAVELONG</asp:ListItem>
<asp:ListItem>ONETRAVEL</asp:ListItem>
<asp:ListItem>.UK-BSP</asp:ListItem>
<asp:ListItem>.CA-YYZ</asp:ListItem>
<asp:ListItem>.CA-YVR</asp:ListItem>
<asp:ListItem>Partial MCO Refund</asp:ListItem>
</asp:DropDownList>
</td>
<td class="style4">
</td>
<td class="style5">
</td>
<td class="style11">
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td class="style13">
<asp:Label ID="lblTid" runat="server" Text="TID"></asp:Label>
</td>
<td class="style5">
<asp:TextBox ID="tbTid" runat="server"></asp:TextBox>
</td>
<td class="style4">
<asp:RequiredFieldValidator ID="rfvTid" runat="server"
ControlToValidate="tbTid" ErrorMessage="Enter Tid" Font-Bold="True"
ForeColor="Red">*</asp:RequiredFieldValidator>
</td>
<td class="style5">
<asp:Label ID="lblUnusedTicketAmount" runat="server"
Text="Unused Ticket Amount"></asp:Label>
</td>
<td class="style11">
<asp:TextBox ID="tbUnusedTicketAmount" runat="server"></asp:TextBox>
</td>
<td>
<asp:RequiredFieldValidator ID="rfvUnusedTicketAmount" runat="server"
ControlToValidate="tbUnusedTicketAmount" ErrorMessage="Enter Amount"
Font-Bold="True" ForeColor="Red">*</asp:RequiredFieldValidator>
</td>
<td>
<asp:DropDownList ID="ddlUnusedAmount" runat="server">
<asp:ListItem>USD</asp:ListItem>
<asp:ListItem>CAD</asp:ListItem>
<asp:ListItem>GBP</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td class="style14">
<asp:Label ID="lblPNR" runat="server" Text="PNR"></asp:Label>
</td>
<td class="style9">
<asp:TextBox ID="tbPNR" runat="server"></asp:TextBox>
</td>
<td class="style8">
<asp:RequiredFieldValidator ID="rfvPNR" runat="server"
ControlToValidate="tbPNR" ErrorMessage="Enter PNR" Font-Bold="True"
ForeColor="Red">*</asp:RequiredFieldValidator>
</td>
<td class="style9">
<asp:Label ID="lblAirlinePenality" runat="server" Text="Airline Penality"></asp:Label>
</td>
<td class="style12">
<asp:TextBox ID="tbAirlinePenality" runat="server"></asp:TextBox>
</td>
<td class="style10">
<asp:RequiredFieldValidator ID="rfvAirlinePenality" runat="server"
ControlToValidate="tbAirlinePenality" ErrorMessage="Enter Penality"
Font-Bold="True" ForeColor="Red">*</asp:RequiredFieldValidator>
</td>
<td class="style10">
<asp:DropDownList ID="ddlAirlinePenality" runat="server" AutoPostBack="True">
<asp:ListItem>USD</asp:ListItem>
<asp:ListItem>CAD</asp:ListItem>
<asp:ListItem>GBP</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td class="style13">
<asp:Label ID="lblTicketNumber" runat="server" Text="Ticket Number"></asp:Label>
</td>
<td class="style5">
<asp:TextBox ID="tbTicketNumber" runat="server"></asp:TextBox>
</td>
<td class="style4">
<asp:RequiredFieldValidator ID="rfvTicketNumber" runat="server"
ControlToValidate="tbTicketNumber" ErrorMessage="Enter ESAC" Font-Bold="True"
ForeColor="Red">*</asp:RequiredFieldValidator>
</td>
<td class="style5">
<asp:Label ID="lblNetRefundProcess" runat="server" Text="Net Refund Process"></asp:Label>
</td>
<td class="style11">
<asp:TextBox ID="tbNetRefundProcess" runat="server"></asp:TextBox>
</td>
<td>
<asp:RequiredFieldValidator ID="rfvNetRefundProcess" runat="server"
ControlToValidate="tbNetRefundProcess" ErrorMessage="RequiredFieldValidator"
Font-Bold="True" ForeColor="Red">*</asp:RequiredFieldValidator>
</td>
<td>
<asp:DropDownList ID="ddlNetRefundProcess" runat="server" AutoPostBack="True">
<asp:ListItem>USD</asp:ListItem>
<asp:ListItem>CAD</asp:ListItem>
<asp:ListItem>GBP</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td class="style13">
<asp:Label ID="lblESACCode" runat="server" Text="ESAC Code"></asp:Label>
</td>
<td class="style5">
<asp:TextBox ID="tbESACCode" runat="server"></asp:TextBox>
</td>
<td class="style4">
<asp:RequiredFieldValidator ID="rfvESACCode" runat="server"
ControlToValidate="tbESACCode" ErrorMessage="Enter ESAC code" Font-Bold="True"
ForeColor="Red">*</asp:RequiredFieldValidator>
</td>
<td class="style5">
<asp:Label ID="lblRefundableCommision" runat="server"
Text="Refundable Commission"></asp:Label>
</td>
<td class="style11">
<asp:TextBox ID="tbRefundableCommision" runat="server"></asp:TextBox>
</td>
<td>
<asp:RequiredFieldValidator ID="rfvRefundableCommission" runat="server"
ControlToValidate="tbRefundableCommision" ErrorMessage="RequiredFieldValidator"
Font-Bold="True" ForeColor="Red">*</asp:RequiredFieldValidator>
</td>
<td>
<asp:DropDownList ID="ddlRefundableCommission" runat="server"
AutoPostBack="True">
<asp:ListItem>USD</asp:ListItem>
<asp:ListItem>CAD</asp:ListItem>
<asp:ListItem>GBP</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td class="style13">
<asp:Label ID="lblWaiverCode" runat="server" Text="Waiver Code"></asp:Label>
</td>
<td class="style5">
<asp:TextBox ID="tbWaiverCode" runat="server"></asp:TextBox>
</td>
<td class="style4">
<asp:RequiredFieldValidator ID="rfvWaiverCode" runat="server"
ControlToValidate="tbWaiverCode" ErrorMessage="Enter Waiver Code"
Font-Bold="True" ForeColor="Red">*</asp:RequiredFieldValidator>
</td>
<td class="style5">
<asp:Label ID="lblCouponRefunded" runat="server" Text="Coupon Refunded"></asp:Label>
</td>
<td class="style11">
<asp:TextBox ID="tbCouponRefund" runat="server"></asp:TextBox>
</td>
<td>
<asp:RequiredFieldValidator ID="rfvCouponRefunded" runat="server"
ControlToValidate="tbCouponRefund" ErrorMessage="Enter Coupon Refund"
Font-Bold="True" ForeColor="Red">*</asp:RequiredFieldValidator>
</td>
<td>
</td>
</tr>
<tr>
<td class="style13">
<asp:Label ID="Label7" runat="server" Text="Remarks"></asp:Label>
</td>
<td class="style5">
<asp:TextBox ID="tbRemarks" runat="server" TextMode="MultiLine"></asp:TextBox>
</td>
<td class="style4">
<asp:RequiredFieldValidator ID="rfvRemarks" runat="server"
ControlToValidate="tbRemarks" ErrorMessage="Enter Remarks" Font-Bold="True"
ForeColor="Red">*</asp:RequiredFieldValidator>
</td>
<td class="style5">
<asp:Label ID="lblRefundType" runat="server" Text="Refund Type"></asp:Label>
</td>
<td class="style11">
<asp:DropDownList ID="ddlRefundType" runat="server">
<asp:ListItem>Full</asp:ListItem>
<asp:ListItem>Partial</asp:ListItem>
</asp:DropDownList>
</td>
<td>
<asp:RequiredFieldValidator ID="rfvRefundType" runat="server"
ControlToValidate="ddlRefundType" ErrorMessage="Select Refund Type"
Font-Bold="True" ForeColor="Red">*</asp:RequiredFieldValidator>
</td>
<td>
</td>
</tr>
<tr>
<td class="style13" colspan="7">
<asp:Button ID="btnSubmit" runat="server" onclick="btnSubmit_Click"
Text="Submit"/>
<asp:Button ID="btnReset" runat="server" onclick="btnReset_Click" Text="Reset" ValidationGroup="xyz"/>
</td>
</tr>
</table>
aspx.cs code for first page
SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=Bart;Integrated Security=True");
SqlCommand sqlcmd;
SqlDataAdapter da;
DataTable dt = new DataTable();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["portal"] != null)
{
ddlPortal.SelectedIndex = ddlPortal.Items.IndexOf(ddlPortal.Items.FindByValue(Convert.ToString(Session["portal"])));
}
string ID = Request.QueryString["ID"];
if (ID == "")
{
Response.Write("Invalid Selection");
return;
}
sqlcmd = new SqlCommand("Select * from Form3 where ID='" + ID + "'", con);
con.Open();
da = new SqlDataAdapter(sqlcmd);
dt.Clear();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
tbid.Text = ID;
ddlPortal.SelectedValue = dt.Rows[0][1].ToString();
tbTid.Text = dt.Rows[0][2].ToString();
tbPNR.Text = dt.Rows[0][3].ToString();
tbTicketNumber.Text = dt.Rows[0][4].ToString();
tbESACCode.Text = dt.Rows[0][5].ToString();
tbWaiverCode.Text = dt.Rows[0][6].ToString();
tbRemarks.Text = dt.Rows[0][7].ToString();
tbUnusedTicketAmount.Text = dt.Rows[0][8].ToString();
ddlUnusedAmount.SelectedValue = dt.Rows[0][9].ToString();
tbAirlinePenality.Text = dt.Rows[0][10].ToString();
ddlAirlinePenality.SelectedValue = dt.Rows[0][11].ToString();
tbNetRefundProcess.Text = dt.Rows[0][12].ToString();
ddlNetRefundProcess.SelectedValue = dt.Rows[0][13].ToString();
tbRefundableCommision.Text = dt.Rows[0][14].ToString();
ddlRefundableCommission.SelectedValue = dt.Rows[0][15].ToString();
tbCouponRefund.Text = dt.Rows[0][16].ToString();
ddlRefundType.SelectedValue = dt.Rows[0][17].ToString();
}
con.Close();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=Bart;Integrated Security=True");
con.Open();
string Portal = ddlPortal.SelectedValue;
string TID = tbTid.Text;
string PNR = tbPNR.Text;
string TicketNumber = tbTicketNumber.Text;
string ESACCode = tbESACCode.Text;
string WaiverCode = tbWaiverCode.Text;
string Remarks = tbRemarks.Text;
string UnusedTicketAmount = tbUnusedTicketAmount.Text;
string UnusedAmount = ddlUnusedAmount.SelectedValue;
string AirlinePenality = tbAirlinePenality.Text;
string Airline = ddlAirlinePenality.SelectedValue;
string NetRefundProcess = tbNetRefundProcess.Text;
string NetRefund = ddlNetRefundProcess.SelectedValue;
string RefundableCommission = tbRefundableCommision.Text;
string Refundable = ddlRefundableCommission.SelectedValue;
string CouponRefunded = tbCouponRefund.Text;
string RefundType = ddlRefundType.SelectedValue;
using (SqlCommand cmd = con.CreateCommand())
{
cmd.CommandText = "insert into Form3(Portal,TID,PNR,TicketNumber,ESACCode,WaiverCode,Remarks,UnusedTicketAmount,ddlUnusedAmount, AirlinePenality, ddlAirlinePenality, NetRefundProcess, ddlNetRefundProcess, RefundableCommission, ddlRefundableCommission, CouponRefunded,RefundType) values('" + Portal + "','" + TID + "','" + PNR + "','" + TicketNumber + "', '" + ESACCode + "', '" + WaiverCode + "', '" + Remarks + "','" + UnusedTicketAmount + "','" + UnusedAmount + "','" + AirlinePenality + "','" + Airline + "','" + NetRefundProcess + "','" + NetRefund + "','" + RefundableCommission + "','" + Refundable + "','" + CouponRefunded + "','" + RefundType + "')";
cmd.Parameters.AddWithValue("@Portal", ddlPortal.SelectedIndex);
cmd.Parameters.AddWithValue("@TID", tbTid.Text.Trim());
cmd.Parameters.AddWithValue("@PNR", tbPNR.Text.Trim());
cmd.Parameters.AddWithValue("@TicketNumber", tbTicketNumber.Text.Trim());
cmd.Parameters.AddWithValue("@ESACCode", tbESACCode.Text.Trim());
cmd.Parameters.AddWithValue("@WaiverCode", tbWaiverCode.Text.Trim());
cmd.Parameters.AddWithValue("@Remarks", tbRemarks.Text.Trim());
cmd.Parameters.AddWithValue("@UnusedTicketAmount", tbUnusedTicketAmount.Text.Trim());
cmd.Parameters.AddWithValue("@ddlUnusedAmount", ddlUnusedAmount.SelectedIndex);
cmd.Parameters.AddWithValue("@AirlinePenality", tbAirlinePenality.Text.Trim());
cmd.Parameters.AddWithValue("@ddlAirlinePenality", ddlAirlinePenality.SelectedIndex);
cmd.Parameters.AddWithValue("@NetRefundProcess", tbNetRefundProcess.Text.Trim());
cmd.Parameters.AddWithValue("@ddlNetRefundProcess", ddlNetRefundProcess.SelectedIndex);
cmd.Parameters.AddWithValue("@RefundableCommission", tbRefundableCommision.Text.Trim());
cmd.Parameters.AddWithValue("@ddlRefundableCommission", ddlRefundableCommission.SelectedIndex);
cmd.Parameters.AddWithValue("@CouponRefunded", tbCouponRefund.Text.Trim());
cmd.Parameters.AddWithValue("@RefundType", ddlRefundType.SelectedIndex);
cmd.ExecuteNonQuery();
}
con.Close();
tbTid.Text = "";
tbPNR.Text = "";
tbTicketNumber.Text = "";
tbESACCode.Text = "";
tbWaiverCode.Text = "";
tbRemarks.Text = "";
tbRemarks.Text = "";
tbUnusedTicketAmount.Text = "";
tbAirlinePenality.Text = "";
tbNetRefundProcess.Text = "";
tbRefundableCommision.Text = "";
tbCouponRefund.Text = "";
lblRefundType.Text = "";
tbTid.Focus();
}
protected void ddlPortal_SelectedIndexChanged(object sender, EventArgs e)
{
Session["portal"] = ddlPortal.SelectedValue;
if (ddlPortal.SelectedValue == "TRAVELONG")
{
ddlUnusedAmount.SelectedItem.Text = "USD";
ddlUnusedAmount.Enabled = true;
ddlAirlinePenality.SelectedItem.Text = "USD";
ddlAirlinePenality.Enabled = true;
ddlNetRefundProcess.SelectedItem.Text = "USD";
ddlAirlinePenality.Enabled = true;
ddlRefundableCommission.SelectedItem.Text = "USD";
ddlRefundableCommission.Enabled = true;
}
else if (ddlPortal.SelectedValue == "ONETRAVEL")
{
ddlUnusedAmount.SelectedItem.Text = "USD";
ddlUnusedAmount.Enabled = true;
ddlAirlinePenality.SelectedItem.Text = "USD";
ddlAirlinePenality.Enabled = true;
ddlNetRefundProcess.SelectedItem.Text = "USD";
ddlAirlinePenality.Enabled = true;
ddlRefundableCommission.SelectedItem.Text = "USD";
ddlRefundableCommission.Enabled = true;
}
else if (ddlPortal.SelectedValue == ".UK-BSP")
{
ddlUnusedAmount.SelectedItem.Text = "GBP";
ddlUnusedAmount.Enabled = true;
ddlAirlinePenality.SelectedItem.Text = "GBP";
ddlAirlinePenality.Enabled = true;
ddlNetRefundProcess.SelectedItem.Text = "GBP";
ddlAirlinePenality.Enabled = true;
ddlRefundableCommission.SelectedItem.Text = "GBP";
ddlRefundableCommission.Enabled = true;
}
else if (ddlPortal.SelectedValue == ".CA-YYZ")
{
ddlUnusedAmount.SelectedItem.Text = "CAN";
ddlUnusedAmount.Enabled = true;
ddlAirlinePenality.SelectedItem.Text = "CAN";
ddlAirlinePenality.Enabled = true;
ddlNetRefundProcess.SelectedItem.Text = "CAN";
ddlAirlinePenality.Enabled = true;
ddlRefundableCommission.SelectedItem.Text = "CAN";
ddlRefundableCommission.Enabled = true;
}
else if (ddlPortal.SelectedValue == ".CA-YVR")
{
ddlUnusedAmount.SelectedItem.Text = "CAN";
ddlUnusedAmount.Enabled = true;
ddlAirlinePenality.SelectedItem.Text = "CAN";
ddlAirlinePenality.Enabled = true;
ddlNetRefundProcess.SelectedItem.Text = "CAN";
ddlAirlinePenality.Enabled = true;
ddlRefundableCommission.SelectedItem.Text = "CAN";
ddlRefundableCommission.Enabled = true;
}
}
protected void btnReset_Click(object sender, EventArgs e)
{
tbTid.Text = "";
tbPNR.Text = "";
tbTicketNumber.Text = "";
tbESACCode.Text = "";
tbWaiverCode.Text = "";
tbRemarks.Text = "";
tbRemarks.Text = "";
tbUnusedTicketAmount.Text = "";
tbAirlinePenality.Text = "";
tbNetRefundProcess.Text = "";
tbRefundableCommision.Text = "";
tbCouponRefund.Text = "";
lblRefundType.Text = "";
tbTid.Focus();
}