Answer Questions

• Colin Bowern SQL Stored Procedure with VB.NET code, no dataview

  To all the guru's out there in VB.NET and SQL 2005. I wish I could join you but unfortunately I have long way to go. I have one form, one button, one text box, one label. I have this piece of code which I pass to SQL via the stored procedure which the user enters in the textbox. After clicking on the Fetch button, I would like the results of the stored procedure - whether I need to add more labels to seperate the results - to reflect as the label.text Please could you let me know how this could be done as I do not want to use the dataview grid at all. Public Class Form1 Dim cn As System.Data.SqlClient.SqlConnection Dim da As System.Data.SqlClient.SqlDataAdapter Private Sub btnFetch_Click( ByVal sender As ...Show All

• Jassim Rahma Image On Mouse Over.

  How do I get an imgae to display & follow the mouse by having my mouse over another image Ok, heres the deal: I need to get an image to display (like a tooltip) when I put my cursor over another image. Thats about it. If you can help me with this that would be nice :) 2 things: 1. I posted a 2nd topic because I don't even know if the 1st got posted. I had no microsoft alert things come up so I just assumed it didn't post. and 2. Thank you SOOOOO much! I really needed this code. you see I'm programming a form based game and I just learned how to do cinematics so I needed my 3rd important aspect of the game. Thanks! ~Chris a.k.a. Dellmonty Bruno, Sounds to me like the OP wants the mouse pointer to change to an ima ...Show All

• Nightmare_BE Could someone point me in the right direction?

  Not even sure where to start. Need to subtract quantity from inventory table when quantity is added to invoice table. Start with transaction stored procedure Any guidance would be appreciated. As a test database created two tables: Invoice: Field: Item as integer Field: Quantity as integer Stock: Field: Item as integer Field: Quantity as integer Added a record to stock Item = 1 and Quantity = 10. Added a record to stock Item = 2 and Quantity = 10. Added the following trigger: CREATE TRIGGER newstockvalue AFTER INSERT ON invoice FOR EACH ROW BEGIN UPDATE stock SET stock.quantity = stock.quantity - NEW.quantity WHERE stock.item=NEW.item; END; When I insert a record into the In ...Show All

• Sledgehammer Updating Report Links in MS-Access database.

    Hi,   I am a new bee to .NET.   I have a Ms-Acess Database which is protected by password. This table contains tables, queries and reports. One more database contains links(references to the first database). If any table structure is changed in the first table, in order to update links I need to manually open database and Tools->Database Utilities -> Link Table Manager from the second database.  I want a solution which automatically updates all these links by using either VC#.NET or VB.NET or VB6.0 Please help me, it is urgent.   Thank you..,     Thanks Paul for reply. You still need to use ADO/ADOX (or DAO) to refresh table links. See the following: ...Show All

• Lemus IPAddress.ToString expected to return a.b.c.d but returns d.c.b.a

  I have a function from a third party vendor which returns an IPAddress in the form of a VB.NET UInteger. I am trying to convert this into the dotted decimal form by doing the following: Dim oAddress as New System.Net.IPAddress( [IP in UInteger form] ) Dim sAddress as String = oAddress.ToString I would expect the above to work, but where I am expecting to see "10.1.0.21", what I am getting is "21.0.1.10". Am I not using this right IP-addresses in binary format are stored in an unusual, non-Intel CPU compatible way called BigEndian . The bytes are in reversed order. If the 3rd party vendor gives you the address stored in an UInteger, you better watch out for software quality i ...Show All

• Dhanya Ajith Refresh a texbox with data from database

  Hello, I have a textbox bound to a dataset. After the user edits the textbox, I prompt the user if they want to save the data. When they select 'No', the data does not get updated in the database, however the edited changes are still shown in the text box. How do I refresh the textbox with data from the database If I understand correctly, you wish to restore the value of the textbox.Text property to what the value was when it was bound from the database If this is correct, then you can perhaps 1) fill a dataTable with data from the database, then add the textbindings. You will have the data stored in the dataTable, so when they select "no" to save changes, simply look back up at the dataTable for the row/column you had bound ...Show All

• vien11 app.config settings

  I have a solution made up of 2 projects; ProjA is a windows forms app, and ProjB is a Data Access DLL. ProjA references ProjB and uses methods and objects from ProjB to get it's data. The connection information for ProjB is defined in an app.config file (within ProjB). When running within VS2005 everything work fine (i.e changes to the settings are reflected in the connection string built and used by ProjB). I now want to do some testing of the application on another machine so have done a build of the solution. The ProjA\bin\release folder contains most of the files that I would expect (including the ProjB.DLL), but there is no ProjB.DLL.config file. However the application runs fine on the other computer! - Where is it getting t ...Show All

• jazztuffy Access --> SQL

  Not sure where to post this, so will start here. I have written an application which links to a MS Access mdb as a data source. I now need to migrate this to MS SQL. I have imported the tables into SQL ans recreated the views (query). However, I want to change the Data source in my VS2005 - VB app. Everything is the same name wise etc. Is there an easy way to achieve this and will I need to recreate those query (fill) that I have attached to the tables internally Any advice would be greatly appreciated. Many thanks in advance (i hope!) :-D Sorry for the disjointed manner of this answer. please read ALL of it before applying anything. < connectionStrings >   < add ...Show All

• mts2325 Exception has been thrown by the target of an invocation

  Hi, I am getting an error message "Exception has been thrown by the target of an invocation" when my application is loading a vb.net 2005 form. I am using vb.net 2005 with SP1, and framework version v2.0.50727 Any idea what could be causing this Thanks This is usually the exception you get when a constructor throws an exception. Try catching the exception. You usually get some more extended information on what exception was thrown etc. When the exception is thrown and caught in the IDE, check the InnerException property. Please post the name, message and stack trace of the inner exception as that's going to provide the most information a ...Show All

• Brant Yin Anyone find a solution to documentcompleted event?

  hi, It's a little emergency. I have a window form project that the window form embeded a web browser object-AxSHDocVw. When the program finish navigation the URL and show the web page in the web browser object, the program go to parse the DOM tree. I write the parsing program into the docuemtcomplete handle. Sometime the system trigger the documentcomplete handle, but the web browser was not really download complete the whole html document. It will cause the DOM tree parsing error. How can I avoid this situation And let me ensure that the navigation is really finished completely! Thanks a lot! Y. J. Sample program: Private Sub wb_DocumentComplete(ByVal sender As System.Object, ByVal e As AxSHDocVw.DWebBrowserEvents2_DocumentCompleteE ...Show All

• Hearty81 Simple data access to access

  I am trying to learn using vb.net express. I have a single form with a single button. the button exectues this code: Dim constr As String = "Provider=Microsoft.Jet.Oledb.4.0; Data Source=d:\mydocs\db1.mdb" Dim conn As New OleDbConnection(constr) Dim dt As New DataTable() Dim cmd As New OleDbCommand( "select guid from table1 where company = 'sspi'" , conn) conn.Open() Dim dr As OleDbDataReader = cmd.ExecuteReader() dt.Load(dr) Now I want to have a msgbox that reports the results from the select statement. How do I do that What is the return object With regards to ahmedilyas's comments about the DataTable: I'm concerned abo ...Show All

• Tecnomage Working text files without a binary mode

  Hello I need some help for a troubleshot that I have in a VB.NET 2003 program that I develop at this time. I need to open a text file for "read mode" and, at the same time, 3 or more text file for "write mode". I tried already but I didn't any result. Can have anybody who help me Thanks a lot. In this my own code, I need to read a text file and write its content in two or three other text files at the same time, depending some conditions. Do you have an idea about how do I this If yes, explain it to me, please. It's important for me. I did this in VB6 but, at this moment, I need to pass the code to VB.NET 2003. I have VB.NET 2005 also, but I'm feeling better in the 2003 version. What co ...Show All

• Lakshmi N User Defined Type not defined

  hi, I'm having 10 projects in a group. 9 of them are dlls/ocx, when i execute the projects individually they run fine..But when i execute them in the group the message is popped up. "User defined type not defined". Any help appreciated. I also tried to set the compartibility to "No Compartibility", but individually they work fine and do not show where the mismatch is. I cannot set the "No Compartibility" to all the projects in the Group, obivously they'll fail. Request your help. Thanks & Regards, Amit Hi Nasir, Thanks for your reply, I have already added each project to the Group as you have mentioned. All the dll's have not referenced directly instead its corresponding COM pr ...Show All

• Rei Miyasaka Sql String and changes to DB table structure

  Scenario: strSql = "select name, address from customers" If a column "Hiredate" is added to the customers table, how does this affect my code Do I have to recompile I should only modify my code and then recompile if the "name" and "address" are deleted or modified from the customers table right Thank you.   morphius1 wrote: strSql = "select name, address from customers" This code gets only name and address fileds from the customer table, if you add a new field to this table, it will not affect your code. As you said: as long as you don't delete or change the name of these columns there will not be any problem, but with this c ...Show All

• BSohante VB6.0 to .NEt migration strategy

  Hi All, We are looking for information that would help us understand the complexities involved in the migration for Windows and Web apps. Can somebody share information on a definitive guide for VB/ASP to .NET migration. TIA. Please visit Visual Basic 6.0 Resource Center , there are many articles that help you to upgrade to Visual Basic .NET. ...Show All