NickUk's Q&A profile

• Visual Basic Creating a dataset by dragging and dropping the table form MySQL database.

  With Oracle database, I used to be able to create a dataset by making a database connection in the server explorer and dropping the table onto the dataset designer view. Can you advise if the same would work for MySql database and how. I get the foll error : Mouse drag opertaion failed. The table, view or table-valued function named ''parts'..'PO_mast'' could not be found. Foll. is the error if I try to add a Table Adapter using the wizard, wh ...Show All

• Visual J# How can I encrypt a String to put it into a Database?

  How can I encrypt a String to put it into a Database I've tried with: public static String encrypt( String textoplano) throws IllegalStateException { MessageDigest md = null ; try { md = MessageDigest .getInstance( "SHA" ); // Instancia de generador SHA-1 } catch ( NoSuchAlgorithmException e) { throw new IllegalStateException (e.getMessage()); } try { md.update(texto ...Show All

• Visual Studio Tools for Office Error while locking columns & cells

  Hi, I have one ListObject on ExcelSheet defined as: Microsoft.Office.Tools.Excel.ListObject myListObject = this.Controls.AddListObject(this.Range["A10", missing], "myListObject"); At the designing phase there is no column present into listobject. But when I run the application, data into listobject appears as following: ColA1 ColB1 ColC1 ColD1 ColE1 .............. dataA2 dataB2 dataC2 dataD2 dataE2 ........ ...Show All

• .NET Development Operation must use an updateable Query

  Hi, I am using VS 2003 and C# with OleDb connection to read and write from Excel spreadsheets. I have no problem reading Excel data but when writing to Excel I got this error on this line: oleCmdInsert = new OleDbCommand(@"INSERT INTO [Sheet1$A1:A1] VALUES ('ABC')", _oleConn); oleCmdInsert.ExecuteNonQuery(); Here is the error: System.Data.OleDb.OleDbException: Operation must use an updateable query. at System.Data.OleDb.Ol ...Show All

• Visual Studio There was a failure uploading the URL.... VSS 2005 Beta 2 Web Service

  Hi there, I hope someone is able to help me with a problem to do with VSS2005 Beta 2 Web Service. I've spent nearly a day trying to get it to work, however I've not been able to. Here is a detailed summary of the issue. I am trying to get  Visual Source Safe 2005 Beta 2  to connect to Visual Source Safe 2005 Beta 2 via the Web Service. I had problems actually getting the database to register in Visual Studio until I found this posting ...Show All

• SQL Server Microsoft SQL Server Mobile Edition data source

  i just installed a copy of microsoft sql server 2005 in my pc and decided to follow the newbie's guide: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp frame=true anyway, on the 5th exercise wherein i'm supposed to add a new data connection through the server explorer.. when i chose the option of adding a new data source and was prompted to select a data source i couldnt find t ...Show All

• Visual Studio Team System Excel workItems menu doesn't appear

  Hi, I have installed VS 2005 Team Suite and finished OK. I previously installed Word, Excel and Project 2003. VS seams to work fine but I can't access the workitems menu in MS Excel. If I tried to open Excel from a WorkItems List in VS (for example from Active Bugs query results) I get an error message that says: "Old format or invalid type library. (Exception from HRESULT 0x80028018 (TYPE_E_INVDATAREAD))" The workItems menu in MS Project works ...Show All

• Visual Studio Express Editions Help!Personal Web Site Can not Run!!

  I am  new to ASP.NET and have started exploring VWD. I created a personal web site   using the Personal Web Site Starter Kit that comes with My Web Developers Tools,but it con't run!!The error message is:  Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed. Description: An unhandled exception occurred during the execution of ...Show All

• SQL Server How to add a script component using C# code??

  Hi all, Could you please provide sample code to add a SCRIPT component and LOOKUP component using C# code Also, is there any reference site other than msdn to learn about SSIS programming Regards, Gopi ...Show All

• Windows Forms TreeNode not highlighted on DragOver Event

  I've got 2 treeviews. one treeview contains a heirarchical representation of a group of people, and the other is a collection of tasks. The user should drag the "tasks" over to a "person" to make an assignment. It works well enought, BUT as a user drags a task node from the right hand treeview and drags it over to the left hand treeview the Nodes do not highlight. I have tested and the node being hovered over is actually t ...Show All

• Visual Basic How can i answer an incoming call using TAPI 3.0 in vb.net?

  Hi, I have written small application to alert for incoming calls. it is working fine but now i want to add functionality of answering incoming calls into it. I used msdn help to code my requirement. but it is not working well. Kindly send me an example to accept incoming calls on H323 TSP. Thanks Hi, Please see the reply from Bruno Yu - MSFT here. >>>> http://forum ...Show All

• Visual Studio Express Editions Upgrade Visual Basic 6.0 to VB 2005

  How to upgrade from visual Basic 6.0 to 2005 Hi Revoldo, There are a bunch of resources out there that describe upgrading from VB 6 to VB.NET  2005. Here are some links that should help: http://msdn.microsoft.com/VBRun/default.aspx pull=/library/en-us/dnpag2/html/VB6ToVBNetUpgrade.asp And there is even a code advisor that helps with the migration: http://msdn.microsoft.com/vbasic/previous/2003/downloads/CodeAdvisor ...Show All

• Visual Studio Team System best practice regarding version numbers, release names, etc

  Has anyone any thoughts about best practice regarding the naming of assembly versions, build numbers, changesets, file versions and so forth Background (let me know if this is wrong). a. When I check-in a changeset it is given a unique number and all the files it contains then have their tip version set to this number. For example after checking-in 54 changesets, my next changeset will be 55 and the file ...Show All

• Visual Studio Team System No way to update AreaPath dropdown through Microsoft Project

  I have resigned myself to the fact that the only way to add new area paths is by doing so manually through TFS.  For example, I can't create new ones and attempt to publish them through Microsoft Project. But why , after having added new areas to TFS, can't I get the dropdown in the area column of Microsoft Project to have the new value in it.  The only workaround, which is pretty close to unacceptable, is to create a new ...Show All

• Visual Basic IDE apparently not releasing memory and loosing controls

  OK, I'm having a really hard time with this one. It's never happened to be before and I've been working with VB for a number of years. I'm developing a small application using all vanilla code in VB6. When I run the application in the IDE the memory usage grows with application usage. it's as if memory were being allocated and not released between forms. Related to this is the fact that twice I have run the application and at the end one of my f ...Show All