roy-roy's Q&A profile

• Visual C++ about VC+MySQL problem:)

  about VC+MySQL problem:) i install mysql odbc V5.0 driver i need to ADO Connect MYSQL DB; code: _ConnectionPtr m_CMConnect; ::CoInitialize(NULL); m_CMConnect.CreateInstance(__uuidof(Connection)); m_CMConnect->Open("Provider=MySQL;server=localhost;DataBase=test;port=3306;uid=root;pwd=","","",-1); but Program run error..... how to Ado Connect MYSQL DB; thank:) Hello Re: about VC+MySQL problem:) Such questions are outside the scope of this forum - for the scope of the VC General forum please look at: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=19445&SiteID=1 For such issues please use the newsgroups at http://msdn.microsoft.com/newsgroups. ...Show All

• Visual Studio Programatically accessing "Add Service Reference"

  To add a web reference i click on web reference manuall in the IDE. To do that using code i do the following ProjectItem webReferenceItem = (( VSProject2 )project.Object).AddWebReference(_webServiceUrl); How can i do the same thing for "Add Service Reference" This feature was added to my IDE as a part of the .NET 3.0 Visual Studio Extensions package. In other words i want to know the DLL and Class using which i can add a Service Reference Manually similar to the way i have add a web reference by code Thanks for ur time Dear Suraj, sorry for replying so late. Unfortunately the .NET 3.0 Visual Studio Extensions does not expose an API that can be used to add service references programmatically. As a workaro ...Show All

• SQL Server results of a stored procedure

  How do I filter the results of a stored procedure Chyna, You can use your report table filter - (Properties/Filter Tab) to place an expression to filter data return from the stored procedure. Ham ...Show All

• Visual C# UnauthorizedAccessException during writing XML file from a DataSet object

  Hai, I am using .net 2.0 frame work with WIN 2000 Server, the following error occured while trying to convert & write XML document from DataSet obj. ERROR: Access to the path "C:\WINNT\system32\Cusromers.xml" is denied. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.UnauthorizedAccessException: Access to the path "C:\WINNT\system32\Cusromers.xml" is denied. The ASP.NET process is not authorized to access the requested resource. For security reasons the default ASP.NET process identity is '{machinename}\ASPNET', which has limited ...Show All

• SharePoint Products and Technologies Options for Updating Excel displayed thru Excel Web Access ?

  I'm developing a dashboard which contains some graphs surfaced through Excel Web Access. This works great. However, is there a way of updating the Excel data without going into Excel (e.g. via a synchronized SharePoint list or by using infoPath) so I have more control over the UI I'm really looked for a code free solution so I don't have to worry about maintenance and deployment issues in the future, and so power users can also use the same method for their own sites. Ian, Did the above post answer your question Let us know if there's more info needed, otherwise I would greatly appreciate if you marked the post as Answered so we can get it off the radar. Thanks! ...Show All

• Visual Basic vbDesign Help

  I have heard that using the smallest datatype in a program does not necessarily save space in memory, as memory is optimised to work in blocks of a certain size, possibly VB Long. Is this correct, or is it best to use the smallest datatype that will safely hold the data required. One important piece of advice, which I can confirm from experience, is: Always use a large enough data type to allow for future growth. You might expect that a variable to hold sales figures would never need to contain more than 99 million, but allow for even more, as it may need to hold, for example, a company-wide summary of sales for the past twenty years, and suddenly the program will crash if the data type is too small. Smaller is usually better to ...Show All

• Windows Forms Application.Exit()?????

  I wanted to know how can i do a check before I exit an windows application sort of like if a user clicks the X to close the form..I want to do a MessageBox.Show(are u sure u want to close", MessageBoxButtons.YesNo) and then maybe do if DialogResult == Yes then do Me.Close else I want to keep the form active....any help on how i should get this done Same thing (in VB) but just use the FormClosing event of the main form (no need to override)... Private Sub Form1_FormClosing( ByVal sender As Object , ByVal e As System.Windows.Forms.FormClosingEventArgs) Handles Me .FormClosing Dim result As DialogResult = MessageBox.Show( "Are you sure you want to exit " , _ "Warning" , _ Mes ...Show All

• Community Chat Computer Controlled RC Car

  Hey guys, I just built a computer controlled RC car! There's a nice Coding4Fun article on doing this ..but I took a slightly different approach. Instead of using a relay board, I only used a few transistors. Check it out: http://ashishrd.blogspot.com/2007/02/computer-controlled-rc-car.html . I hope you all find it interesting. :) Ashish Well, he has purchased a PC - Bee Automation Adaptor. I just used four BC547 transistors..you can get four of them for just $0.60. That's cheap. :) ...Show All

• SQL Server Error connecting to local SQL Server Express with SQL Server management Studio Express

  I have SQL Server 2005 Express Edition installed on a Windows Server 2003 SP1 machine. I am trying to connect to the server on the local machine via shared memory with SQL Server Management Studio Express but I get the following error message: TITLE: Connect to Server ------------------------------ Cannot connect to SERVER\SQLEXPRESS. ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft ...Show All

• SQL Server dynamic Query - ODBC connectivity

  I am trying to create Dynamic Query.Connecting to Sybase database source through ODBC, but I try to pass Paremeter by using @. It says error. Also If i pass &Parameters!Parametername.Value is also not working.Its not saying error for string values but for numeric it says reror. Also in the Query builder i am not able to give expression by giving = "select some Query". I fgiven an solution or example would be great. Thanks in advance. I'm not sure but ... does ODBC support named parameters Try using as parameter, not a questionmark as prefix but like this: select * from bla where something = ...Show All

• Smart Device Development How to Format SD Card with FAT16

  Hi guys, I want to develop a program to format SD Card with FAE16 in Wince5.0,VS2005. I've tried the following two methods: 1.OpenStore()->DismountStore()->FormatStore()->CreatePartitionEX(),the parameter bByteType is 0x04,which indicates FAT16.The result,File System is FAT32. 2.FormatVolume(),after include "Formatdisk.h" my complier sad the function "Formatdisk.h" is not founded. and then I use "Find" to find the file,and then found the file is not existed in my computer. Why does the msdn say the function is supported in Windows CE .NET 4.0 and later but I can't use it http://msdn.microsoft.com/library/default.asp url=/library/en-us/wcemain4/html/cmrefformatvolume.asp All suggestion is apprecia ...Show All

• Windows Forms How to get control value from one project to other project

  I have a Windows Form application with a simple GUI that contains a progress bar. Pushing the button 'Start' on my form invokes some other project[ in same solution] classes that carry out a lot of calculations and database access. I want to show the user the progress of the program. The program is actually a loop of database migration that are handled. My solution contains more the one project. we have different layer. Presentation layer. bussines layer. My question is: How do I make the progress bar update itself from other layer, when we dont have reference in bussines layer Thanks in advance for your help ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Importing and Embedding Flash Movies into XNA

  hello, I am currently evaluating the XNA Framework for the company I work for, and I would like to know if it is possible to display a .swf file into XNA's 3D Engine I believe I heard someone mention that they were able to, but they were somewhat sparse on the details. If I could get more information on this, I would be sincerely appreciative. Thanks! There is nothing built into the XNA framework to play a flash file. You would have to create your own component, or use one built by someone else. I haven't heard off hand if a component such as this actually exists. ...Show All

• Visual Studio Installing VS2003 add-in programmatically or using registry file.

  Hi, In my product installation I have to also install VS2003 addin. One way to achieve this is to launch the default set up that is created by Visual Studio 2003. However I want to install the add-in dll not using the default setup. How can I achieve the same Thanks and Best Regards, Vishal Hi Vishal, You can remove default installation project from your solution and use another way. I can recommend using WiX - that is XML Windows Installer. WiX allows you create whatever installer you wish. More details about WiX you'll find on this site . Note that WiX include special extension for Visual Studio named Votive (it's included into distributive as well). So you can add WiX project to the solu ...Show All

• Windows Forms Bind data to the TreeView Control

  I want to bind data with a Datatable to the TreeViews nodes. There is a DataTable with datas and I want to bind it with TreeViews nodes. The nodes wiil be created dynamically. How can I do this Look at the DataBindings property of the tree view try this:   theTreeView.DataBindings.Add (PropertyName, theDataTable, ColumnSource)   does this help   If not, I think you may need to go through each row/column of data in the datatable and add the item in the treeview, see below for an example.   foreach (DataRow currentRow in theDataTable.Rows) {    theTreeView.Nodes.Add(currentRow["ColumnName"].ToString()); }   ...Show All