Comments by Mythri_8 - CodeProject

Mythri_8 19-Sep-11 8:00am View

i am not able to paste my entire code as a reply to this comment

Mythri_8 19-Sep-11 7:56am View

Deleted

<asp:GridView ID="gvShortStayRate" runat="server" AutoGenerateColumns="False"
BorderColor="Black" BorderWidth="1px" DataKeyNames="Id"
DataSourceID="ShortTermRateDS" OnRowCommand="gvShortStayRate_RowCommand"
ShowFooter="True">
<columns>

<asp:TemplateField HeaderText="First night">
<edititemtemplate>
<asp:TextBox ID="Editstart_date" runat="server" Height="15px" ReadOnly="True"
Text='<%# Bind("start_date") %>' Width="65px" />
<asp:CalendarExtender ID="calstart_date" runat="server" Enabled="True" Format="dd/MM/yyyy"
PopupButtonID="img_calendarstart" TargetControlID="Editstart_date">
<asp:Image ID="img_calendarstart" runat="server" ImageUrl="Images/Calendar_scheduleHS.png" />
<asp:RequiredFieldValidator ID="RFVEditStartDate" runat="server" ControlToValidate="Editstart_date"
ErrorMessage="*" ValidationGroup="Edit">

<footertemplate>
<asp:TextBox ID="Insertstart_date" runat="server" Height="15px" ReadOnly="True"
Text='<%# Bind("start_date") %>' Width="65px" />
<asp:CalendarExtender ID="calInsertstart_date" runat="server" Enabled="True"
Format="dd/MM/yyyy" PopupButtonID="imgcalendarInsertstart"
TargetControlID="Insertstart_date">
<asp:Image ID="imgcalendarInsertstart" runat="server"
ImageUrl="Images/Calendar_scheduleHS.png" />
<asp:RequiredFieldValidator ID="RFVInsertStartDate" runat="server"
ControlToValidate="Insertstart_date" ErrorMessage="*" ValidationGroup="Insert">

<itemtemplate>

<asp:TemplateField HeaderText="Last night">
<edititemtemplate>
<asp:TextBox ID="Editend_date" runat="server" Height="15px" ReadOnly="True"
Text='<%# Bind("end_date") %>' Width="65px" />
<asp:CalendarExtender ID="calEditend_date" runat="server" Enabled="True" Format="dd/MM/yyyy"
PopupButtonID="imgcalendarEditend" TargetControlID="Editend_date">
<asp:Image ID="imgcalendarEditend" runat="server" ImageUrl="Images/Calendar_scheduleHS.png" />
<asp:RequiredFieldValidator ID="RFVEditEndDate" runat="server" ControlToValidate="Editend_date"
ErrorMessage="*" ValidationGroup="Edit">
<asp:CompareValidator ID="CVEnddate" runat="server" ControlToCompare="EditStart_date"
ControlToValidate="Editend_date" ErrorMessage="end date should be greater than start date"
Operator="GreaterThan" ValidationGroup="Edit">

<footertemplate>
<asp:TextBox ID="Insertend_date" runat="server" Height="15px" ReadOnly="True"
Text='<%# Bind("end_date") %>' Width="65px" />
<asp:CalendarExtender ID="calInsertend_date" runat="server" Enabled="True"
Format="dd/MM/yyyy" PopupButtonID="imgcalendarInserttend"
TargetControlID="Insertend_date"></

Mythri_8 2-Aug-11 9:59am View

Where should i do this in rowcommand or rowcreated or rowbind

Mythri_8 22-Jun-11 7:46am View

i know that but i need to use Bing map as my client need bing map in their website

Mythri_8 10-Jun-11 10:45am View

I modified my stored procedure as below
GO
ALTER PROCEDURE [dbo].[InsertShortTermPrice]

@xmlDoc xml

AS
BEGIN

INSERT INTO [shortTerm_pricelist]
SELECT
CAST(COLX.query.value('data(property_id)') as bigint) as propertyid,
CAST(COLX.query.value('data(start_date)') as datetime) as [start_date],
CAST(COLX.query.value('data(end_date)') as datetime) as end_date,
CAST(COLX.query.value('data(weekly_rate)') as datetime) as weekly_rate,
CAST(COLX.query.value('data(orderSeq)') as datetime) as orderSeq
FROM @xmlDoc.nodes('DocumentElement/ShortTermPrice') as TABX(COLX)

END

But i am getting error as: "Cannot find either column "COLX" or the user-defined function or aggregate "COLX.query.value", or the name is ambiguous."
Can i know y am i getting this error

Comments by Mythri_8 (Top 5 by date)