Hi I have table Table1 contains SerialNumber, Name, City ,State SerialNumber, Name, City , State 1 ABC Dallas TX 2 BCD VCDFV NY 3 ABC Dallas TX Here I want to get the max of the serialnumber with if same combination of Name, City ,State is repeated , here 1 and 3 repeted , Please suggest how can I do this Thanks,
S
salmonraju
@salmonraju
Posts
-
select statement group by -
LINQ Help requiredHi , I have an application that will collect data from user (entering time sheet data) so the status of Time sheet can be any of the following 1. Open 2. Saved 3. submited 4. Under Review 5. Approvred. 6. Reject I am displaying a report on this data. Consider a case where user daily saving his time sheet but not submitting. My report will be like below Userid Date Status. 111 Date1 Open 111 Date1 Saved 111 Date1 Saved 111 Date2 Saved 111 Date3 Saved 111 Date4 Submitted 111 Date5 Under Review 111 Date6 Under Review 111 Date7 Under Review 111 Date7 Reject 111 Date7 Saved 111 Date7 Saved 111 Date7 submit : : Above are actual events done on the user time sheet . It looks like that duplicate data saved but it is displaying all the events. My requirement is to delete duplicate records if the current and previous records are having the same status . I can do his by looping through all the records using "for" by cecking previous and curent satus. But i want this is to be done in diffrent way, Can anyone suggest if we can use LINQ for this, if so please suggest me. Thanks,
-
Window.open HelpHi, I have an application that uses frames. I am calling a method in parent frame as below.(below method is in child frame) function my MyChild() { var pth = window.location.href; //http://localhost/Main/SUB/Child.aspx[^] parent.frames["MainFrame"].MainMethod(); } below is my function in parent Frame, and I am trying to open a new window but that is opening new page in child location I am using below code , is ter any way so that I can track the URL it is trying to open. function MainMethod() { var path=window.location.href; //below is the value //http://localhost/Main/Parent.aspx[^] window.open("Newpage.aspx"); //it is opening in http://localhost/Main/SUB/NewPage.aspx[^] But I am expecting it will open in http://localhost/Main/NewPage.aspx[^] } Please suggest how Can i get the URl path it is trying to open, since window.location.href is giving differnt value. Thanks,
-
HTML Select tagHi I have an application that uses html select tag. My application provides different font sizes. When I am selecting font size which is more than current value. My HTML Select tag is enlarging accordingly but when I am reducing font size , my select tag is not reducing accordingly. I am still seeing large dropdown image. Can you please suggest how can i reduce drop down size. Please find below example. <html> <script language="javascript"> function ok_clicked() { document.getElementById('sel1').style.fontSize = 17; } function ok2_clicked() { document.getElementById('sel1').style.fontSize = 9; } </script> <body> <select id="sel1" style="font-size: 13px;"> <option>Volvo</option> <option>Saab</option> <option>Mercedes</option> <option>Audi</option> </select> <input type="button" name="Go2224" value="OK" onClick="ok_clicked();"> <input type="button" name="Go2222" value="Decrease font" onClick="ok2_clicked();"> </body> </html>
-
p3p HeaderHi, Can any one please suggest me how can I set p3p header in HTML page. I have an application (say domain is www.abc.com) that will load my page "mypage.html" in Iframe( with domain xyz.com). My page is HTML page , in my HTML page I am invoking some other html page say "ExternalPage.html" page with domain PQR.com , Here i have to pass cookies from HTML page (mypage.html) to external page "ExternalPage.html". Since both are different domain ,I am unable to set cookie . I am using below code in mypage.html to allow cookies to set but it is not working . Can anyone please suggest on this. <meta http-equiv="P3P" content='CP="CNT"'/> Thanks, Salmon.
-
print issueHI thanks for your reply, Currently I am using one style sheet that doesnot have any media attribute. Do i need to add one more style sheet with same CSS class names with media attribute as Print. Please suggest
-
print issueHi I have an application that will display text context(Ex: Questions and Answers). My application has an option to display "Black text on white Background" or "White text on Black Background". We are also providing Print function to print text. I am facing an issue here , when I am printing when the mode is "White text on Black Background" i am still seeing printed content as "Black text on white Background" on some machines (very few) with same IE version. Can we restrict styles when we are printing using Javascript. I am using below javascript for printing. document.frames['My_frame'].focus(); document.frames['My_frame'].print(); Thanks, Salmon.
-
Ajax ErrorHi, I am using ajax for my existing VS 2005 Web application. I have applied all the necessary modification to Web.config. My application is working fine when we opening the page. We are also providing Back and Forward links to user ( similar to browser Back and Forward for history) . When user visits 2nd page, we are saving the generated HTML of first page into a java script variable .like below. var html = document.frames[“MyFrame”].document.documentElement.outerHTML; when user clicks on Back link we displaying the page from stored java script variable. Like below var doc = document.frames[“MyFrame”].document.open(); doc.write(html); Here we are getting error saying “Microsoft JScript runtime error: 'Sys' is undefined”. Sys.WebForms.PageRequestManager._initialize('ctl00', document.getElementById('Form1')); Thanks, Salmon
-
Adding scriptManager tag to Non ajax enabled web applicationThank you I will do that
-
Adding scriptManager tag to Non ajax enabled web applicationHi, My application is created using ASP.Net Web Application template. I want script Manager to be added in one of my page. I did the following to make My existing ASP.Net web application to Ajax enabled. But it is not working. Installed ASPAJAXExtSetup.msi added below config in web.config <httpHandlers> <remove verb="*" path="*.asmx"/> <add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/> <add verb="GET" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler" validate="false"/> </httpHandlers> <compilation defaultLanguage="c#" debug="true"> <assemblies> <add assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/> </assemblies> </compilation> When i am tring to add a <asp:ScriptManager runat="server" /> Under form tag , I am not getting this tag in intellisence. Please help how I can add scriptManager to my existing ASp.net web application. Thanks, Salmon.
-
Div Alignment.Hi Richard, Can you please provide what code i need to implement to fix this Issue. Please suggest. Thanks,
-
Div Alignment.Hi dave/Tony, Thanks for your reply I am using below in Div tag <div id="divID" style="z-index:1000;width: 160; right:50px; top:60px; display: none;position:absolute;"> It looks ok. My problem is one control is there Behind Div ,sometimes the control Text is overlapping with Div control Basically this Div displays Calender. Can any one please suggest. Thanks, Salmon
-
Div Alignment.Hi, I am using a DIV tag . Earlier i was using Popup which has below allignment values. Due to some problems we thought not to use PopUp and using Div. XPos=48 YPos=69 Width = 160 Height=138 I want my DIv tag to be opened with these values.Can you please suggest how I set these values for Div. Thanks, Salmon.
-
Anchor onclick attributeHi, Below is the issue I am facing in Java script. I am using <TR> in that Tr i have 3 <Td> in last <td> I am using anchor tag dome thing like below <tr name =row> <td/> <td/> <td> <a type="aaa" onclick="UpdateName" > test </a> I am assigning dynamically all the attributes of anchor tag like below var cells= row.cells; var link = cells(2).all.tags("A")(0); link.file= "123"; link.href = "javascript:VoidReturn("nothing to return"); link.onclik=function() { updateName(name);} function Update(name) { username=name; } This is working fine if i am using link onclick attribute as above ...function() { updateName(name);} but if i am just giving it as string, it is not invoking, like below. link.onclick=updateName('abc'); Please let me know how i can set onclick of anchor attribute without function object. Thanks, Salmon
-
IE 8 hiddenfeild issueHi, Hi, Below code is working fine in IE6 my aspx page contains below tag <input type="hidden" name="HddElement" /> My javascript is accessing this element like below document.getElementById("HddElement").value = var1; But in IE8 i am getting exception at above line. if i achenged that to below it is working fine. document.all.HddElement=var1; Please let me why this is not working in IE8 with document.getElementById Thanks, Salmon
-
Javascript IE 8 IssueHi, My application is having some issue with IE 8 (working fine with IE6 and IE 7). Below is my code My application current domain is "Main.Sub.com" now i am updating the domain to "sub.domain" document.domain="sub.domain"; after this i am setting below property in child page load. var child_window=window.opner; document.title=child_window.title after checking for some conditions I am againg setting domain document.domain="Main.Sub.com" Then I am creating popup MyPopup = window.createPopup(); my code is looks like below var curdomain="Main.Sub.com"; Var child_window; document.domain="sub.domain"; child_window=window.opner; document.title=child_window.title; . . . document.domain="Main.Sub.com"; MyPopup = window.createPopup(); Can any one please suggest how i can make this work in IE8 Thanks, Salmon
-
DateTime convertionThank you it is working.
-
DateTime convertionHi, I want to convert the below string to DateTime object . I am unable to do this using Convert.ToDateTime() Wed Feb 24 04:56:30 2010 Please suggest. Please provide regular expression if required. Thanks,
-
Regular expressionThank you it is working.
-
Regular expressionHi, Thank you for your reply can you please make it more clear by providing full regular expression and this is a url string which is having querystring "key=" at the ending and I am reading this value using m.Groups["name3"] in my C# application. Thanks,