Hi, I have two int columns in a table that have a sample data as below and I need to update these columns with 1).If ColA has a non negative number then update ColB with 0 (zero). 2).If ColA has a negative number then update ColB with the same value that ColA has. Can some please help me with sql? Thanks in advance. L ------------------------- ColA | ColB -----------|------------ -1 -1 -1 -1 -3 -1 4 -1 -1 -1 7 -1 3 -1 73 -1 -3 -1 39 -1 32 -1 35 -1 3 -1 31 -1 3 -1 397 -1 400 -1 403 -1 406 -1 -1 -1 412 -1 436 -1 421 -1 421 -1 424 -1 -1 -1 430 -1 433 -1 -1 -1 415 -1 442 -1 445 -1 -1 -1 -3 -1 487 -1 523 -1 568 -1 472 -1 475 -1 478 -1 -3 -1 490 -1 493 -1 496 -1 502 -1 505 -1 511 -1 514 -1 517 -1 520 -1 -1 -1 526 -1 538 -1 541 -1 544 -1 556 -1 559 -1 550 -1 457 -1 574 -1 -1 -1 580 -1 583 -1 586 -1 589 -1 595 -1 625 -1 604 -1 625 -1 610 -1 -1 -1 622 -1 625 -1 -1 -1 -1 -1 637 -1 -1 -1 649 -1 652 -1 655 -1 658 -1 661 -1 664 -1 667 -1 670 -1 673 -1 -1 -1 685 -1 688 -1 691 -1 697 -1 700 -1 703 -1 709 -1 712 -1 715 -1 718 -1 721 -1 -1 -1 -3 -1 -1 -1 -1 -1 -1 -1 -1 -1

Hi, I have a need to send out emails to all the people who are in a given group say "HR Department". I need to be able to get all the emails through a for loop and then as it retrieves I should send emails to them. Can some one please help me with the code how to get the emails out of AD. this is what I came up with but not sure how to go about writing a for loop to get all the emails in the given group. I am having difficulty to send both the loginName and the group that I am interested in to the AD in the search.Filter. public static string SendEmails(string loginName) { string Department = "HR Department" string userName = ExtractUserName(loginName); DirectorySearcher search = new DirectorySearcher(); search.Filter = String.Format("(SAMAccountName={0})", userName); //search.Filter = String.Format("(SAMAccountName={FAY ImprovmentForm})", userName); //LdapSearcher.Filter = string.Format("(&(objectClass=user)(department={0}))", Department); //search.Filter = string.Format("(&(objectClass=group)(SAMAccountName=" + Department + "))", userName); search.PropertiesToLoad.Add("cn"); search.PropertiesToLoad.Add("samaccountname"); search.PropertiesToLoad.Add("givenname"); search.PropertiesToLoad.Add("sn"); search.PropertiesToLoad.Add("mail"); SearchResult result = search.FindOne(); string samaccountname = (string)result.Properties["samaccountname"][0]; string givenname = (string)result.Properties["givenname"][0]; string surname = (string)result.Properties["sn"][0]; string email = (string)result.Properties["mail"][0]; if (result == null) { return "User doesn't Exist"; } else { return "Emails sent successfully!"; }

Hi, I right clicked on my project and added a dataset called 'PlntAccuracySWDst.xsd' and dragged the 'PlantInventoryAccuracy' table that I want to work with from the server Exploerer on to it. I am trying to access this dataset in my code behind PlntAccuracySWDst mySWdst = new PlntAccuracySWDst(); For some reason I can't see 'PlantInventoryAccuracyTableAdapter' and 'PlantInventoryAccuracy' datatable objects when I do the 'mySWdst. (dot)' in my codebehind file. Am I missing some thing here? I have Select, Insert, and Update stored procs defined in the database and I want to be able use those here. But as a first step I am unable to access the DataTable and Table adapters. Looks like I need to generate the Schema as a typed dataset. But when I right click on the dataset I do not see the 'Generate Dataset' option for me to select. so there is no PlntAccuracySWDst.cs file was created under my 'PlntAccuracySWDst.xsd' file in my solution explorer. I guess that is the reason why (becuase there is no Schema generated) I can't access it from my code behind file. Later on I found out that the the 'Generate Dataset' option is under the View/Tollbars/DataDesign in my VS 2005. I just selected it and this action placed a small tool bar under the Standard Tool bar. The 'Generate Dataset' is one of the icons on it. But unfortunately it is disabled. I am not sure what I am missing here. I need to be able to create the Schema by clicking the 'Generate Dataset' option. I am still looking for help. I have searched online all talk about the steps creating typed datasets but none of the articles address what to do to 'Generate Dataset'. Any help is appreciated. Thanks, L

Hi, Our production apps running on Windows 2003 Server and most of our Applications are authenticated against Active Directory. For couple of applications the "Digest authentication for Windows domain servers" option is selected so when users try to access those web applications the login window " ... at Digest requires a Username and Password" pops up for credentials to get the access. But now we decided to remove that log in and let the users directly access some of the pages with out having to provide log in information (only they click on Edit they need to provide the authentication information). So to make this happen I just went a head and un checked the "Digest authentication for Windows domain servers" option on IIS to disable the log in box. But it still pops the log in window and expecting the authentication needs to be provided. Is there a place I still need to be looking at under the properties on IIS for that application? Thanks, -L

I am thinking of either it could a or e. I found this some online site.

2).An application using cookie authentication was working fine on another server. When moved to a new server cookie authentication is not working correctly.Which one of the following is the likely explantion of the above problem? a).The new IIS server is not configured to allow anonymous access. b).passport authentication is not correctly configured c).The users are not correctly entering their password d).The IP address of the new server does not match the prior server IP address. e).SSL is not properly configured Thanks, L

Hey, Thank you for the great link. I hooked it up to my favorites. Thanks again.

Thanks for the quick reply. I will sure look into this book. Thanks, L

Hi, I am a .NET developer using VB.NET but not haven't had a chance to learn and fell the OO priniciples to the fullest in a way they are supposed to be learn. I want to switch to C# as the whole world slowly moving towards it and at the same time learn all the OO priniciples in a right way. In this process I am trying to find a book which explains all fundamentals of OOP and illustrate how to develop a small application implementing all these OO priniciplese would help me understand the whole thing in one shot. Are there any great books or videos that would help me accomplish my goals? I am desperate to find an excellent book that mainly illustrate an sample project/case study implementing all OOP with comments for better understanding of the OOP techniques and scope of the project as well. Please advice. Thanks, -L

Hi, I tried using regsvr32 to register and regsvr32 -u to un register. I did this on my Dev PC in command prompt by creating a brand new COM+ application in component services. I got the proper messages in a message box and I thought it was successful but when I looked under the COM+ I do not see those components installed. Am I missing some thing here? Thanks, -L

Hi, I need to un register/delete the existing dlls in COM+ and re register with the updated dlls. Could some one help me with how do I do it from the command line? We do not have test server to play around with it and be able to get it right with couple of trails. I will have to do on the production directly so please help me with the right syntax say for a Test.dll. Thanks in advance. -L

HI, Looks like it also works good as expected when I changed the If statement to include 'Or e.Item.ItemType = ListItemType.EditItem' at the end. So I am good with the Sum/Total now. But when I change the Cell I would like the Total/Sum also be changed. Any help appreciated. Thanks, -L

Hi, I am using DataSet as a datasource to my CrystalReport and I have no problem in displaying the data. But there is a column called MoneyWithHeld and I am trying to find a way how to calculate the sum or total of these values. I searched online and have found two possible solutions 1).Using Formula Fields -- Created a field called TotalWithHeld and in the formula I just put Sum({DataSet.MoneyWithHeld}) and that is it but no luck. I am pretty sure I have missed some thing else here but not sure what it was. Becuase while I was trying to save this TotalWithHeld field I ran into some syntax errors and as a result of those while trying to run the report the error was 'The function cannot be used because it must be evaluated later' . 2).Running Total -- I picked my DataSet.MoneyWithHeld filed to 'field to summarize' text box and I picked the "Sum" under type of summary drop down. When I run my app it wouldn't give me any error as it was in the case #1 but it wasn't displaying the total but just the last value of the MoneyWithHeld in the last record. I tried picking the Count, distinct count but nothing has worked. Looks like here too I need to put some kind of formula by selcting the radio button 'use a forumula' but not sure how to put it to get the total. I am kind of new to this Crystal reports would some one be kind enough to help me with this? Thanks, -L

Hi, I am summing a column in my DataGrid and displaying total at the footer with the below piece of code If e.Item.ItemType = ListItemType.Item Or e.Item.ItemType = ListItemType.AlternatingItem Then 'Snip out the ViewCount Dim ContributionWithHeld As Integer = Convert.ToInt32(DataBinder.Eval(e.Item.DataItem, "ContributionWithHeld")) myTotalContributionWithHeld += ContributionWithHeld ElseIf e.Item.ItemType = ListItemType.Footer Then e.Item.Cells(20).Text = "Total: " & String.Format("{0:#,###}", myTotalContributionWithHeld) End If and it works great and it dispaly the correct total when it binds the data. But if I click on Edit row button in the grid then the Sum/Total at the footer changes (deducts the value of that cell in that row from the total). Looks like the the row that is in Edit mode is not being taken into acount while summing the values. Can some one help me with this how to change the above code or what I else I need to do to display the Sum correct even if any of the rows in Edit mode. Also, the other thing I would like to be able to do is when a row in Edit mode and as I change the value in the Cell that I would like Sum , the Sum at the footer needs to be changed. May be I need to do it under OnCellChange event but not sure where and how do I do it as I never done this before. Please help. Thanks, -L

Hello, I have upgraded all of my VS 2003 built xsd files to VS 2005. For some reason I just can’t compile the upgraded version of the project (in VS 2005) because of the exceptions (blue lines) I get in few of the “.xsd” files in the VS 2005 IDE. Error: I see blue lines under the below lines in my few of my DataSets System.ComponentModel.DesignerCategoryAttributeSystem.ComponentModel.ToolboxItemSystem.ComponentModel.CollectionChangeEventHandler _ When I mouse hover under the first one line of code it says “ ‘DesignerCategoryAttribute’ is ambiguous in the name space ‘System.ComponentModel’” On the second line I get “ ‘ToolBoxItemAttribute’ is ambiguous in the name space ‘System.ComponentModel’” On the third line On the second line I get “ ‘CollectionChangeEventHandler’ is ambiguous in the name space ‘System.ComponentModel’” And on the fourth line I get “ ‘Browsable’ is ambiguous in the name space ‘System.ComponentModel’” And so on… But just to give you note I don't see the same thing happerning for all of the .xsd file but for just few of them. I tried to compare both of these files to see if there is any difference in them but couldn't notice any thing different. Am I missing some thing in here? Do I have to reference any dlls in the VS 2005? If it was the case why few of the .xsd files are smiply fine? Any help is greatly appreciated. Thanks, -L

Hi Daisy, Thanks for the reply. Yes your code helped me to move further and I don't see any compile time errors. But at the line 'myReport.Load() myReport.Load(Server.MapPath("ParishPartIEarlyChildhoodGrade8Report.rpt")) I am getting an "access denied" exception ... here is the error I am getting ************************************************************************************ ?ex {"Load report failed."} Data: {System.Collections.ListDictionaryInternal} HelpLink: Nothing InnerException: {"Access is denied. "} Message: "Load report failed." Source: "CrystalDecisions.CrystalReports.Engine" StackTrace: " at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened() at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, OpenReportMethod openMethod, Int16 parentJob) at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename) at AODOnline.ParishForms301.ParishPartIEarlyChildhoodGrade8Export.ExportReport() in D:\AODSetup\ParishForms301\ParishPartIEarlyChildhoodGrade8Export.aspx.vb:line 147" TargetSite: {System.Reflection.RuntimeMethodInfo} ************************************************************************************ I also did run CRRedist2005_x86.msi from the location "D:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\CrystalReports" . I am not sure I should run it on my development box but I did still I get the same access denied exception. Any inputs on this? Thanks, -L

Hello, I have converted a VS 2003 project that has few Crsytalreports in it to VS 2005. All the dlls got converted well and my application works well except the Crystalreports part. I have a sub routine called ExportReport() in a page called GenerateReport.aspx page. It works fine under VS 2003 which generates the report in a word or excel etc... based on what user selects. But surprisingly it doesn't work in VS 2005. The first line I have in ExportReport() sub routine is Dim myReport as new CrystalReport1 and this works (I mean the I see the CrystalReport1 in the intellisense when I type the "new" key word) perfect in VS 2003. But it doesn't do the same thing in the converted VS 2005 project and I see a blue line underneath. So as a work around I also tried adding CrystalDecisions.CrystalReports.Engine CrystalDecesions.ReportSource CrystalDecisions.Shared CrystalDecisions.Web references to to my VS 2005 project by right clicking on the project and by picking the "Add Reference...". option but it doesn't seem like it hasn't done any thing for me and the IDE (intellisense) still doesn't recognise"CrystalReport1" in my VS 2005. Have any one run into this kind of conversion from VS 2003 to VS 2005? Please advice. Thanks in advance, -L

Hello, I converted a VS 2003 project to VS 2005. It works perfectly alright in VS 2003 but when I try running in VS 2005 I got strange thing going on. The code (my button click event ) runs twice? Has any one run into this kind of situation before please help. Am I missing some thing here? or do I need to set an option here? Thanks, -L

Hello, I am in search of the .NET Framework 1.x and 2.0 and 3.0 class library maps and ADO.NET class library maps to hang/pin to my cube at work and also at home. I believe that helps understand more about the Framework and ADO.NET objects and class libraries. Also if some thing is presented in a pictorial (grapihical) representation I guess I can learn more than reading whole lot of stuff. So is there a place on the net or any company that offers this kind of to buy or down load? Any inputs or help me finding on this is greately appreciated. Thanks in advance, -L

Hello, I am in search of the .NET Framework 1.x and 2.0 and 3.0 class library maps and ADO.NET class library maps to hang/pin to my cube at work and also at home. I believe that helps understand more about the Framework and ADO.NET objects and class libraries. Also if some thing is presented in a pictorial (grapihical) representation I guess I can learn more than reading whole lot of stuff. So is there a place on the net or any company that offers this kind of to buy or down load? Any inputs or help me finding on this is greately appreciated. Thanks in advance, -L