Comments by amritha444 (Top 48 by date)

thanks RyanDev . This is wht im looking for :) :)

thnks Sergey Alexandrovich Kryukov for the response
i knw importance of keeping unique row .this is existing live db cant make such changes now. through front value never duplicate.problem is that i exported table twice . im searching for a delete query to do this.

thanks OriginalGriff
its working well

of course :)

Great effort Maciej Los
thanks a million

only error changed
Msg 242, Level 16, State 3, Line 6
The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

here is some of column values
24/5/2013
24/5/2013
2/7/2013
2/7/2013
25/6/2013
25/6/2013
6/6/2013
27/5/2013

when i tried to run
SELECT CAST(ProgressDate AS DATE) FROM MG_AssignedActivity
same error shows
Msg 241, Level 16, State 1, Line 1
Conversion failed when converting date and/or time from character string.

my code
declare @StartingDate datetime
declare @EndDate datetime
set @StartingDate='02/02/2013'
set @EndDate='09/25/2013'

SELECT MG_Activity.ActivityId,CASE MG_Activity.FolderName WHEN 'Empty' THEN ' ' ELSE MG_Activity.FolderName END AS FolderName, MG_Activity.ActivityName,
MG_ActivityParent.ParentId, MG_Activity.ActivityDate, MG_Activity.Description AS Note, MG_Activity.AdminId, MG_Activity.Status,
MG_Activity.IsActive, MG_Activity.Priority, MG_AssignedActivity.UserId, MG_Users.FirstName AS UserName, MG_AssignedActivity.AssignId,
MG_AssignedActivity.Progress, REPLACE(CONVERT(varchar, MG_AssignedActivity.Duration, 103), '-', '/') AS DueDate, MG_AssignedActivity.StartingDate,
MG_AssignedActivity.ProgressDate, CASE MG_ActivityDate.SubTask WHEN 0 THEN 'Create Sub Task' ELSE 'Sub Task' END AS SubTask

FROM MG_Meeting_Group INNER JOIN
MG_Meeting_ActionItem ON MG_Meeting_Group.GroupID = MG_Meeting_ActionItem.GroupID INNER JOIN
MG_Meeting_SubGroup ON MG_Meeting_ActionItem.SubGroupID = MG_Meeting_SubGroup.SubGroupID RIGHT OUTER JOIN
MG_Activity INNER JOIN
MG_AssignedActivity ON MG_Activity.ActivityId = MG_AssignedActivity.ActivityId INNER JOIN
MG_Users ON MG_AssignedActivity.AdminId = MG_Users.UserID INNER JOIN
MG_ActivityParent ON MG_Activity.ActivityId = MG_ActivityParent.ActivityId INNER JOIN
MG_ActivityDate ON MG_Activity.ActivityId = MG_ActivityDate.ActivityId ON
MG_Meeting_ActionItem.ActivityID = MG_Activity.ActivityId LEFT OUTER JOIN
MG_Meeting_Meeting ON MG_Meeting_ActionItem.MeetingID = MG_Meeting_Meeting.MeetingID

where @StartingDate is null or @EndDate is null OR CONVERT(DATETIME,MG_AssignedActivity.ProgressDate,112) BETWEEN @StartingDate AND @EndDate
data in ProgressDate field is in dd/mm/yyyy format .but that columns contains null values also will it make any issue?

thanks for the reply

error message showing as
Conversion failed when converting date and/or time from character string

doing modification in a project . lot of data in that table.i know this is wrong design but somebody else done so . i just want to make a report . how to do this

thanks for the response
I tried this but not working. Tried to findout error with IE browser got error as
Object doesn't support property or method 'autocomplete'

thanks for the response
Not getting any error.Problem is autofill not appearing .its working well in page without masterpage

Yes I already gave full access to D:/Share/photo1".I can copy a file from local machine to the same machines another folder well.problem happening when copying from network folder

thanks for the response
But this output is not what im looking for

for a input fromdate and to date i want to split as i mentioned in my question. i have an input from date and to this have a difference of more than one month.
for an input 1/1/2013 and 8/4/2013 i want output as
fromdate to date
1/1/2013 31/1/2013
1/2/2013 28/2/2013
1/3/2013 31/2/2013
1/4/2013 8/4/2013

i understand what you meant .I added a ~/ before returnurl and its working fine. thanks Ankur

Hi Zaf
Yes i have used one xml file for entire application
Yes sitemap path not changes when going from different pages.
this is the sitemap used in master page
<asp:SiteMapDataSource ID="SiteMapDataSource1" runat="server" />
<asp:SiteMapPath ID="SiteMap1" runat="server" Font-Names="Verdana"
Font-Size="0.9em" PathSeparator=" > ">
<PathSeparatorStyle Font-Bold="True" ForeColor="#990000" />
<currentnodestyle forecolor="#6699ff">
<nodestyle font-bold="True" forecolor="#990000">
<rootnodestyle font-bold="True" forecolor="#003300">
i already explained about xml.

hi Zaf
I placed sitemap in master page.My issue is that i cant show correct path when navigate to samepage ticket details from differnt pages. only first navigation path follows

hi thanks for the response im redirecting to same page from different pages .for eg from different pages there is navigation to ticket details page.when going from dashboard to ticketdetails site map as applications>dashboard>ticketdetails.but i have another page my tickets from this page when im navigating to ticket details page it appearing as applications>dashboard>ticketdetails.instead i want applications>dashboard>My tickets>ticketdetails

Thank you Griff datetime.tryparseexact concept helped to resolve my problem now its working in both development production system

its not the pblm of update progress instead code written inside button click.when i corrected mail code its working well

hi all
Thanks for the response.I got solution as
if you are using any antivirus software check it's log to see whether it is because of the antivirus. I faced same problem when McAffee was blocking my mails (there is a security policy - Prevent mass mailing worms from sending mails). Edit this policy and add your application to the exception list. In my case this sorted the problem. Please check if it works for you.

Thanks for the response
getting error as sending mail failed and getting inner exception as cannot connect to remote server. Which is working well in my system problem arising when i add this to server.we enabled that port and disabled firewall of server.What correct in network connection

which is working well in my local system.problem when i add this to iis of server machine..all other ajax controls i used like tab,auto fill,modal popup working well.. I need that control beause sending email and sms along with adding . Adding also not take place..

hi all
thanks for the response
the code used is

<asp:UpdateProgress ID="UpdateProgress1" AssociatedUpdatePanelID="UpdatePanel1" runat="server">

<ProgressTemplate>
<div id="dvProgress" runat="server" style="position:absolute; top: 100px;
left: 300px; text-align:center;">
<asp:Image ID="Image2" runat="server" Height="200px" Width="200px"
ImageUrl="../User/images/mainl.gif" />
</div>
</ProgressTemplate>

<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<contenttemplate>

Hi Thanks for the response i want recursive query for below pasted code

if (i == 1)
{
parentNode = new TreeNode(s);

}
else if(i==2)
{
TreeNode chilnode = new TreeNode(s);
parentNode.ChildNodes.Add(chilnode);
}
else if (i == 3)
{
TreeNode chilnode1 = new TreeNode(s);
parentNode.ChildNodes[0].ChildNodes.Add(chilnode1);
}
else if (i == 4)
{
TreeNode chilnode2 = new TreeNode(s);
parentNode.ChildNodes[0].ChildNodes[0].ChildNodes.Add(chilnode2);
}

HiThanks for the response

I tried order by but no change for the order as it not a number or date. I cant change database as this query writing for a old software

hithanks for the response

I want that Row only

Thanks VJ Reddy
This is what i want

HiThis working well in my system.Problem happening when installed to client machine.Loding report failed showing.Where i installed crystal report redistribution package 2008 for crystal report.Other than this only .NET framework and sqlserver in client machine.what may be the problem??

Thanks in Advance
Amrutha

thanks for the valuable advice .i will discuss this with my senior engineer

using .net binding menu in windows forms

hi
this line is throwing exception
MenuItem Parent_menu = new MenuItem( row["Name_tb"].ToString(), secondMenu);

I want algoritham .i have table design.i want to code to bind menu and submenu according to above mentioned table

from_locationId and to_locationId are two fields in accounts table having foreign key reference with location table.this two fields in accounts table having ids from location master .same for division

I DONT WANT ANY DB CODE TO RETRIEVE PRODUCT INFORMATION WHEN I TYPE PRODUCT CODE IN FIRST COLUMN CORRESPONDING PRODUCT NAME SHOULD COME IN THE NEXT COLOUMN .WHERE TO WRITE CODE FOR THE SAME IN CELL_LEAVE EVENT OR SOMTHING LIKE THAT? HOW TO GET EACH CELL ID.

i want to do it through windows based application

no problem...its working fine now..
thank you

hi Uma
i tried your code..but the viedo didnt plays..what may be the reason

where is that in main menu ..

please specify