ydla's Q&A profile

• SQL Server Can Visual Studio map SQL Server to XSD Schema?

  I am creating an annual XML document to submit to a government agency. They have published an XSD Schema . Our data is in SQL Server 2000 . I need some way of associating columns from tables in SQL Server 2000 with the elements from the XSD schema to produce a valid XML document. It looks like I could use XMLSpy or Stylus Studio , but I think there must be some way of doing it in Visual Studio 2005. Does Visual Studio 2005 have too ...Show All

• .NET Development Accessing an Excel 5.0 file

  So, my current task is to read all the values out of an Excel 5.0 file. I can't depend on Excel being installed on the production machine where the software will run, so I can't use the Microsoft.Office Interop stuff. However, I have found that I can establish both an ODBC connection and an OleDb connection to the file. All well and good so far. Two questions: 1. Which is better to use, ODBC or OleDb 2. The data in one column of my file ...Show All

• Visual Studio Team System Project Creation Problem: Unable to connect to the Windows SharePoint Services

  After installing TFS Beta 3, everything seems ok. Can connect to it, manage it, etc. However I cannot create projects sucessfully. When I try to I get this (excerpt from log): Event Description: TF30162: Task "SharePointPortal" from Group "Portal" failed Exception Type: Microsoft.TeamFoundation.Client.PcwException Exception Message: Unable to connect to the Windows SharePoint Services at TEAMSYS1 Exception Details: The Project Creation Wizard w ...Show All

• Visual C++ cannot compile ANY C++ project in VS2003

  I think I've screwed up the paths the IDE uses to search for include files and header files. I am unable to compile any project using C++. I cannot compile brand new Win32 console apps or MFC apps. The compiler error is : c:\Program Files\Microsoft Visual Studio .NET 2003\Vc7\atlmfc\include\afxv_w32.h(166): fatal error C1083: Cannot open include file: 'windows.h': No such file or directory I've tried running the repair and reinstalling VS2003, ...Show All

• Windows Forms class inside module in VB .net

  Hi guys Is it ok for me to define a class inside a module I don't want create another class because I am only defining properties(e.g Name, Value) Thanks! Sorry for the vague question.. I think your reply just answers my question( Structure instead of class).. Thanks guys! ...Show All

• Visual Basic May i know what happen here??

  Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click PictureBox1.Image = "1.JPEG" Label1.Text = "what text" End Sub when i clck this button, the text "what text" will appear. but the picture stil can;t be display. the error showed is " value of type string cannot be converted to 'System.Drawing.Image'" May i know what happen> Ass ...Show All

• SQL Server need help on BOL!!!

  Hi all, I am trying to figure out the meaning in "Specifying Parameters by Using Names" under section OLE DB Source, it can be found on this route BOL -> SSIS -> IS Objects and Concepts -> Data Flow Elements -> IS Sources -> OLE DB Source. Below is the copied section that I do not understand and need someone to help me out with a example if possible: If the actual parameter names are returned from the RDBMS, ...Show All

• Visual C# create DLL with unresolved externals

  Hello! I want to create a dll that uses a GUI framework (wxWidgets). The dll will be loaded by a main application which uses the same framework as well. Hence all the included libraries exist twice when I load the dll which leads to problems with static variables of the framework e.g. the main event table. My intetion is to build the dll without linking the libraries to it and keep the symbols unresolved. These symbols should then ...Show All

• Microsoft ISV Community Center Forums VBA Excel/Oracle query and run-time error 3146

  Hello, I have a small VBA Excel app that queries an Oracle database. Certain tables I hit are quite large, and queries on these large tables (with their associated large datasets) cause the following error: "Run-time error 3146" "ODBC call failed" Googling leads me to believe that this is some sort of timeout problem. Here is the code I use (in part, all variables are appropriately dim'd): [code] s ...Show All

• Visual C++ Why can't I build this simple program from command line?

  Only .Net Framework SDK 2.0 beta2 is installed. The program is really simple: int main() {     System::Console::WriteLine("hello, world"); } I compliled it from the SDK Command Prompt, but error generated: F:\testProj>cl HelloWorld.cpp Microsoft (R) 32-bit C/C++ Optimizing Compiler Version 14.00.50215.44 for 80x86 Copyright (C) Microsoft Corporation.  All rights reserved. HelloWorld.cpp HelloWorld.cpp(5) : error C26 ...Show All

• Windows Forms Close startup form

  i have a startup screen its a login in Ok button i wrote this code dim f as new frm2 f.show() me.close this code close the application how i can solve it. and i have another problem in my frm2 i want to show another form frm3 in my MDI fo ...Show All

• .NET Development Regex expression help

  I need help making a regex expression. I want to find every 3rd comma. Here is my string I want to run the expression on... Day,Amount,Direction,3,100,West,5,43,North,5,44,NorthWest,7,54,South,2,5995,East,,,,,,,,,,54,35345,,,543,North,6,,West Now, I want a regex to find every third comma and then I will replace it with a semicolon ";" with my own code. Eventaully I want the above string to be like this, with every 3rd comma a semicolon Day,Am ...Show All

• SQL Server SQLPrepare and SQLExecute returns Permission Denied in SQL 2005

  I am trying to determine what has changed in SQL Server 2005. We have a application that has used this SQLPrepare and SQLExecute pairs for several years now and all of the sudden on 2005 it fails with a -1 error. Code Sample: odErr = (ODErr)SQLPrepare (hstmt, (PTR)gODCDA->sqlStr, SQL_NTS); if(!odErr){ odErr = (ODErr) SQLExecute(hstmt); } The Statement was "Select * from dbo.tbl1234 where 1=0" This is a standard way we use to get a ...Show All

• Windows Forms Binding to a list

  Hi, I have developed an application which separates the logic from the UI. I want to expose in the library containing the logic a list of custom objects so it can be bind in the UI. 1. How should I implement the list Because I want the list not to be editable I was thinking to make it a ReadOnlyCollection<T> however I want the changes in the list to automatically update the UI and only a BindingList<T> can do that. 2. I also want ...Show All

• Windows Forms Overlaping

  Hi everyone, I am working on Vb.net and I want to make a simple Msgbox to pop up when two images over lap each other can u please tell me if you know thanx, Simon No I want it so that when one picture overlaps another a message box or somin will pop up Dean ...Show All