Hossam Abdel Wahab's Q&A profile

• Visual C++ ?: or if-else (c++)

  Anyone know if there is a difference between code generated using simple if-else statements and that using the : operator Does use of : avoid generating branching code, and thus lessening branch mispredictions in the code compared to the if-else version I was under the impression that : would generate a short branch but then I came across this article (section: Branch Avoidance) that suggests otherwise.. Case 1 int y; if (x==2)     y=0; else     y=1; Case 2 y= (x==2) 0:1; Thanks What the article say is " With a good compiler, this will execute far faster than the code with branches that the “if” form will generate. " Notice the precondition: "with a good compiler". Obviously, ...Show All

• Visual Studio 2008 (Pre-release) Creating graphs using WPF

  Hi, I am trying to create graphs using Avalon. Can anyone please help me in searching some useful material for that (creating graphs using WPF build 5456) Thanks in advance, Chandra Sekhar.G You can download Kevin's Graph control here: http://blogs.msdn.com/okoboji/archive/2006/09/20/764019.aspx Sheva ...Show All

• SQL Server Web parts for Report Explorer

  I understand that a report explorer in Sharepoint can be used to show the lists of available reports from the report server. However how do I restrict a particular account the categories of reports he can only view..from sharepoint configurations and not from report server..thanks. Regards Alu but is it possible to leave the settings in RS alone while configuring only the restrictions in SPS ..the reason being that I am trying to center the 'functionalites' around SPS and RS is just a collaboration to it thus more control from SPS instead of RS... Thanks. Regards Alu ...Show All

• SQL Server alter databse TestDB set TRUSTWORTHY on fails

  Hi all, When I try to execute the following command: alter databse TestDB set TRUSTWORTHY on I get this error: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'databse'. Msg 195, Level 15, State 5, Line 1 'TRUSTWORTHY' is not a recognized SET option. Can someone tell me why Thanks in advance. Hi Madhu, Thanks for the quick response, but there is no SQLServer 2000 on my PC or my laptop. My laptop has Win XP and SQL Server 2005, and my PC has Vista Ultimate, with SQL Server 2005. The command was executed in Management Studio, which SQL Server 2000 does no have. Thanks. ...Show All

• Visual Studio Tools for Office Save Excel Data to Sql Server Database

  Please help! I have a VSTO Excel project that contains a spreadsheet. The spreadsheet contains several sheets that are populated from various sources. I need to save the values from one of the sheets to a sql server database table. The spreadsheet layout exactly matches the database table layout. I will always do an insert, never updates. Any help is greatly appreciated. TenDollars ...Show All

• Visual Studio Express Editions Database Problem

  I'm a beginner of vb 2005 (actually beginner of programming),I used to learn some basic coding in vb2003. Recently I am trying to do a small project to modify a database using vb2005 and I follow the steps as I learned from 2003 notes, but when I tried to pass the a parameter from one form to another,I can not find out how to perform steps written in red words. part of the notes: a. Click on the adapter of the main/big table b. Right click on the adapter i. Configure the data adapter ii. Click next 3 times iii. Query builder button iv. Go to the criteria of the ...Show All

• Visual Studio 2008 (Pre-release) Databinding

  I'm writing a graph control (a control that represents vertices and edges visually). The business layer is finished and I have also built the graph control actually, but now i'm trying to tie these two components together with wpf databinding. The Graph class has two public generic list members (List<Vertex<T>> and List<Edge<T>>).To make these "observable", I use the following mechanism: In the UI an ObservableCollection is created per generic list with a reference to the list in the constructor. This creates a copy of the list of type ObservableCollection (according to the MSDN). Unfortunately this is not working, because changes are not propagated, I think. On top of that ObservableCollection, I ...Show All

• Visual Studio Express Editions Using a form to add record to sql database

  Hi, I'm a VB Newbie and on a steep learning curve. I have downloaded and installed VB Express and started on designing my form with all my fields, (name, address, etc.) I haver also installed SQL Server Express. Using the "How do I" on the help menu ( http://msdn2.microsoft.com/en-us/library/ms172598(d=ide).aspx ), I have managed to add a database to my form, add a table and insert records into the database manually. I have also managed to view the data entered into the database on the form using AddressesDataGridView control. I would like to now use my form to enter values and details onto this database. Does anyone know of any tutorials that will help me do this Thankyou Regards Habib Hi, Using the tu ...Show All

• Windows Forms DataView, CType's Expression & Sqlexpress'Database: Compiler Error BC30469-Reference to a non-shared member requires object ref.

  Hi all, I got a Compiler Error BC30469: Reference to a non-shared member requires an object referene [in "Dim dvTable As Dataview=CType(SqlDataSource3,Select(DataSourceSelectArguments.Empty, Dataview)"-see the attached 'Default.aspx.vb' below], when I ran a website "RPD-TCE" in my VWD 2005 Express. /////////////////---Default.aspx.vb---////////////////// Imports System.Web Imports System.Net Imports System.IO Imports System.Data Imports System.Data.SqlClient Imports System.Configuration Partial Class _Default Inherits System.Web.UI.Page Public Class DataView Dim instance As DataView Private Function AverageValue( ByVal Conc1 As Decimal ) Dim dv ...Show All

• Windows Forms How to add User & Pass to ConnectionString in app.config?

  Hi, I excluded the sensitive data (username-password) from my ConnectionString , how can I add it from any C# class when needed i.ex: string username = textbox1.Text; string password = textbox2.Text; Hello, As you are allowing user to enter the userid and password and not going to store in configuration, what you might do is: Create the connection string in application configuration(appSettings) and while using the connection string, replace the userID and password of the user before assigning the connection string to connection object. Hope this helps you. ...Show All

• SQL Server Errors: SQL Reporting Services with CRM 3.0

  Good Day All ... I am currently trying to install CRM 3.0 onto one of our test servers. I have managed with no problem to get everything ready for installation ... but having a problem with reporting services. On the system requirements results page i have green for everything but reporting services. ERROR; Specified Reporting Services Reports Server http://XXXXXX/ReportsServer was not found. I have reporting services installed, can someone please give me some direction on where to go from here to get this up and working. Thanks If this helped please mark post as answer and (for me) rate the screencast and give additional feedback if you want to :-) HTH, Jens K. SUessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server Unable to connect to Oracle Data Source

  I'm using SSRS 2005. I'm unable to create a new Shared Data Source, connecting to an Oracle database. I already have the Oracle client installed on my local machine. And I'm trying to create a Shared data source by clicking the Add New Data Source option. Then I select the Type as Oracle and click on the edit button for the connection string. Then I enter the server name in the dialog box and the username and password to log on to the database. The I click on the Test Connection button and get the following error: ORA-12154 : TNS:could not resolve the connect identifier specified. Could somebody help me with this I guess, you need to check the tnsnames.ora and sqlnet.ora files. (I dont know how to e ...Show All

• SQL Server Convert HEX to Text

  I have an image data type in a table (it is a digital signature) and one of my users wants me to search the image data and see how many people have a certain attribute in their digital signature. I know the image data is HEX, but how, in query analyzer, can I view it as the XML digital signature data that it really is So, how can I convert hex to text in sql server Thanks, but that doesn't help. I had actually found that on a Google search, but it only works for numbers, when the data is really XML. I did, however, find that SQL Manager 2005 for SQL Server can show the image field as the XML that it really is, so I was able to kind of get the data out that I needed. A bit of a convoluted way, and I on ...Show All

• .NET Development Close or Prevent Hidden Message Box

  I have a VB.NET 2005 application that uses the process object to start another application. I redirect the output, and also do not show the other application window. (It is hidden to the user). Everything has been fine except now I have instances where the application that i start might throw a message box. So now what happens is after I start this other application my application will hang because there is a message box (that is hidden) and is waiting to have someone click ok. Is there a way to prevent message boxes from being spawned from this other application, or is there a way to programmically close the message box when it appears, so that the application will continnue on. Any other suggestions are welcome. Thanks ...Show All

• SQL Server Trying to split my columns up into Years, but the rows must be next to one another

  Hi, i'm reasonably new to reporting services and am looking for a way to split my reports' Years to compare the months in year 2005 to 2006 but i can't get my data nest to one another in a single line, it splits the years into different rows as an example this is what i want if you can decipher that 2005 2006 Growth 2005 Year to Date 2006 Year to Date Year to Date Growth turnover gross profit turnover gross profit turnover gross profit turnover gross profit Jan 250500 75300 280200 84100 11.85629 11.686587 250500 75300 Feb 205000 67950 190350 59900 -7.14634 ...Show All