Messageboard Topics


2007 Ribbon Problem - XML code Deleting
A Kumar posted at Saturday, November 21, 2009 7:09 PM
I am trying to convert excel 2003 files in excel 2007 version. When I write the xml code in excel 2007 to customize toolbars it wroks fine in 2007, but when same file is opened in excel 2003 the xml code gets deleted when the user saves the workbook. when I open the workbook in Custom UI editor I cant even see the code I wrote to customize toolbar in excel 2007. I want the files to be available to users who have 2003 on there machines, but when users save the files, excel 2003 deletes my code. How i can resolve this? Please help me. Thanks



Datagrid Custom Row Coloring : Delete and Sort
Claudio Consoli posted at Saturday, November 21, 2009 8:00 AM
Hi, In my windows forms application i'm using a datagrid with custom colored rows based on a value of the underlying datasource as exposed here in this article : http://www.eggheadcafe.com/articles/20060202.asp It is working fine except for 2 things : 1) when i sort the grid the rows are sorted but the colors on the rows remain the same 2) when you try to delete one or more rows the coloring shows some strange behaviours and doesnt work properly I downloaded the Peter's example and i saw it has the same problems i'm experiencing with my own datagrid. Can you please help me to undertand how to correct these two issues? I really need help or i would have to rewrite the entire datagrid :-( Thanks in advance for any help. P.S. : I'm using VS 2003 and the Framework 1.1



Runtime Error!
James John posted at Saturday, November 21, 2009 7:53 AM
I've developed an application in VS 2003 (C++). But while running in a fresh windows xp machine, getting error: Microsoft Visual C++ Runtime Library ------------------------------------ Runtime Error! Program: <application path> This application has requested the Runtime to terminate it in an unusual way.... What will be the reason for getting this error and how can I solve it? Please help.



Installing - microsoft visual c++ 2003 redistributable package - Getting Error
James John posted at Saturday, November 21, 2009 6:39 AM
When I'm trying to install "microsoft visual c++ 2003 redistributable package" getting an error "The upgrade patch cannot be installed by the windows installer service because the program to be upgraded may be missing,....." How can I solve it?



hi date comparison problem
pardeep ravesh posted at Saturday, November 21, 2009 5:25 AM
i have a textbox1 which is filled with <cc1:CalendarExtender ID="CalendarExtender1" TargetControlID="textbox1 " runat="server"> </cc1:CalendarExtender> i have textbox2 <cc1:CalendarExtender ID="CalendarExtender2" TargetControlID="textbox2" runat="server"> </cc1:CalendarExtender> now want to use compare validator not working



party typing notification
praveen kumar posted at Saturday, November 21, 2009 3:53 AM
hai all i am developing live chat application, how to show message that person is typing to other member who is participating in chat thanks in advance.....................



I need beautiful images for adding and updating
shanti k posted at Saturday, November 21, 2009 3:22 AM
Hey Hi, I am in need of beautiful images for adding and updating as Icons in my application. Thanks, shanti.



pulling daily data from one workbook to another different cells
Izzy Izzy posted at Saturday, November 21, 2009 12:16 AM
Hi there, I have got a 3rd party stats program to pull data daily for me either to txt or xls formats. I have attached a image as I am not sure how clear my description is . Essentially i need the data to be pulled to its final resting place in a already existing workbook into different cells. Because the data is daily it has to go to a descending cell daily, eg today line 53 tomorrow line 54 etc. Also from the txt or xls 6 lines of data I only need 3 and they are for 2 different workbooks and all different sheets, am i dreaming the impossible? PS - Although the bottom of the image shows a sample of one of resting places they are all same format different cells/workbooks Izzy



Parsing/Ignoring Null DateTime from Database
Michael Grabowski posted at Friday, November 20, 2009 11:39 PM
I'm currently working on an ASP page that will update data in a database through ODBC. I've set up the connection and everything is working fine until I view a record with a null in a DateTime field. "Error: String was not recognized as a valid DateTime." The following code (Dreamweaver) displays Acquisition Dates of equipment from my table. I use DateTime.Parse to format the date to a two-digit month and four-digit year. This works when records have a datetime set, but many pieces of equipment have a null date. <asp:TextBox Columns="8" CssClass="tb8" ID="acqDate" runat="server" Text='<%# DateTime.Parse(inventoryQry.FieldValue("acqDate", Container)).ToString("MM/yyyy") %>' TextMode="SingleLine" Wrap="false" /> I know one solution would be to update my table and change all nulls to something like "01/1900". I'm wondering if there's a solution that I could run in ASP instead of putting bogus data in my table? Many thanks in advance for any help or pointers in the right direction! Thanks!



Keyword search
Howard Lepolstat posted at Friday, November 20, 2009 7:17 PM
I am trying to give users a simple keyword search. The table to be searched has five fields, both text and memo data type. There are few enough records (less than 5000) so that the lack of indexing capability (for the memo field) is not really a problem. I want to give the user the ability to enter a keyword and have it search all five fields. The search return to the user will be a two field table. The first field in the return table will be the complete data from one of the five original fields. The second field in the return table will be the name of the field in the original table in which the keyword was found. The typical user is expected to have very little computer familiarity other than "point & click" and entering a word or two in a text field. Since I have never created this complex a query before, I would appreciate some feedback as to the general process that might be used. Any suggestions are appreciated. Thanks.



Excel Data Extraction or Mail Merge and Email in Excel
Ivan Woyno posted at Friday, November 20, 2009 5:38 PM
I apologize in advance if this is a question you have already answered, but I could not find anything like this on the discussions. I have a spreadhseet in Excel that has list of individuals and their data in rows. I am trying to figure out a way to do the following: a) Take each candidate's information and move it to its own tab - titling the tab with the contents of the first two cells in the spreadsheet (ie jason bourne) and/or b)Take each row of data and move it to a new workbook and save the work book with the name from the first two cells in the workbook. It would be ideal if Excel could do mail merges directly within excel to accomplish this, much like Word does mail merges. Any thoughts? Ivan



how to reserve a url with http.sys for system.net.httplistener
Ravi Danum posted at Friday, November 20, 2009 4:41 PM
Hello, I am using system.net.HttpListener on a computer which doesn't have admin privileges. I've looked and cannot find the specifics on how to reserve a url with http.sys for system.net.httplistener. Can someone help me in this matter? -Ravi



Secure ClickOnce Applications
Francisco Pérez posted at Friday, November 20, 2009 4:09 PM
I have various applications that I publish with ClickOnce using .NET Framework 2.0. I have an encrypted app.settings file, although when I first install this application the original folder created in C:\Documents and Settings\user\Local Settings\Apps\2.0\etc... is not encrypted until execution for the first time, so there is a app.settings file that is not encrypted upon installation. How can I encrypt my app.settings in this original installation location.



SqlHelper.ExecuteDataset, do I need to open and close the connection explicitly ???
Pranay Singh posted at Friday, November 20, 2009 2:22 PM
When I am using SqlHelper.ExecuteNonquery or SqlHelper.ExecuteDataset, do I need to open and close the connection explicitly ??? Thank you



IMF- Intelligent messaging filter
ashley tap posted at Friday, November 20, 2009 2:04 PM
Hi All, How should I identify e-mails blocked by Intelligent Messaging Filter in exchnge 2007. Please let me know. Thanks



Integration services doesn't run under Management Studio
max damico posted at Friday, November 20, 2009 1:58 PM
Hi Lads, I work with SQL2005 on WindowsServer 2003/R2 32bit and I'm also have admin privileges. I can run Integration Services and design my package. When I try to run Integration services under Management Studio, It doesn't work because I cannot select sql authentication but only windows authentication. When I try to launch with this limitation, always appears a msg that I cannot run it. It's strange because in sql server manament I can't see the service. What do I have to do ? Thanks for your Help



Client not able to authenticate to server, when CA goes down
Sambit Padhi posted at Friday, November 20, 2009 1:50 PM
Hi, We have an application which authenticates using the active directory credential and smartcard certificate. But when the issuer Certificate Authority goes down, we are not able to access the particular application using the Smartcard Certificate issued by the same Sub CA, but we are successfully able to login to the application using the user’s smartcard certificate which are issued by other sub CA What may be the reason? Clients, application server and Sub CAs are in 1 domain The authenticate users are in a group inside Active Directory. The Server certificate is issued from one of the Sub CA. we have one root ca and 2 sub ca. Please help Thanks! Sam



Conditional Formatting
Daron Shiflet posted at Friday, November 20, 2009 12:29 PM
I'm using Excel 2007 and I want to shade values in column AB if they are less than values in column W in their corresponding rows. I can do this with Conditional Formatting of course, but I would have to do this with each individual cell. How can I get around this? Please help! Thanks...



Stragen 401.3 Error
Robert Keay posted at Friday, November 20, 2009 12:15 PM
I posted this in the silverlight section earlier but On reflection I think it really belongs here: I have a Silverlight application that needs to access a WCF web service (hosted in IIS 6.0) located on a different domain, so I create the ClientAccessPolicy.xml and stick it in the service's web site root. What I then get is 401.3 errors when the silverlight application tries to access it. Now here comes the funny bit, having gone over all the NTFS and IIS permissions I could think of , without success, I discovered that I could access it if I changed the extension to .svc (but not if I changed it to .html, .txt, .abc). I could also access it if I moved it to another web site on the same server, which has as far as I can see has identical permisioning. Is there another source of permisioning, based on file extensions, hidden away somewhere?



Button does not fire on first click but does on second click
Pranay Singh posted at Friday, November 20, 2009 10:47 AM
My button control does not fire on 1st time click but works on 2nd click though its doing post back in both scenarios. To add little more insanity to it, this is happening only when I am calling one particular method in my click event , otherwise it works normally, but on double click its working fine. Any ideas whats going on and how this can be handled? this is my code for it but I dont think anything is wrong with my code , its framework thats playing some tricks I guess :( <asp:Button ID="btnEdit" runat="server" Text="Edit" onclick="btnEdit_Click" OnClientClick="return confirm('Are you sure you want to edit this message?')" /> protected void btnEdit_Click(object sender, EventArgs e) { CompanyAlertLogic.UpdateCompanyAlerts(ddlCompanies.SelectedItem.Text, txtShowAlert.Text); }

The following code (Dreamweaver) displays Acquisition Dates of equipment from my table. I use DateTime.Parse to format the date to a two-digit month and four-digit year. This works when records have a datetime set, but many pieces of equipment have a null date.