这是我的页面我调用Javascript函数。但它没有用。请帮助我。请 [英] This Is My Page I 'M Calling Javascript Function . But It 'S Not Working.Please Help Me.Please Please

问题描述

<%@ 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, Even tArgs 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();



}







}

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();

}



}

推荐答案

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 [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:sqlserverConnectio nString %>\"

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>

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.Re gisterClientScriptBlock(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();



}







}

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();

}



}

Could you replace the below line

Could you replace the below line

<input type="button" name="total" value="add" onclick="javascript:GetTotal()" />

with

with

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

or try with

or try with

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

Hope it helps :)



if not then also try to replace your function with:

Hope it helps :)

if not then also try to replace your function with:

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;
            }
 
        }

这篇关于这是我的页面我调用Javascript函数。但它没有用。请帮助我。请的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！