Mohamed Sami's Q&A profile

• SQL Server Beginner's questions

  Hello, I have two database servers that I am interested in sending messeges between them. I am not interested in security or encryption at this point, only a simple message sending and recieving. Can someone please provide simple scripts for object setup (certificates, queues etc) and message send and recieve a link to such a script will be great as well. I am just a bit lost understanding all the new concepts (certificates, service, service binding.....) Thank you I. I think I deleted your post by mistake. Ilan D wrote: ok. for some reason 'End conversation @CoversationHandle WITH CLEANUP' doesnt clean up the sys.transmission_queue table. any suggestions I tried to ...Show All

• Visual C# XML Documentation in a Solution with multiple projects

  Hello all, I've tried search for a solution to this problem but so far I haven't had much luck. I have a solution with 2 projects, TestProject and TestProject.Architecture. TestProject references TestProject.Architecture, which is a class library. TestProject.Architecture contains a class called Class1, and I've added some text to the <summary> that I would like to see in TestProject when I use Class1. I went to the properties of TestProject.Architecture, and in Configuration Properties, in XML Documenation File, I added the value TextProject.Architecture.xml. The output folder is /bin/debug. I recompiled TextProject.Architecture, and it generated the .xml file where it should be, and when I examine the .xml file it seems everything ...Show All

• Visual Studio 2008 (Pre-release) XAML Xml Binding

  Is it possible to work a master-detail where the detail gets it's Xml data from a different part of the tree and not a direct child of the original master element. For example, I want to show a category list, and selecting a category will show me the reports in that category. However a report can be in more than one category. Ideally I don't want to duplicate the report information so I want Xml that looks like: <reports> <categories> <category name="cat1"> <reports> <report key="rep1" /> <report key="rep2" /> </reports> </category> <category name="cat2"> <reports> ...Show All

• Visual Studio Tools for Office "Microsoft Visual C++ Runtime Library" error

  Since yesterday, my document customization created using VSTO 2005 causes an error to pop up in Word 2003 whenever I close the customized document: ------------------------- Title: "Microsoft Visual C++ Runtime Library" Body: "Runtime Error! Program C:\Program Files\Microsoft Office\OFFICE11\WINWORD.EXE This application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information." ------------------------- With an OK button. If the document is saved before I close it, all of my changes are saved (including [Cached] fields), but if I choose "Yes" to save an unsaved document after clicking close, the save process is interrupted and the d ...Show All

• Visual C# Loading Class library dll

  How to load a .net class library dll dynamically from a .net windows application using vs 2005. Hello, Look at Assembly.Load function. Then to create an instance of a class from your library, you can use the CreateInstance function: object theInstance = assembly.CreateInstance( "MyAssemblyNamespace.MyClass", true, BindingFlags.Public | BindingFlags.Instance, null, null, null, null ); Richard ...Show All

• Software Development for Windows Vista wimgapi and vb6

  Greetings, Can someone advise me how to get the declaration, method, constants etc for using wimgapi in vb6 I have all the necessary support files .dll, .lib, .h, and the chm file, but I cannot seem to find the code for including it in my vb app. Maybe I just missed it somewhere. Any help would be greatly appreciated. Thank you. Here is a recent post that claims to have some working VB declarations for using WIMGAPI: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=727562&SiteID=1 ...Show All

• Windows Forms Combining ClickOnce and MSI Installer

  Hi, I have been surprised by the gap there is between ClickOnce and MSI. And I need to solve this. The scenario is this: Install a windows form application on a client (registry values, files, folder creation) and use ClickOnce to just update the application. Any GOOD documents about it Thanks!!! ClickOnce updates by replacing individual files of your application. But Windows Installer (MSI) keeps track of your files, and it doesn't know about ClickOnce. If you replace files of an application that was installed using .msi (either manually or using ClickOnce) this can cause problems. Therefore, like I mentioned before, you cannot update a MSI installation using ClickOnce. Instead you should use a patch (.msp). There ar ...Show All

• Visual Studio Configure SSRS custom assembly

  Hi all, I made a custom assembly for SSRS 2005. It works well. I would like to make some things to be configurable via config file ... string exUrl = ConfigurationManager .AppSettings["ExternalWebServiceURL"]; ... Is it possible How I see (Sysinternals ProcessExplorer) this dll was loaded via Inetinfo.exe/aspnet_wp.exe thanks, the good answer is: write a section into web.config C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportServer\web.config <configuration> .... <appSettings> <add key="ExternalWebServiceURL" value=" http://w3.map.com/DWIntermapService/DWIService.asmx " /> </appSettings> </configuration ...Show All

• Internet Explorer Development how to submit data from Web spreadsheet component to MS Access Data base?

  Hi! This is Amit from India. I am developing a web based data analysis tool. I want to provide a excel like environment to the user on the Web. For this I am using OWC 11(Office Web based spreadsheet Web component). I am able to create a spreadsheet on the web and can get data from MS Access in it. Now I want that user can add or edit available data on web spreadsheet and save it back to MS Access. I tried to do so but unable to do using Simple ASP + VB Script. Actully VB script run before loading the page and so I loose the thread of the opened web spreadsheet. if i can make the object of the same web spreadsheet then i can pass the data back to MS Access data base. But I don't have any method or idea to do it. Can sombody help me out ...Show All

• SQL Server Need scope for RowNumber( ) function

  HI ... I have a detailed report ..with summary lines and detailed lines (drill down). I have a column with a function "RowNumber(Nothing)" which is supposed to just count the rows when I put this in the summary row for the column I need in the Design Layout section and run the report, I get numbers on the summary lines which include the number of rows in the level below (detailed rows). I just want to number the summary rows sequentially without taking into consideration, the number of detailed rows. How do I modify RowNumber(Nothing) to exclude counting the detailed rows.... Any help will be much appreciated...thanks Excellent!! Thank you, I have looked every where for this...... ...Show All

• .NET Development Image.Save method = "-2147467259 A generic error occurred in GDI+.".

  I'm having problems saving a Image to a response stream. In a Web Service Control, I have created an object that overrides System.Web.UI.WebControls.Image. I then overrode the RenderContents method. I needed to capture a bitmat image that has been embedded within my DLL so that I can modify the color palette before I send the image to the browser. All goes well until I call the Image.Save method. I then get "-2147467259 A generic error occurred in GDI+.". I have not seen an answer in this resourse, but if I have missed it, a pointer would be welcome. If you see any glaring error, a correction would also be welcome. If you need to reproduce it, this code should work in a Web Server Control project with an image of the approp ...Show All

• SQL Server Restricting Date Parameter Values

  Would like to restrict the dates users can put as parameters. For example, I have a report showing all orders in year 2007. I have exposed Start Date and End Date parameters. When users click the 'View Report' button, the report will filter for orders where attribute EnteredDate is >= Start Date and <= End Date. I want to restrict the users from entering a start date greater than today's date. Would also like to restrict them from entering an end date that is less than the start date parameter. How can I do this TIA. ElSalsero Sure, this could be a workaround. However, your original question was how to restrict the users to enter wrong days. This article may help you get started with using the ReportViewer controls to bu ...Show All

• Windows Forms Format Text for PhoneNumber

  If i have a text field and i want to enter a phone number like 12345678190...but i want it inserted in my db like 123-456-7890 how would i go about doing that you would probably be better in formatting the textbox then directly taking that value into the database, saves hassle and is better overall. one way of doing it probably would be to use Regex however could be overkill just for this. another way of doing it, a cheeky way, would be to add the "-" character if you know exactly after how many characters you wish to add the "-" to (using the Insert() method of the string) you could also use a maskedtextbox control thread moved to the appropriate forum ...Show All

• SQL Server how can i use comma like a decimal separator?

  "update product set price='1,99' where cod='001'" I need COMMA... not DOT In oracle i use "alter session set language='Brazil'"... but... in SQL SERVER i need help... hi, SQL Server just uses "dot" as decimal separator... you have to replace your strings removing the thousands separator, if present, and modify the decimal separator as indicated.. or just use a Command object instead of dynamic SQL, so that the command parameter's value(s) will be set accordingly to your locale settings and you do not have to deal with that kind of troubles... more, you completely bypass lots of SQL injection troubles as, for instance, a datetime parameter can not accept someth ...Show All

• Internet Explorer Development .ppt not viewable in IE

  Hi I created a .ppt file and then created a link to it on my website. When I tried clicking the link to the file it opens, but I am only able to view the first slide. The scroll bars are showing but they don't work. I am not able to advance using the keyboard keys. Can anyone tell me what is the reason for this problem and how it may be solved Thanks in advance capa ...Show All