Click here to Skip to main content
15,887,585 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I,ve used AJAX calender extender to enter date but after adding this contol my button does nothing on click event.

my code is

ASPX.

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>


<script type ="text/javascript">
function Code() {

alert('Vendor Code already Exists')


}
</script>






<asp:CalendarExtender ID="TaxUpto_CalendarExtender" runat="server" Enabled="True" TargetControlID="TaxUpto" Format="dd/MM/yyyy">

<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
<asp:DropDownList ID="VehicleType" runat="server">
<asp:ListItem>Select
<asp:ListItem>Company Vehicle
<asp:ListItem>Vendor Vehicle
<asp:ListItem>Market Vehicle


<asp:TextBox ID="Code" runat="server">
<asp:TextBox ID="VehicleNo" runat="server">
<asp:TextBox ID="TaxUpto" runat="server">
<asp:Button ID="btnButton" runat="server" Text="Create" OnClick="btnButton_Click" />



C#








protected void btnButton_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["amitpandeyConnectionString"].ConnectionString);
SqlCommand com1;
string str1;
con.Open();
str1 = "select * from VendorMaster where Code='" + Code.Text.Trim() + "'";
com1= new SqlCommand(str1, con);
SqlDataReader reader = com1.ExecuteReader();

if (reader.Read())
{

ScriptManager.RegisterStartupScript(this, this.GetType(), "ShowSuccess", "javascript:Code()", true);
}

else
{

con.Open();
SqlCommand cmd = new SqlCommand("insert into VendorMaster values('" + VehicleType.Text + "','" + Code.Text + "','" + VehicleNo.Text + "','" + TaxUpto.Text + "')", con);
cmd.ExecuteNonQuery();
con.Close();

}
}
Posted
Comments
Richard Deeming 15-May-15 8:07am    
Your code is vulnerable to SQL Injection[^].

NEVER use string concatenation to build a SQL query. ALWAYS use a parameterized query.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900