Click here to Skip to main content
15,908,634 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
XML
<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="SalesOrder.aspx.cs" Inherits="SalesOrder" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">

    <script type="text/javascript" language="javascript">

        function GetTotal() {
            var val1 = document.forms("form1")['txtq'].value;
            alert("price");
            alert(val1);
            var val2 = document.forms("form1")['txtp'].value;
            alert(val2);
            if (val1 != "" && val2 != "") {
                document.forms("form1")['txttotal'].value; = val1 * val2;

            }

        }
    </script>

</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder3" Runat="Server">
    <asp:Panel ID="Panel1" runat="server">
        <br />
        <asp:HyperLink ID="HyperLink12" runat="server" NavigateUrl="~/Customer.aspx">Customer Details</asp:HyperLink>
        <br />
        <br />
        <br />
        <asp:HyperLink ID="HyperLink13" runat="server" NavigateUrl="~/SalesOrder.aspx">Sales Order</asp:HyperLink>
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
    </asp:Panel>
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="ContentPlaceHolder2" Runat="Server">

<table>

<tr>
<td align="right">Customer ID</td>
<td>
    <asp:DropDownList ID="ddlcid" runat="server" DataSourceID="SqlDataSource1"
        DataTextField="Customer_Id" DataValueField="Customer_Id" AppendDataBoundItems="true">
        <asp:ListItem>---select Customer id---</asp:ListItem>
    </asp:DropDownList>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:sqlserverConnectionString %>"
        SelectCommand="SELECT [Customer_Id] FROM [CustomerTable_]">
    </asp:SqlDataSource>
    </td>
</tr>
<tr>
<td align="right">Product Id</td>
<td>
    <asp:DropDownList ID="ddlpid" runat="server" DataSourceID="SqlDataSource2"
        DataTextField="Productcode" DataValueField="Productcode"
        AppendDataBoundItems="true"
        onselectedindexchanged="ddlpid_SelectedIndexChanged" AutoPostBack="True">
        <asp:ListItem>---select Product Id---</asp:ListItem>
    </asp:DropDownList>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server"
        ConnectionString="<%$ ConnectionStrings:sqlserverConnectionString %>"
        SelectCommand="SELECT [Productcode] FROM [Products]"></asp:SqlDataSource>
    </td>
</tr>
<tr>
<td align="right">Price</td>
<td>
    <asp:TextBox ID="txtp" runat="server"></asp:TextBox>
    </td>
</tr>
<tr>
<td align="right">Quantity</td>
<td>
    <asp:TextBox ID="txtq" runat="server"></asp:TextBox>
    <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
        ErrorMessage="*" ForeColor="Red" ControlToValidate="txtq"></asp:RequiredFieldValidator>
    </td>
</tr>
<tr>
<td align="right">Total</td>
<td>
    <asp:TextBox ID="txttotal" runat="server"></asp:TextBox>
    <input type="button" name="total" value="add" onclick="javascript:GetTotal()" />



    </td>
</tr>
<tr>
<td align="right">Date Of Delivery</td>
<td>
    <asp:TextBox ID="txtdate" runat="server"></asp:TextBox>

    <asp:Calendar ID="Calendar1"
        runat="server" BackColor="White" BorderColor="#999999" CellPadding="4" BorderWidth="2px"
        DayNameFormat="Shortest" Font-Names="Verdana" Font-Size="8pt" ForeColor="Black"
        Height="180px" Width="200px"
        onselectionchanged="Calendar1_SelectionChanged">
        <DayHeaderStyle BackColor="#CCCCCC" Font-Bold="True" Font-Size="7pt" />
        <NextPrevStyle VerticalAlign="Bottom" />
        <OtherMonthDayStyle ForeColor="#808080" />
        <SelectedDayStyle BackColor="#666666" Font-Bold="True" ForeColor="White" />
        <SelectorStyle BackColor="#CCCCCC" />
        <TitleStyle BackColor="#999999" BorderColor="Black" Font-Bold="True" />
        <TodayDayStyle BackColor="#CCCCCC" ForeColor="Black" />
        <WeekendDayStyle BackColor="#FFFFCC" />
    </asp:Calendar>

    </td>
</tr>
<tr>
<td colspan="2" align="center">

    <asp:Button ID="btnsubmit" runat="server" Text="Submit"
        onclick="btnsubmit_Click" />

</td>
</tr>
</table>
</asp:Content>









using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

public partial class SalesOrder : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

// ScriptManager.RegisterClientScriptBlock(this,this.GetType(),"hi","GetTotal()",true);
}
protected void Calendar1_SelectionChanged(object sender, EventArgs e)
{
System.DateTime myDate = new System.DateTime();
myDate = Calendar1.SelectedDate;
txtdate.Text = myDate.ToString("dd/MM/yyyy");
}


protected void btnsubmit_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=CKRBTECH\\SQLEXPRESS;Initial Catalog=sqlserver;Integrated Security=True");

SqlCommand cmd = new SqlCommand("insert into Sales_Order(CustomerId,ProductId,Price,Quantity,Total,Date_Of_Deliver)values(@custid,@prodid,@price,@qty,@tot,@date) ", con);
cmd.Parameters.AddWithValue("@custid", ddlcid.SelectedItem.ToString());
cmd.Parameters.AddWithValue("@prodid", ddlpid.SelectedItem.ToString());
cmd.Parameters.AddWithValue("@price", txtp.Text.ToString());
cmd.Parameters.AddWithValue("@qty", txtq.Text.ToString());
cmd.Parameters.AddWithValue("@total", txttotal.Text.ToString());
cmd.Parameters.AddWithValue("@date", txtdate.Text.ToString());
con.Open();
cmd.ExecuteNonQuery();
con.Close();
Response.Write("data inserted successfully");

}

protected void ddlpid_SelectedIndexChanged(object sender, EventArgs e)
{
showdata(ddlpid.SelectedItem.Value);
}
private void showdata(string id)
{
DataTable dt = new DataTable();
SqlConnection con = new SqlConnection("Data Source=CKRBTECH\\SQLEXPRESS;Initial Catalog=sqlserver;Integrated Security=True");
SqlCommand cmd = new SqlCommand("select Price from Products where Productcode=@prodid", con);
cmd.Parameters.AddWithValue("@prodid", ddlpid.SelectedItem.Value);
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
if (dt.Rows.Count > 0)
{
txtp.Text = dt.Rows[0]["Price"].ToString();
}


con.Close();

}



}
Posted

Could you replace the below line
HTML
<input type="button" name="total" value="add" onclick="javascript:GetTotal()" />

with
ASP.NET
<asp:button id="btnTotal" text="add" runat="server" onclientclick="return GetTotal();"/>


or try with
HTML
<input type="button" name="total" value="add" onclick="return GetTotal();" />


Hope it helps :)

if not then also try to replace your function with:

JavaScript
function GetTotal() {
            var val1 = document.getElementById('<%=txtq.ClientID%>').value;
            var val2 = document.getElementById('<%=txtp.ClientID%>').value;
            if (val1 != "" && val2 != "") {
                document.getElementById('<%=txttotal.ClientID%>').value = val1 * val2;
            }
 
        }
 
Share this answer
 
v3
Comments
v.latha 1-May-14 7:10am    
I replaced the button. But its not working
Sanket Saxena 1-May-14 7:12am    
did you tried both the options?
v.latha 1-May-14 7:19am    
ya
Sanket Saxena 1-May-14 7:23am    
put an alert just after the method start. Seems like the issue is in the line <br><br>
"var val1 = document.forms("form1")['txtq'].value;"<br><br>
If alert works then try to replace the above line with <br><br>
var val1 = document.getElementByID('txtq').value;<br>
(apply for all the 3 tags u have used)
v.latha 1-May-14 7:32am    
alert is working.I already try that var var1=document.getElementId('txtq').value;
In this case also it doesn't take the values.
Replace your function with following code :

JavaScript
function GetTotal() {
           var val1 = document.getElementById('txtq').value;
           alert('price');
           alert(val1);
           var val2 = document.getElementById('txtp').value;
           alert(val2);
           if (val1 != '' && val2 != '') {
               document.getElementById('txttotal').value; = val1 * val2;

           }

       }


Let me know if you required more information
 
Share this answer
 
Comments
v.latha 1-May-14 7:49am    
I already tried that.

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