Tory's Q&A profile

• Visual Basic How to Move from a tabel to another (VB6-Ado)

  Good Day.. I have a small problem in vb6 ... I Programed a program that use Ado  to read and write to DataBase(Access97)..In the base there are 4 tables(A-B-C-D)..and have the same Fields I want  The code to Move From The table A (for example) to table B or C..That the the names appeares in the same TextBoxes. And Thank you(Please in hurry  Because the code not for me...) Notic: I used the Wizard Not code connection.. That some of failed tries:   Text5.Text = Adodc1.RecordSource  Adodc1.RecordSource = Adodc1.RecordSource + 1 Selly ,Is n't it ^.^I prefer VB.Net Hi, An ADODC control just handles 1 table o ...Show All

• Visual C++ Cannot register my OCX with VS.Net 2005

  Hello, I have an OCX that was originally written in Visual C++ 6. After upgrading to VS.Net 2003 everything worked fine and I was able to register my OCX. Recently, I tried to upgrade to VS.Net 2005 but had a lot of trouble registering my OCX. I managed to fix many problems related to the OCX registration but I ended up with the following situation: If I compile in "Debug" mode, the compile succeeds and the OCX gets registered (I can see this in the registry). However, when I try to test the OCX using ActiveX Control Test Container I get a debug assertion in File: f:\rtm\vctools\vc7libs\ship\atlmfc\include\afxwin1.inl Lin ...Show All

• Visual Studio Team System VS2005 Options

  Hi, I am still a bit unsure about the version of Visual Studio that will be available at release.  I get the whole thing about the 'Architect version', 'Developer Version' and 'Tester Version' with TFS shipping as a product in its own right.  However in my current job i play the role of a Architect, Developer and Tester.  Which version of Visual Studio will have all the testing tools, and all of Whitehorse many thanks Arran   Chris Menegay wrote: I have also heard that there will be some sort of grace period where you get all 3 anyway while you figure out which you should pick. ...Show All

• .NET Development SqlDataReader

  Hi, I have a stored Procedure in SqlServer database, which executes two sql Select statements & returns the output, i want to store the entire output in a sqldatareader. Is it possible that SqlDataReader will store the entire output bcoz output contains data from two tables. Regards Mahesh DataReader does not store anything. It is forward only cursor that fetches data only row-by-row. If you need to keep your data, then use SqlDataAdapter. It allows to fill in DataSet with the data. In your case DataSet will contain two DataTables, one for each SELECT statement ...Show All

• Visual Studio 2008 (Pre-release) Customize ListView to GridView

  Hi all, May I customize ListView to GridView to support binding data How to set line to ListView Thanks Steven Yes you can ListView/GridView to a data provider. You do this by setting it's ItemsSource property. Then you setup the GridViewColumns to bind to invidual fields via their DisplayMemberPath property or, if templating is required, via Bindings to elements within the CellTemplate. HTH, Drew ...Show All

• .NET Development Writing Data To a XLS File

  Hi everyone, is it posible to write data to XLS file, and then specify to which column, and row it must write to I want to write data to a XLS file, but I first want to know if it's posible to format the layout of a XLS file through VB.NET, well, thats what I am Using. And how, if there's someone who can help me, or derict me to links of how to do that. Thank you Very much   SJB You might want to look into the interop assembly that came with VS.NET 2005. With the new Visual Studio Tools for Office(VSTO), you can have very powerful .NET functionality within office documuents. Look up the Exce ...Show All

• Visual Basic playing mp3 file..

  hi ppl. it's rather a easy question for all u geeks..but i want to know how to play or embed a .mp3 file in a form.. i know how to play midi files or .wav files using windows api function plz help me.. ashish Theres a number of different ways. The easiest is to create a process or shell out to an installed player e.g. mplay32.exe -play mytrack.mp3. Alternatively, you can convert the mp3 to a wav or use a library that handles the necessary api calls for you.  Codeproject   have a good section dedicated to audio. Cathal ...Show All

• SQL Server SSIS Transfer SQL Server Objects Task

  What is the security requirement for running this task I have no problem running this taks as a system administrator but all my users who are in the db_dtsltduser cannot run the same task successfully. They are DBOs in both databases involded in the task. Thank you in advance for your help. What kind of problems do you have with db_dtsltduser Do you have problems accessing the SQL Server objects or do you have any trouble in running the package Please provide detailed info on the problem and the error message. ...Show All

• Visual C# data gri9d

  i need to look at cell in the data grid obect. I am not sure if this code is right. Could you please let me know foreach ( DataGridViewRow dgr in XMLelement_dataGridView.Rows) { // start of for each if (XMLelement_dataGridView.Rows[0].Cells[0] } } I just got done figuring this out. Here's how I did it: private void Dgrid1_SelectedIndexChanged( object sender, System.EventArgs e) { TableCell xCell = (TableCell)Dgrid1.SelectedItem.Controls[1]; //xCell.BackColor = Color.FromName("Red"); Session["strWS"] = xCell.Text; txtTest.Text = Ses ...Show All

• SQL Server Error: The value was too large to fit in the output column "colName" (60).

  Hi All, I'm trying to transfer data from DB2 Database to SQL Server 2005. Well, i used the OLE DB Source, the Data Conversion Component and the OLE DB Destination component. I have five Data flows with this configuration above. But I am receiving an error message from one of them. Please check below the error message: "[Source Table TARTRATE [1]] Error: The value was too large to fit in the output column "ADJ_RATE_PCT" (60). " "[Source Table TARTRATE [1]] Error: The "component "Source Table TARTRATE" (1)" failed because error code 0xC02090F8 occurred, and the error row dispositio ...Show All

• Microsoft ISV Community Center Forums additem issue with populating a combobox

  Hello, I have been working at this for days and am no better off. I could really use some help. I need to populate a combobox with data from a column in an SQL table. I have put together the code below but am having an error at this line: invBegNum.additem rs.Fields.Item("RMDNUMWK").Value Error message: "Object doesn't support this property or method" I'm really a newb but am trying hard to get this.  When I write this line of code to populate the invBegNum combobox, intellisence does not list .additem as a method. I believe that this is the root of my problem. So how do you populate the combobox from a SQL source with VBA 6.3 if the ad ...Show All

• Software Development for Windows Vista Installing VirtualPC on Vista 5270

  Hi guys, I realise that VirtualPC isn't supported on Vista, but has anyone managed to get networking support running My development environment is totally upside down - I want to run XP hosted in a VM on real hardware running Vista. Regards, Gavin Some further information - VirtualPC seems to work fine except for networking. I can access files on the host OS (Vista) using VPC's shared folder mechanism, but when I start the VM up I get the following message: Virtual PC could not open the Virtual Machine Network Services Driver. Access to the external network and host will be unavailable to all virtu ...Show All

• Visual Studio Team System Runtime context different when running through TestMgr and running as an application?

  I am running VS.NET2005 (Version 8.0.50727.42) and are having some problems with a complex test I have that uses a 3rd party assembly. The code is to complex to produce a simple example to show here, but what happens is that when I run the testmethod from a new projects Main method it runs fine, but when I run the same testmethod as a test through TestManager it will fail (assert on an object of the 3rd party assembly that is empty which it should not be). Sometimes VS.NET will crash as well That makes me think that the tests must be run under some other context that is different than running from a Main I pondered if it had something ...Show All

• Windows Forms Suspend Sort

  Ok when I have a BOUND datagridview and I sort a column, and then I  delete the selected cells, which maybe in the sorted category, it fails to delete the cells, because as soon as the value changes it sorts. Is there anyway to suspend the sort for a moment, then delete the cells, and then resume sorting Thanks You could turn off sorting on the DGV's data source. For instance, suppose that the DGV is bound to a BindingSource. Then you could turn off sorting: // save the property descriptor for turning on sorting later on. PropertyDescriptor sort = null ; System.ComponentModel. ListSortDire ...Show All

• SQL Server Enterprise Deployment of SSIS

  Hello, we are interested in upgrading our Data Warehouse environment to SQL Server 2005 to take advantage of SSIS. Our current data warehouse environment consists of 2 production servers with over 900 DTS packages between the 2 servers. Are there any white papers out there detailing what type of deployment works well for an Enterprise wide use of SSIS We're trying to determine if we should use SSIS on the same server hosting our databases, or separate SSIS onto its own dedicated box. If we went the dedicated route, what type of horsepower would we need on the SSIS box (procs, RAM, etc.) Also, if we went the dedicated route, does it make s ...Show All