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

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


<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
        <br />
        <br />
        <br />
        <asp:HyperLink ID="HyperLink13" runat="server" NavigateUrl="~/SalesOrder.aspx">Sales Order
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
        <br />
    

<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:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:sqlserverConnectionString %>" 
        SelectCommand="SELECT [Customer_Id] FROM [CustomerTable_]">
    
    </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:SqlDataSource ID="SqlDataSource2" runat="server" 
        ConnectionString="<%$ ConnectionStrings:sqlserverConnectionString %>" 
        SelectCommand="SELECT [Productcode] FROM [Products]">
    </td>
</tr>
<tr>
<td align="right">Price</td>
<td>
    <asp:TextBox ID="txtp" runat="server">
    </td>
</tr>
<tr>
<td align="right">Quantity</td>
<td>
    <asp:TextBox ID="txtq" runat="server">
    <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" 
        ErrorMessage="*" ForeColor="Red" ControlToValidate="txtq">
    </td>
</tr>
<tr>
<td align="right">Total</td>
<td>
    <asp:TextBox ID="txttotal" runat="server">
    <input type="button" name="total" value="add" onclick="GetTotal()" />
    
    
    
    </td>
</tr>
<tr>
<td align="right">Date Of Delivery</td>
<td>
    <asp:TextBox ID="txtdate" runat="server">
   
    <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" />
    
    
    </td>
</tr>
<tr>
<td colspan="2" align="center">

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

</td>
</tr>
</table>


C#
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
Updated 30-Apr-14 21:47pm
v2
Comments
Sampath Lokuge 1-May-14 9:39am    
Which JS function do you need to call? For what ?
j snooze 1-May-14 17:33pm    
More info needed. Do you need to know how to write javascript in the xhtml? Or call a javascript function from your c# code behind?
v.latha 5-May-14 8:05am    
I got the answer

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