Comments by v.latha - CodeProject

v.latha 5-May-14 8:05am View

I got the answer

v.latha 5-May-14 7:52am View

thanks

v.latha 5-May-14 7:05am View

and this is my stored procedure
ALTER PROCEDURE sp_quantity
(@cid nvarchar(50),@prodid nvarchar(50),@price money,@qty nvarchar(50),@total money,@date date,@status nvarchar(50),@error varchar(500) OUT)
/*
(
@parameter1 int = 5,
@parameter2 datatype OUTPUT
)
*/
AS
begin
if exists(select quantity from Products where quantity=@qty)
begin
insert into Sales_Order
(
CustomerId,
ProductId,
Price,
Quantity,
Total,
Date_Of_Deliver,
Status)
values
(@cid,
@prodid,
@price,
@qty,
@total,
@date,
@status)
set @error='registered successfully'
end
else
begin
set @error='quantity doesnot exist'

end
end

/* SET NOCOUNT ON */
RETURN

v.latha 5-May-14 5:19am View

yes I got the answer

v.latha 3-May-14 3:47am View

I have two tables products table and sales order table
when I insert the data in sales order in the page if the quantity is doesnot exist in products i want to show error message

v.latha 2-May-14 7:47am View

Deleted

why didn't you give the reply

v.latha 2-May-14 7:38am View

Deleted

hello vachinda

v.latha 2-May-14 7:37am View

Deleted

nanu msg chasa ne mobile ki

v.latha 2-May-14 7:33am View

Deleted

nee mobile muber address madhya pradesh ani undi

v.latha 2-May-14 7:31am View

Deleted

nuvvu ippudu ekkada unnavu

v.latha 2-May-14 7:20am View

Deleted

hmm ne mobile number tesukunna

v.latha 2-May-14 7:17am View

Deleted

na mail id tesukunnavu kada

v.latha 2-May-14 7:14am View

Deleted

ha k

v.latha 2-May-14 7:12am View

Deleted

I know only telugu,english

v.latha 2-May-14 7:05am View

Deleted

thank you

v.latha 2-May-14 7:01am View

k

v.latha 2-May-14 6:59am View

Deleted

hmmm k

v.latha 2-May-14 6:57am View

Deleted

please I need job if ur company have openings please kindly inform me this is my mail id vadicharla.swarnalatha@gmail.com

v.latha 2-May-14 6:55am View

Deleted

how to delete

v.latha 2-May-14 6:54am View

Deleted

at nareshIT

v.latha 2-May-14 6:45am View

Deleted

thanks you so much

v.latha 2-May-14 6:45am View

Deleted

yes,I completed my course and now I'm staying at sanathnagar. And I'm doing internship.

v.latha 2-May-14 6:34am View

Deleted

2012 passed out

v.latha 2-May-14 6:34am View

Deleted

B.Tech

v.latha 2-May-14 6:32am View

Deleted

hello please

v.latha 2-May-14 6:30am View

Deleted

are there any openings in your company

v.latha 2-May-14 6:28am View

Deleted

I'm searching for job,now I'm doing internship.In which company you working.

v.latha 2-May-14 6:27am View

Deleted

I didn't take the toolkitscriptmanager that's why showing error

v.latha 2-May-14 6:25am View

Deleted

are you working in any company

v.latha 2-May-14 6:24am View

Deleted

I'm from hyderabad

v.latha 2-May-14 6:23am View

Deleted

first download the toolkit and extract the file, then goto asp page inside the toolbox add new tab and right click on that tab click choose items and it showing one window and click on browse button and go to your saved toolkit folder in your computer and open that and select AjaxControlToolkit.dll and click add button and then click ok then all controls are showed in your tool box

v.latha 2-May-14 6:07am View

kk its working fine

v.latha 2-May-14 6:04am View

I reinstalled the toolkit but I have same problem

v.latha 2-May-14 5:53am View

Deleted

no

v.latha 2-May-14 5:22am View

k I'll reinstall that

v.latha 2-May-14 5:21am View

Deleted

now also it showing error

v.latha 2-May-14 5:11am View

ya,how it works in master content pages

v.latha 2-May-14 5:06am View

no i didn't forget it has in page but in posting it doesn't showing the ending tag

v.latha 2-May-14 5:05am View

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="SalesOrder.aspx.cs" Inherits="SalesOrder" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">

<script type="text/javascript" language="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;
}

}

</script>

<style type="text/css">
.style9 {
height: 34px;
}
</style>

<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" class="style9">Total</td>
<td class="style9">
<asp:TextBox ID="txttotal" runat="server">
<asp:Button ID="add" runat="server" Text="add" OnClientClick="return GetTotal();" />
</td>
</tr>
<tr>
<td align="right">Date Of Delivery</td>
<td>

<asp:TextBox ID="txtdate" runat="server">
<ajaxtoolkit:CalenderExtender runat="server" >

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

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

</td>
</tr>
<

v.latha 2-May-14 5:03am View

geting error

v.latha 2-May-14 5:02am View

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="SalesOrder.aspx.cs" Inherits="SalesOrder" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">

<script type="text/javascript" language="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;
}

}

</script>

<style type="text/css">
.style9 {
height: 34px;
}
</style>

<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" class="style9">Total</td>
<td class="style9">
<asp:TextBox ID="txttotal" runat="server">
<asp:Button ID="add" runat="server" Text="add" OnClientClick="return GetTotal();" />
</td>
</tr>
<tr>
<td align="right">Date Of Delivery</td>
<td>

<asp:TextBox ID="txtdate" runat="server">
<ajaxtoolkit:CalenderExtender runat="server" >

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

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

</td>
</tr>
<

v.latha 2-May-14 5:01am View

this is my page but now when i'm trying to put the ajaxcalenderextender control getting error

v.latha 2-May-14 4:58am View

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="SalesOrder.aspx.cs" Inherits="SalesOrder" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">

<script type="text/javascript" language="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;
}

}

</script>

<style type="text/css">
.style9 {
height: 34px;
}
</style>

<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" class="style9">Total</td>
<td class="style9">
<asp:TextBox ID="txttotal" runat="server">
<asp:Button ID="add" runat="server" Text="add" OnClientClick="return GetTotal();" />
</td>
</tr>
<tr>
<td align="right">Date Of Delivery</td>
<td>

<asp:TextBox ID="txtdate" runat="server">
<ajaxtoolkit:CalenderExtender runat="server" >

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

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

</td>
</tr>
<

v.latha 2-May-14 4:53am View

I'm getting error creating control

v.latha 2-May-14 4:51am View

but now also it didn't take the control in content page

v.latha 2-May-14 4:50am View

ya I used this register tag

v.latha 2-May-14 4:39am View

see my web.config file is it right or not

v.latha 2-May-14 4:34am View

but when I'm taking the control to content page it showing error
Error Creating Control - ajaxtoolkit:calenderextenderUnknown server tag 'ajaxtoolkit:CalenderExtender'.

v.latha 2-May-14 4:33am View

I already installed the toolkit

v.latha 1-May-14 8:07am View

thank you so much its working. really thanks

v.latha 1-May-14 7:49am View

I already tried that.

v.latha 1-May-14 7:48am View

ok

v.latha 1-May-14 7:47am View

here is my page

<%@ 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() {
alert("hi");
var val1 = document.getElementById('txtq').value;
alert(val1);
var val2 = document.getElementById('txtp').value;
alert(val2);
if (val1 != "" && val2 != "") {
document.getElementById('txttotal').value = val1 * val2;

}

}
</script>

<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">
<asp:Button ID="add" runat="server" Text="add" OnClientClick="return 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">

v.latha 1-May-14 7:39am View

now also its not working

v.latha 1-May-14 7:32am View

alert is working.I already try that var var1=document.getElementId('txtq').value;
In this case also it doesn't take the values.

v.latha 1-May-14 7:21am View

once please try in your system.

v.latha 1-May-14 7:19am View

ya

v.latha 1-May-14 7:10am View

I replaced the button. But its not working

Comments by v.latha (Top 58 by date)