Zaid Papa's Q&A profile

• SQL Server Hi

  Hi, I have setup a linked server to a DB2 database using "Microsoft OLE DB  Provider for ODBC Drivers", the connections works fine i am able to run select queries. but the number of rows returned from the two following statements are different. select * from linkedserver...tablename select count(*) from linkedserver...tablename e.g. The First statement returns  116 rows, whereas the second query returns count as 144.... I am a bit confused  could anybody think of any possible reasons.. Cheers ARAW012  The openquery and the "normal" Select behave different, because the OPENQUERY will issue a pass-through to the server instead of doing the interpreted Select query through th ...Show All

• SQL Server Accessing lower level members

  Hi All, I have used .Children function to retrieve members of dimension at one level below the current level of dimension. For example (using FoodMart 2000 and AS 2000) Select NON EMPTY ( { [Measures].[Unit Sales] } ) ON COLUMNS, NON EMPTY ( [Customers].[Country].[USA].Children ) on rows >From sales This query returns me Children of member Country which is USA. It returns all members of State Provinces which have USA as its parent. Can I access or retrieve all members of City with Country member being USA I am building a web application where user applies filters. This is necessary because if user wants to view sales data about City which belongs to country USA. Many thanks in advance. Raghu Hi Raghu. Ye ...Show All

• Visual C# using classes

  hi! i don't know how to phrase my question but here it goes... i have many functions in my program and they are all placed in the form1.cs what i want to do is separate it and place all of them in a class. how would i do this do i just copy it and now how can i call it in my program thanks! Firstly I'd suggest having a look through the book recommendations thread at the top of this forum. You can extract pretty much any of the code in the form class and put it in your own, but you need to fix up any dependencies also. Think about breaking items out by function and role. Group similar types of code. And don't group too much stuff together, try to keep your classes nice and manageable. ...Show All

• Windows Forms When XP Theme is in effect, what color should the tabpage be?

  VS2003 When the XP Theme is in effect the TabStrip background changes to a gradient from white to dirty-white. For some reason the default TabPages backcolor doesn't behave the same way. Anyone knows how to set the TabPage background color that will also respect the current Window theme If you look at some of the Windows Property screens that use TabStrip, the TabPages have also a gradient background. Also the GroupBox control somehow behaves as if it's transparent to respect the gradient background of the TabPage.   After Googling, I found that tabpage and groupbox coloring is not fully implemented in VS2003. VS2005 supposedly, will now apply the XP Theme to tabpage and groupbox ...Show All

• .NET Development FileIOPermission

  OK, ive got a bit of a strange error Ive managed to get the IT staff to install visual C# 2005 express on a college computer, and it works pretty much fine. BUT When using an openfiledialog, i get this exception thown slugonamission wrote: OK, ive got a bit of a strange error Ive managed to get the IT staff to install visual C# 2005 express on a college computer, and it works pretty much fine. BUT When using an openfiledialog, i get this exception thown ...Show All

• Windows Forms Vista Controls coming soon?

  When, if ever, will VS be updated to the new Vista forms controls I have found a few add-ins on the net that will give my form that Office 2007 feel, but the last thing I want to do is purchase something that will be outdated with a service pack. I have been toying with these: http://devcomponents.com/dotnetbar/ But dont want to purchase anything if VS is going to be updated with something similar. ...Show All

• .NET Development "Error 5 - The ConnectionString property has not been initialized. " message appears before loading my form

  Hi all, I'm creating a new windows form project, and referenced on the System.Data dll and Imports System.Data.OleDb, but before my form even shows (I put a break on the first statement of my form load event, but it hasn't even fire), the debugger throws me this error: "Error 5 - The ConnectionString property has not been initialized." and the immediate windows shows this: "A first chance exception of type 'System.InvalidOperationException' occurred in System.Data.dll" But then my form loaded up normally after I click away the Error 5 message box, with data from my db correctly shown in the comboboxes desired, too... I'm using visual studio 2005 with vb.net, and my db is in MS Access 2003 forma ...Show All

• Visual Studio Question about counting the number of items in a list box

  Hi - This question pertains about the code more so than debugging - but I am not sure where I should post this type of question. Any help would be appreciaced...I am trying to count the items in a listbox, and have the count number display in the list box. I didnt have any trouble using "count" and having the number display in a textbox, but I want the number to display in the listbox, so I removed the textbox. This is my code: Option Explicit On Option Strict On Public Class MainForm Private Sub MainForm_Load( ByVal sender As Object , ByVal e As System.EventArgs) Handles Me .Load ' fills the list box with values, then selects the first value namesListBox.Items.Add( ...Show All

• Windows Forms Update datagridview in c#

  hi all i am retreiving data into the datagridview based on perticular field, OleDbConnection con = new OleDbConnection(""); OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM table where id like '" + searchresult.str3 + "%'", con); dataSet6.Clear(); da.Fill(dataSet6, "tablename"); dataGridView1.DataSource = dataSet6.Tables["tablename"]; con.Close(); and now i have to update the datagridview. i wrote a update query in tableAdapter query builder;and in the form i am writing pROTEIN_INTERACTIONTableAdapter.UpdateQuery(dataset6); but its showing errors. please tell me how to update the records in datagridview ...Show All

• Visual Studio Express Editions Install Error - "Encountered a problem"

  What is wrong with the Visual Basic Install It does not even begin the installer. I get the message "Encountered a problem..", click "OK", and it is done. The message seems to come as the installer gathers files and performs system checks. I do have MS Office installed, and I am running XP pro SP2. I am doing a manual installation from a CD. I tried to install Visual C just to see if there is something else I need to do prior to install. The installer runs with Visual C, Express Server and every other package. VB just does not want to go. Thanks ahead of time for any help. Rudy. Tried to post this as a "solution". I am sure others will run into this issue. Which image to burn I burned the ...Show All

• Visual C++ How to convert 4 types of C++ strings?

  I am new to C++ programming ... and it seems not everything is written in the books. Can anybody explain to me how to convert between the 4 types of string representations: char * char[ ] string class String ^ class Are there simple recipes for conversions Are the classes string and String^ only used with Microsoft C++, or with ANSI C++ as well It would be wonderful to get a sort of systematic overview, which I could not find in any book anywhere so far. Sounds like you want someone to write documentation for you.  There are plenty of answers out there already investigated upon and written up if you do your own searches. (This topic in fact has been covered in this forum and the MS ...Show All

• Visual Studio Team System Validation Rule: Find Text - Regular Expression

  I need to verify that a transaction id and confirmation id were actually returned. Both values appear on the page but I do not know what the exact values will be. The transaction id should be six digits long and the confirmation id should be 16 characters long (0-9,A-Z,a-z). The challenge is that I am trying to use a web test and I want to avoid writing code if at all possible. The Find Text Validation Rule has an option to set "Use Regular Expression" to True, but I am having trouble finding examples using this. Can anyone give me examples of how to use Find Text to search for transaction id = 123456 or confirmation id = 12345abcd67ef89gh when the exact ids are not known Thanks in advance... ...Show All

• Visual Studio VS2005 Installation missing ASP options

  I am not sure what is going on but after my 1st initial install I was missing the option to create Web items for ASP/ C# and VB applications.  I reinstalled and still not an option to make this work.  Anyone have any suggestions or ideas  Steve I now have it partially working . I can create a Web Site and open a Web Site under the File Menu button, but I am still unable to see the option in the 'Start Page' under 'Recent Projects' where it states: Open: Project Create: Project ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Tell us about your website or game!

  As part of our effort to reach out to the XNA community, we would like to create a special community page on the XNA Developer Center that links to YOUR site or game. Here's what you need to do, send me (David Weller) an email (click on my name link to the left of this post for the email address) telling me: 1) Your name 2) Your contact email 3) Your website or game 4) (Optionally) If you send me a link to your game, please let us know if you give Microsoft permission to use your game as part of any press-related activities we might do (i.e., incorporate a screenshot/video of your game, etc.). Please don't reply to this post with links to your site/game, I need the information emailed to me. Thanks! For some time ...Show All

• .NET Development unable to access subfolders in public folders of Exchange2003 using websrvices

  Presently we are trying to access the System Folders in Exchange 2003 server, specifically Free-Busy folder using a application(web service). We are logging into Exchange Server With Administrators account and getting the public folders. From the returned public folders when try to list their subfolders recursively we receive the error ‘Unknown Trust Provider’ When we investigated it on exchange these folders maps under System Folder Category. We are required to access the Information in System Folder in order to generate one report. Please note that this works fine if NT service is used instead of webservice. kindly advice as to how to resolve this issue ...Show All