Priyank Gajera's Q&A profile

• SQL Server Lookup Table using Oracle database

  Dear Developers Firstly Im sorry if this is the wrong place to post Q about Oracle database. I have problem to create lookup table using Oracle database. When I run the program to test it the program Hangs ! Note : I can do lookup table using MS ACCESS and SQL SERVER without any problem. If there is anybody can help me I will be thankful. ...Show All

• Visual Studio 2008 (Pre-release) Need List<> to be returned from WCF, need it to work without svcutil

  We have a reference application in which we are trying to expose an existing object as a WCF service. Both the service and the client will be .NET 2.0. The original object is built to return a List<BusinessEntity>, yet when the proxy is generated, the method is returning a BusinessEntity[]. I need to know how to make this work using configuration; don't want to have to rely on the command-line tool. How can I make this work Like the original poster asked, how can we do this WITHOUT having to use the svcutil tool There must be a setting or something that can be used aside from the command line. I create a refernce to my WCF service like any other web service using Add Web Reference and i cant seem t ...Show All

• Visual Studio Team System What can we do to resolve workspace mapping problems or file download problems?

  Hi, The Project Management Team has started to upload documents in our new project. In VSTS they go into File | Source Control | Add files ... and they upload their documents into the project (we are not using WSS) So far no check-outs or check-ins have been performed, just an initial load of all propositions, vision documents, preleminary plans etc. One of the user is having the following problem: In VSTS, even if files are showed as Not Downloaded, VSTS reports the files as current. If we force the get, through the UI or through the command line, files are reported up-to-date, even if physically absent from the workspace. We are all new to TFS and I have two questions: 1) Can I probe what's exchanged between VSTS and TFS in terms of API ...Show All

• SQL Server YTD, MTD etc for Current Point In Time

  I've set up time intelligence on my cube.  This works fine.  I can get to: YTD YTD Prior Year YTD Index Jun 2006 Qtr 502962 467145 107.6672125 Sep 2006 Qtr 733396 916144 80.05248083 Dec 2006 Qtr 733396 1440868 50.89959663 Mar 2007 Qtr 733396 1850595 39.63028107 with the following MDX. SELECT { [Time Calculations].[YTD], [Time Calculations].[YTD Prior Year], [Time Calculations].[YTD Index] } ON COLUMNS , { [Time].[Fiscal Hierarchy].[Fiscal Year].&[2007].CHILDREN } ON ROWS FROM [mycube] WHERE ( [Measures].[Order Quantity] ) This works fine if I have time series on rows and time calculations as colum ...Show All

• Audio and Video Development Run Media Foundation Application On Windows XP

  Hello, is there any way to run media foundation sample or application without installing vista on local or virtual pc I can compile the samples by CMD shell which has been provided with microsoft windows SDK. Please help. Thanks Becky for your reply. If I use directshow and C#.net to develop a audio- video player then will it support in vista. Actually i want to make a player for vista. ...Show All

• Windows Forms Question: Using DataGridView.DataError event to set ErrorText on DataTable Columns and Rows

  I'm looking for the best practice example of handling the DataGridView.DataError event in order to mark up the rows and cells with helpful user friendly messages relating to the error. Example: private DataTable _dtIntegers = new DataTable (); _dtIntegers.Columns.Add( new DataColumn ( "One" , typeof ( Int32 ))); _dtIntegers.Columns.Add( new DataColumn ( "Two" , typeof ( Int32 ))); _dtIntegers.Columns.Add( new DataColumn ( "Three" , typeof ( Int32 ))); UniqueConstraint uc = new UniqueConstraint ( new DataColumn [] {_dtIntegers.Columns[ "Two" ], _dtIntegers.Columns[ "Three" ], _dtIntegers.Columns[ "One" ]}); _dtIntegers.Constraints.Add(uc); dgv1.Data ...Show All

• SQL Server How can I workaround this problem?

  Hello everbody, this query: SELECT * FROM TBL_DEVICE_DRIVERS WHERE (DD_CATEGORIES & 2147483648) > 0 bring the error message: Invalid operator for data type. The value 2147483648 is hex 0x 80000000 for bitwise joining defined. I try to cast it to decimal, but it does not work. Have anybody an idea Thanks for answers! Will you please elaborate what you want to achive as far as i understand you are try to make logical AND operation in the where clause as "DD_CATEGORIES & 2147483648". what type of DD_CATRGORIES is try to check it data type OR send the table structure & some semple data to, so that we can check it. Gurpreet S. Gill ...Show All

• SQL Server DTS : Format Problem !

  I have a statement in the DTS ( Activex Script ) like this : TomorrowDate = Format$(Now, "yyyy-mm-dd") When i am running the package, i am getting the following error : --------------------------- ActiveX Script Task: undefined --------------------------- Error Code: 0 Error Source= Microsoft VBScript compilation error Error Description: Invalid character Error on Line 8 Can anyone tell me what is the solution to this error Thanks in advance. Hi vijay, Thanks. Even when i removed $ from format, still an error : Telling that : Type Mismatch "Format" ...Show All

• Visual Studio 'extern alias' doesn't build

  Hi, in a sample Project, I'm referencing to both PresentationFoundation.Classic and PresentationFoundation.Luna and I want to create an instance of SystemDropShadowChrome. This class is defined in both assemblies, so I set the aliases of the assemblies to PFClassic resp. PFLuna and putted extern alias PFClassic; in my code. But against all expectations this doesn't build. I get the message: " The extern alias 'PFClassic' was not specified in a /reference option" Any ideas Thanls cheesenhomer If what you mean is to access the class with the same name in different namespace. You'd to set an alias for the namespace (or using the whole name). For example: using PFClassic = PresentationFoundation.Class ...Show All

• Windows Forms Height of Title bar and more?

  I am trying to determine how I can get the height of the title bar of forms and the width of the border. See image below. I did not define the border, its there by default. By doing some tests I determined the title bar is 29 pixels regardless of screen resolution and the border is 3 pixels. I would think there was a property to access these but I am not seeing one. Does anyone know a handy little formula to compute this or how to access the width and height.   Kenny Kerr wrote: You cand find an example here: http://www.pinvoke.net/default.aspx/user32.SystemParametersInfo Cheers, Kenny Kerr http://weblogs.asp.net/kennykerr/ I have already looked at this website and attempted some of the code. I ...Show All

• Visual Studio 2008 (Pre-release) Bitmaps on a toolbar

  I admit to being very frustrated right now. Will Expression ever be a useful WYSIWYG tool, or even a text editor as useful as notepad I am editing XAML in VS2005 right now, and using Expression merely as a preview. I have three panes in my app, and I can only edit one in Expression. Anyhow, that's my rant. Right now, I cannot work out how to put a bitmap into my app as a resource so I can add it to a toolbar Thank you, this is good feedback for the Sparkle and Cider teams. To be fair, the tools teams are working hard to expose the proverbial 80% scenarios and are still in CTP mode; it is likely something like this was not delivered in a particular CTP or is not on their plans. Now that the platform has stabilized and is feature-c ...Show All

• SQL Server Link Server to MySQL Database

  Hi I ma trying to create a linked server to a MySQL database via ODBC. I am running SQL 2005 on Windows 2003 R2 (64-bit). Can any one point me in the right direction . MSDASQL (provider shipped with SS2005 which serves as OLEDB-ODBC bridge) is not supported in 64-bit. Check if there is an 64-bit OLEDB provider for MySQL that you can use directly. ...Show All

• Visual Studio Custom XML Schema for app.config

  Hi! Is it possible to use a custom XML schema in app.config. Not a schema that fully replaces the one that is supplied with Visual Studio, but one that just provides the schema for a custom configuration section. I tried specifying a schema that I built for this purpose. Are there any special concerns to have in mind when building a schema for a custom configuration section I mainly want to do this to have intellisense working when editing app.config. Thanks. ...Show All

• SQL Server Updating Data for a List_Table

  Here is my scenerio: I have a few older tables with a few thouands of records that I inherited. I am using data access pages as the front-end for now which is very limited. I made List_Tables for common values example below: I am trying to use these List_Tables to Input Data Consistently via Dropdown lists . I am able to input data into the Old Table from the Data Access Page /w the List_Table Dropdown , but I am unable to read any data from the Old Table on the front-end even is the data is the same . Once I enter a value from the New Table it will display . Is there a way for me to update the data value from the old table to that of te new table A case statement or something so my New Table Dropdown will display everything Very Confusi ...Show All

• Visual Studio Crystal Reports Showing Empty Report

  In a C#, VS NET 2 Windows app I am trying to display a report made with CR which comes with VS 2005. When the form containing the report viewer opens, the report is empty of data in the dataset. I know the dataset is coirreclty filled, however. The form is very simple, there is only a report viewer - crv. crBizInvoice is the report form crBizInvoice.rpt dsBizInvoice is the name of dataset created and used in designing the form - dsBizInvoice.xsd This is the code in the form: public partial class rptBizInvoice : Form { SqlConnection conn; SqlCommand cmd; SqlDataAdapter da; DataSet dsBizInvoice; crBizInvoice crB; public rptBizInvoice() { InitializeComponent(); String strConn = sqlClass.getConnString(); conn = new SqlC ...Show All