Hi,
i have a web page having ajaxtabcontrol tabs(add,delete,edit....), in add tab when i click OK button ,then corresponding button click event is fired,but in another tabs if i click button ,corresponding click event is not firing,every time tabcontainer's active tabchanged event is firing.
here is the code:
<pre lang="c#"><%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Admin.aspx.cs" Inherits="Online_Billing_System.Admin" %>
<%@ Register Namespace="AjaxControlToolkit" Assembly="AjaxControlToolkit" tagPrefix="ajax" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>Admin</title>
<script type="text/javascript">
function DeleteItem() {
if (confirm("Are you sure you want to delete ...?")) {
return true;
}
return false;
}
</script>
<style type="text/css">
.style1
{
width: 151px;
}
.style2
{
width: 189px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<ajax:ToolkitScriptManager ID="scriptmanager1" runat="server">
</ajax:ToolkitScriptManager>
<div style=" width:89%">
<ajax:TabContainer ID="adminTabContainer" runat="server" ActiveTabIndex="1"
AutoPostBack="true"
önactivetabchanged="adminTabContainer_ActiveTabChanged">
<ajax:TabPanel ID="tbpnladd" runat="server" ><HeaderTemplate>Add Member</HeaderTemplate>
<ContentTemplate><asp:Panel ID="AddMem" runat="server" Width="738px"><table align="center"
style="width: 651px"><tr><td></td><td align="right" ></td><td align="center">Add Member </td></tr><tr><td></td><td align="right" >Member ID: </td><td><asp:TextBox ID="txtmemid" runat="server"></asp:TextBox></td><td><asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
ErrorMessage=" Enter Member ID " ControlToValidate="txtmemid"
ForeColor="Red" ValidationGroup="addGroup"></asp:RequiredFieldValidator></td></tr><tr><td></td><td align="right" >Card ID: </td><td><asp:TextBox ID="txtcardid" runat="server" ></asp:TextBox></td><td><asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"
ErrorMessage="Enter Card ID" ControlToValidate="txtcardid" ForeColor="Red" ValidationGroup="addGroup"></asp:RequiredFieldValidator></td></tr><tr><td></td><td align="right">Name: </td><td><asp:TextBox ID="txtname" runat="server"></asp:TextBox></td><td><asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ErrorMessage="Enter Name" ControlToValidate="txtname" ForeColor="Red" ValidationGroup="addGroup"></asp:RequiredFieldValidator></td></tr><tr><td></td><td align="right">Date Of Membership: </td><td><asp:TextBox ID="txtdate" runat="server"
></asp:TextBox> </td><td><ajax:CalendarExtender ID="calendar1"
TargetControlID="txtdate" runat="server" PopupButtonID="calendar"
Format="yyyy-MM-dd" Enabled="True"></ajax:CalendarExtender></td><td class="style1"><asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ErrorMessage="Enter Date Of Membership" ControlToValidate="txtdate" ForeColor="Red" ValidationGroup="addGroup"></asp:RequiredFieldValidator></td></tr><tr><td></td><td align="right">Opening Balance: </td><td><asp:TextBox ID="txtopenbal" runat="server"></asp:TextBox></td><td><asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ErrorMessage="Enter Opening Balance" ControlToValidate="txtopenbal" ForeColor="Red" ValidationGroup="addGroup"></asp:RequiredFieldValidator></td></tr><tr><td></td><td align="right" >Phone No: </td><td><asp:TextBox ID="txtphone" runat="server"></asp:TextBox></td><td><asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ErrorMessage="Enter Phone No" ControlToValidate="txtphone" ForeColor="Red" ValidationGroup="addGroup"></asp:RequiredFieldValidator></td></tr><tr><td></td><td align="right" >Address: </td><td align="left"><asp:TextBox ID="txtaddress" runat="server"></asp:TextBox></td><td><asp:RequiredFieldValidator ID="RequiredFieldValidator7" runat="server" ErrorMessage="Enter Address" ControlToValidate="txtaddress" ForeColor="Red" ValidationGroup="addGroup"></asp:RequiredFieldValidator></td></tr><tr><td></td><td align="right">Password:</td><td align="left"><asp:TextBox ID="txtpwd" runat="server" TextMode="Password"></asp:TextBox></td><td><asp:RequiredFieldValidator ID="RequiredFieldValidator8" runat="server" ErrorMessage="Enter Password" ControlToValidate="txtpwd" ForeColor="Red" ValidationGroup="addGroup"></asp:RequiredFieldValidator></td></tr><tr><td></td><td align="right">Confirm Password</td><td align="left"><asp:TextBox ID="txtconfirmpwd" runat="server" TextMode="Password"></asp:TextBox></td><td><asp:RequiredFieldValidator ID="RequiredFieldValidator9" runat="server" ErrorMessage="Enter Confirm Password" ControlToValidate="txtconfirmpwd" ForeColor="Red" ValidationGroup="addGroup"></asp:RequiredFieldValidator></td><td><asp:CompareValidator ID="CompareValidator1" runat="server" ControlToCompare="txtpwd" ControlToValidate="txtconfirmpwd" ErrorMessage="Passwords Don't Match" ForeColor="Red" ValidationGroup="addGroup"></asp:CompareValidator></td></tr><tr><td></td><td></td><td align="left" ><asp:Button ID="btnok" runat="server" Text="OK" onclick="btnok_Click" ValidationGroup="addGroup"/><asp:Button ID="btncancel" runat="server" Text="Clear"
OnClientClick="this.form.reset();return false;" ValidationGroup="addGroup"/></td></tr></table></asp:Panel></ContentTemplate>
</ajax:TabPanel>
<ajax:TabPanel ID="tbpnledit" runat="server" ><HeaderTemplate>Edit Member</HeaderTemplate>
<ContentTemplate><asp:Panel ID="EditMem" runat="server" Width="570px"><table align="center"><tr><td align="right" colspan="2" ></td><td>Edit Member </td></tr><tr><td align="right" colspan="2">Member ID: </td><td><asp:TextBox ID="txtememid" runat="server"></asp:TextBox> </td></tr><tr><td align="right" colspan="2">Card ID: </td><td>
<asp:TextBox ID="txtecardid" runat="server" Width="119px"></asp:TextBox> </td></tr><tr><td><asp:Button ID="btneok" runat="server" Text="OK"
OnClick="btneok_Click" Font-Bold="True" Font-Names="Times New Roman"
Width="87px"/> </td><td><asp:Button ID="btnecancel" runat="server" Text="Clear"
Width="96px" OnClientClick="this.form.reset();return false;"
/></td></tr></table></asp:Panel></ContentTemplate>
</ajax:TabPanel>
<ajax:TabPanel ID="tbpnldelete" runat="server" ><HeaderTemplate>Delete Member</HeaderTemplate>
<ContentTemplate><asp:Panel ID="DeleteMem" runat="server" Width="476px"><table align="center"><tr><td></td><td align="right" ></td><td class="style1">Delete Member </td></tr><tr><td></td><td align="right">Member ID: </td><td class="style1"><asp:TextBox ID="txtdmemid" runat="server" Height="21px" Width="112px"
></asp:TextBox> </td><td></td></tr><tr><td></td><td align="right">Card ID: </td><td class="style1"><asp:TextBox ID="txtdcardid" runat="server"
></asp:TextBox> </td></tr><tr><td></td><td align="right"><asp:Button ID="btndok" runat="server" Text="OK" OnClick="btndok_Click" onclientclick="return DeleteItem()" /> </td><td class="style1"><asp:Button ID="btndcancel" runat="server" Text="Clear"
onclick="btndcancel_Click"
OnClientClick="this.form.reset();return false;" /> </td></tr></table></asp:Panel></ContentTemplate>
</ajax:TabPanel>
<ajax:TabPanel ID="tbpnlview" runat="server" ><HeaderTemplate>View Member</HeaderTemplate>
<ContentTemplate><asp:Panel ID="ViewMem" runat="server" Width="477px"><table align="center"><tr><td></td><td align="right" ></td><td class="style1">View Member </td></tr><tr><td></td><td align="right">Member ID: </td><td class="style1"><asp:TextBox ID="txtvmemid" runat="server"></asp:TextBox> </td></tr><tr><td></td><td align="right">Card ID: </td><td class="style1"><asp:TextBox ID="txtvcardid" runat="server"></asp:TextBox> </td></tr><tr><td></td><td align="right"><asp:Button ID="btnvok" runat="server" Text="OK" onclick="btnvok_Click" /> </td><td class="style1"><asp:Button ID="btnvcancel" runat="server" Text="Clear"
OnClientClick="this.form.reset();return false;"/> </td></tr></table></asp:Panel></ContentTemplate>
</ajax:TabPanel>
<ajax:TabPanel ID="tbpnlviewall" runat="server" ><HeaderTemplate>View All</HeaderTemplate>
<ContentTemplate><asp:Panel ID="ViewAllMem" runat="server" Width="210px"><asp:GridView ID="viewallGridview" runat="server" BackColor="#DEBA84"
BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px" CellPadding="3"
CellSpacing="2"><FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" /><HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" /><PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" /><RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" /><SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" /><SortedAscendingCellStyle BackColor="#FFF1D4" /><SortedAscendingHeaderStyle BackColor="#B95C30" /><SortedDescendingCellStyle BackColor="#F1E5CE" /><SortedDescendingHeaderStyle BackColor="#93451F" /></asp:GridView></asp:Panel></ContentTemplate>
</ajax:TabPanel>
<ajax:TabPanel ID="tbpnledittx" runat="server" ><HeaderTemplate>Edit Transaction</HeaderTemplate><ContentTemplate><asp:Panel ID="edittx" runat="server" Width="545px"><table align="center"><tr><td align="right" colspan="2" ></td><td>Edit Transaction </td></tr><tr><td align="right" colspan="2">Member ID: </td><td><asp:TextBox ID="txtedittxmemid" runat="server"></asp:TextBox></td></tr><tr><td align="right" colspan="2">Card ID: </td><td><asp:TextBox ID="txtedittxcardid" runat="server"></asp:TextBox></td></tr><tr><td></td><td align="right">From Date: </td><td><asp:TextBox ID="edittxfromdate" runat="server"></asp:TextBox></td><ajax:CalendarExtender ID="edittxCalendarExtender"
TargetControlID="edittxfromdate" runat="server" PopupButtonID="calendar"
Format="yyyy-MM-dd" Enabled="True"></ajax:CalendarExtender></td></tr><tr><td></td><td align="right">To Date: </td><td><asp:TextBox ID="edittxtodate" runat="server"></asp:TextBox></td><ajax:CalendarExtender ID="edittxCalendarExtender2"
TargetControlID="edittxtodate" runat="server" PopupButtonID="calendar"
Format="yyyy-MM-dd" Enabled="True"></ajax:CalendarExtender></td></tr><tr><td><asp:Button
ID="btnedittxok" runat="server" Text="OK" colspan="2" align="center"
onclick="btnedittxok_Click" /></td><td><asp:Button ID="btnedittxcancel"
runat="server" Text="Clear" OnClientClick="this.form.reset();return false;" /></td></tr></table></asp:Panel></ContentTemplate></ajax:TabPanel>
<ajax:TabPanel ID="tbpnldeletetx" runat="server" ><HeaderTemplate>Delete Transaction</HeaderTemplate><ContentTemplate><asp:Panel ID="deletetx" runat="server" Width="545px"><table align="center"><tr><td align="right" colspan="2" ></td><td>Delete Transaction </td></tr><tr><td align="right" colspan="2">Member ID: </td><td><asp:TextBox ID="txtdeltxmemid" runat="server"></asp:TextBox></td></tr><tr><td align="right" colspan="2">Card ID: </td><td><asp:TextBox ID="txtdeltxcardid" runat="server"></asp:TextBox></td></tr><tr><td></td><td align="right">From Date: </td><td><asp:TextBox ID="deltxfromdate" runat="server"></asp:TextBox></td><ajax:CalendarExtender ID="deltxCalendarExtender"
TargetControlID="deltxfromdate" runat="server" PopupButtonID="calendar"
Format="yyyy-MM-dd" Enabled="True"></ajax:CalendarExtender></td></tr><tr><td></td><td align="right">To Date: </td><td><asp:TextBox ID="deltxtodate" runat="server"></asp:TextBox></td><ajax:CalendarExtender ID="deltxCalendarExtender2"
TargetControlID="deltxtodate" runat="server" PopupButtonID="calendar"
Format="yyyy-MM-dd" Enabled="True"></ajax:CalendarExtender></td></tr><tr><td><asp:Button
ID="btndeltxok" runat="server" Text="OK" colspan="2" align="center"
onclick="btndeltxok_Click" onclientclick="return DeleteItem()"/></td><td><asp:Button ID="btndeltxcancel"
runat="server" Text="Clear" OnClientClick="this.form.reset();return false;" /></td></tr></table></asp:Panel></ContentTemplate></ajax:TabPanel>
<ajax:TabPanel ID="tbpnlsetting" runat="server" ><HeaderTemplate>Settings</HeaderTemplate>
<ContentTemplate><asp:Panel ID="settings" runat="server" Width="869px" Height="214px"><table align="center"><tr><td></td><td align="right" class="style2" ></td><td class="style1">Change Password </td></tr><tr><td></td><td align="right" class="style2">Current Password: </td><td class="style1"><asp:TextBox ID="txtcupwd" runat="server" Height="21px" Width="112px" TextMode="Password" ></asp:TextBox> </td><td><asp:RequiredFieldValidator ID="RequiredFieldValidator10" runat="server" ErrorMessage="Enter Crrent Password" ControlToValidate="txtcupwd"></asp:RequiredFieldValidator></td></tr><tr><td></td><td align="right" class="style2">New password: </td><td class="style1"><asp:TextBox ID="txtnewpwd" runat="server" TextMode="Password"></asp:TextBox> </td><td><asp:RequiredFieldValidator ID="RequiredFieldValidator11" runat="server" ErrorMessage="Enter New Password" ControlToValidate="txtnewpwd"></asp:RequiredFieldValidator></td></tr><tr><td></td><td align="right" class="style2">Confirm New password: </td><td class="style1"><asp:TextBox ID="txtreenterpwd" runat="server" TextMode="Password"></asp:TextBox> </td><td><asp:RequiredFieldValidator ID="RequiredFieldValidator12" runat="server" ErrorMessage="Enter Confirm New Password" ControlToValidate="txtreenterpwd"></asp:RequiredFieldValidator></td><td><asp:CompareValidator ID="CompareValidator2" runat="server" ErrorMessage="New Password and Confirm New Pasword must be matched" ControlToValidate="txtreenterpwd" ControlToCompare="txtnewpwd"></asp:CompareValidator></td></tr><tr><td></td><td><asp:Label ID="Label1" runat="server"></asp:Label></td></tr><tr><td></td><td align="right" class="style2"><asp:Button ID="btnsettingsok" runat="server" Text="OK" OnClick="btnsettingsok_Click" /> </td><td class="style1"> </td></tr></table></asp:Panel></ContentTemplate>
</ajax:TabPanel>
</ajax:TabContainer>
</div>
</form>
</body>
</html>
here is the code behind:
<pre lang="c#">using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.Configuration;
using MySql.Data.MySqlClient;
namespace Online_Billing_System
{
public partial class Admin : System.Web.UI.Page
{
String ConnectionString = WebConfigurationManager.ConnectionStrings["myConnectionString"].ToString();
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnok_Click(object sender, EventArgs e)
{
using (MySqlConnection con = new MySqlConnection(ConnectionString))
{
String query = "insert into admin(member_id,card_id,name,date_of_membership,opening_balance,phone_number,address,password,confirm_password) values(@memberid,@cardid,@name,@date,@balance,@phone,@address,@pwd,@confirmpwd)";
MySqlCommand command = new MySqlCommand(query,con);
command.Parameters.AddWithValue("@memberid", txtmemid.Text);
command.Parameters.AddWithValue("@cardid", txtcardid.Text);
command.Parameters.AddWithValue("@name", txtname.Text);
command.Parameters.AddWithValue("@date", txtdate.Text);
command.Parameters.AddWithValue("@balance", txtopenbal.Text);
command.Parameters.AddWithValue("@phone", txtphone.Text);
command.Parameters.AddWithValue("@address", txtaddress.Text);
command.Parameters.AddWithValue("@pwd", txtpwd.Text);
command.Parameters.AddWithValue("@confirmpwd", txtconfirmpwd.Text);
con.Open();
command.ExecuteNonQuery();
}
txtmemid.Text = "";
txtcardid.Text = "";
txtname.Text = "";
txtdate.Text = "";
txtopenbal.Text = "";
txtphone.Text = "";
txtaddress.Text = "";
}
protected void btneok_Click(object sender, EventArgs e)
{
if (txtememid.Text != "" || txtecardid.Text != "")
Response.Redirect("~/EditUser.aspx?memberid=" + txtememid.Text.Replace("&", "%26") +
"&cardid=" + txtecardid.Text.Replace("&", "%26"));
else
{
WebMsgBox.Show("PLEASE ENTER EITHER MEMBER ID or CARD ID");
}
}
protected void btndok_Click(object sender, EventArgs e)
{
if (txtdmemid.Text != "" || txtdcardid.Text != "")
{
using (MySqlConnection con = new MySqlConnection(ConnectionString))
{
String query = "delete from admin where member_id=@memid OR card_id=@card";
MySqlCommand command = new MySqlCommand(query, con);
command.Parameters.AddWithValue("@memid", txtdmemid.Text);
command.Parameters.AddWithValue("@card", txtdcardid.Text);
con.Open();
command.ExecuteNonQuery();
}
}
else
{
WebMsgBox.Show("PLEASE ENTER EITHER MEMBER ID or CARD ID");
}
}
protected void btndcancel_Click(object sender, EventArgs e)
{
Session["ViewState"] = null;
Response.Redirect("~/Admin.aspx");
}
protected void btnvok_Click(object sender, EventArgs e)
{
if (txtvmemid.Text != "" || txtvcardid.Text != "")
{
Response.Redirect("~/View.aspx?memberid=" + txtvmemid.Text.Replace("&", "%26") +
"&cardid=" + txtvcardid.Text.Replace("&", "%26"));
}
else {
WebMsgBox.Show("PLEASE ENTER EITHER MEMBER ID or CARD ID");
}
}
protected void adminTabContainer_ActiveTabChanged(object sender, EventArgs e)
{
if (adminTabContainer.ActiveTabIndex == 4)
{
using (MySqlConnection con = new MySqlConnection(ConnectionString))
{
String query = "select member_id,card_id,name,date_of_membership,opening_balance,phone_number,address,password,confirm_password from admin";
MySqlCommand command = new MySqlCommand(query,con);
con.Open();
using (MySqlDataReader rdr = command.ExecuteReader())
{
if (rdr.Read())
{
viewallGridview.DataSource = rdr;
viewallGridview.DataBind();
}
}
}
}
}
protected void btnsettingsok_Click(object sender, EventArgs e)
{
int found=0;
using (MySqlConnection con = new MySqlConnection(ConnectionString))
{
String currentpwd = txtcupwd.Text;
String query = "select * from admin";
MySqlCommand command = new MySqlCommand(query,con);
con.Open();
using (MySqlDataReader rdr = command.ExecuteReader())
{
while (rdr.Read())
{
if (currentpwd == rdr["password"].ToString())
{
found = 1;
}
}
}
if (found == 1)
{
String newquery = "update admin set password=@password where password='" + currentpwd + "'";
MySqlCommand com = new MySqlCommand(newquery, con);
com.Parameters.AddWithValue("@password", txtnewpwd.Text);
com.ExecuteNonQuery();
Label1.Text = "Password Changed Successfully";
}
else
Label1.Text = "Please Enter Correct Current Password";
}
}
protected void btnedittxok_Click(object sender, EventArgs e)
{
if ((edittxfromdate.Text != "" && edittxtodate.Text != "") && (txtedittxmemid.Text != "" || txtedittxcardid.Text != ""))
{
Response.Redirect("~/EditTx.aspx?memberid=" + txtedittxmemid.Text.Replace("&", "%26") +
"&cardid=" + txtedittxcardid.Text.Replace("&", "%26") + "&fromdate=" + edittxfromdate.Text.Replace("&", "%26") + "&todate=" + edittxtodate.Text.Replace("&", "%26"));
}
else
WebMsgBox.Show("Please Enter Details");
}
protected void btndeltxok_Click(object sender, EventArgs e)
{
String fromdate = deltxfromdate.Text;
String todate = deltxtodate.Text;
if ((deltxfromdate.Text != "" && deltxtodate.Text != "") && (txtdeltxmemid.Text != "" || txtdeltxcardid.Text != ""))
{
using (MySqlConnection con = new MySqlConnection(ConnectionString))
{
String query = "delete from transaction where DATE(paid_date)BETWEEN '" + fromdate + "'AND'" + todate + "' AND(member_id=@memberid OR card_id=@cardid)";
MySqlCommand command = new MySqlCommand(query, con);
command.Parameters.AddWithValue("@memberid", txtdeltxmemid.Text);
command.Parameters.AddWithValue("@cardid", txtdeltxcardid.Text);
con.Open();
command.ExecuteNonQuery();
}
}
else
WebMsgBox.Show("Please Enter From and To dates and Either Memberid or Cardid");
}
}
}
why it's happening am not getting.