Answer Questions

• Arkcann Modifying datagrid doesnot update the dataset

  Hi folks, I populated a Sql Server table into a datagrid using SqlDataAdaptor and dataset, which works fine. What I want to do now is to update the table when the data in the datagrid is modified. I added these 2 lines, but doesn't work, ds.AcceptChanges() da.Update(ds.Tables(0)) It seems that changes to the datagrid doesnot update the dataset. Any comments appreciated. Thanks! do you get any errors if so what are they have you tried just: da.Update(ds) usually if the datasource of the datagrid is given: theDataGird.DataSource = ds.Tables(0).DefaultView and you modify values in the datagrid, usually it is automatically commited to the dataset, then cal ...Show All

• KentaroM File not found error using Shell() to execute.

  I am very new to VB and I am using Visual Studio 2005. What I am trying to do is create a simple 'launcher' that opens/runs another file. The problem I have is that I can not seem to get the file to run using the Shell() function. I searched and finally found a way to verify a file exists (because I am using relative paths). I first do a check to see if the file exists using the code I found, and if it does, I use Shell() to run the exact same file. The problem is that the file is found only when looking for it, not when trying to run it. I am guessing it might have something to do with permissions, but really have no clue. Here is the snipet of what I am doing (and yes test.txt is the file I am trying to run). ------------------------ ...Show All

• Koalakk Incorrect DLL Version being used for build

  Hello all, I'm have a problem using VS 2005 when I build the solution I get a error that says: System.IO.FileNotFoundException was unhandled by user code Message="Could not load file or assembly 'INBLK$NamedDataSets_SYSTEM, Version=1.0.2405.25931, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified." Source="INBLK$SystemClasses" StackTrace: at INBLK_SystemClasses.GetData.FormatDSP() at INBLK_SystemClasses.GetData.Fill() in F:\Development\Traffic Management Environment (TME)\InfoBlock Objects\System Objects\INBLK$SystemClasses\clsDataTransporter.vb:line 78 at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object ...Show All

• Scott Carsten How to switch to another application from mine

  Hi, I want to be able to switch to another already running application when a user presses a button on a main form. I can enumerate the running processes and see that the one I want is running, I can get its Window Handle. How can I switch to it. :-) Glad we shared and learned something from each other - that's what it's about! http://www.pinvoke.net/default.aspx/user32/SetForegroundWindow.html Sample here on how to implement the API: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=611602&SiteID=1 Changing the SW_MAXIMISE to SW_NORMAL performs a little better, you can still get the mouse to use menus and it can click the min/max and the button activates (appears to depress) but no longer responds in that ...Show All

• Jamie Gordon Automatic Namespace generation in VB

  I've just finished a dll written in VB. I've never bothered with namespaces much until now, but this is a bit complex, so I've arranged it into sub-folders, with a top-level class, a few sub-classes (and base classes), and other classes that hang off some of the sub-classes. Every class has the same "Namespace Handler" around it. Looks garbage in the object viewer - every class is under the root namespace. When using the object however, it looks fine, i.e. you only see the correct sub-sub-classes hanging off the correct sub-classes, etc. However, one of my colleagues who talks C# had a look at my code, and commented that my namespaces were not declared properly, then we discovered that when coding in C#, the namespace line wer ...Show All

• Tru_Messiah How to display distinct rows from a filled datatable

  Hi, i have a datatable with 1000 records i want to display only distinct city from the table. can i directly get the rows from the datatable without using distict clause in sql query. Thanks Atanu You can create another datatable based on the first using the following Dim d3 As DataTable = dt.DefaultView.ToTable(True, "City") Where dt is your existing datatable and city is the field name - this will create a datatable of unique cities. Spotty Thanks for your answer...exactly i was looking for this solution. Atanu ...Show All

• danskcarvalho [OTP] VBA - About the Excel Chart Object

  Hi all Can anyone can help me to understand about the VBA in Excel. I have a question about "How to add a chart class in the VBA Project" like the picture below http://home.pchome.com.tw/home/mokifish/Pic/Test.JPG These forums are for VB.NET questions. The VB within Excel is Visual Basic for Application. VBA is a very different product from VB.NET and there are some other locations where youy will probably get a quicker and better response to your VBA questions. Y ou may find more assistance in following which specifically deals with VBA development. http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=74&SiteID=1 Or if you are using VBA from wit ...Show All

• Dominik Chrzanowski Visual Studio

  How do you run a .exe file from within a Visual Basic 2005 program I am working on a form that should run one of several Setup.exe files (Not in VB.NET)depending on a choice the user makes. Thanks for your help the commands given earlier should work but to me the access 2003 application that has been packaged is what is causing the error or rather throwing the error to you. It'll be something to do with not giving it say the working directory as stated earlier or perhaps something else. What happens if you just double click on the package (in Windows) - does it run fine no worries, glad I could be of some assistance :-) Thank you Ahmedilyas, you are a genius. Somehow the Setup.e ...Show All

• Pockey Install Windows Service Using InstallUtil.exe

  It's my first to write a service with Visual Studio 2005, at first i had an application written as Console Application, I did copy the code into a new Windows Service Project so my code like like the following: Imports System.IO I mports System.Security Imports System.Security.Permissions Imports system.Data.Odbc Public Class Service1 Protected Overrides Sub OnStart( ByVal args() As String ) Watch() End Sub Protected Overrides Sub OnStop() Some code Here End Sub <Security.Permissions.PermissionSet(SecurityAction.Demand, Name:= "FullTrust" )> _ Private Shared Sub Watch() Some code Here End Sub ' Define the event handlers. Private Shared Sub OnChanged( ByV ...Show All

• fasttrack Listview remove multiple items

  I everyone... i've got this code to remove all selected items in a listview... but i like to know if there is any more simple code to do this ... My code: Dim i As Integer With frmMain.FeedsList For i = 0 To .Items.Count - 1 Try If .Items(i).Selected = True Then .Items.RemoveAt(i) i = i - 1 End If Catch End Try Next End With Thanks But with that way, i need to check all items in listview, not only the selecteditems... I'm going to try to explain the problem... I've got a listview with 5 items for example... and i've got 2 items selected (the index of the selected items are 1 and 3 for exam ...Show All

• rrowe007 SQL Connection accros network

  Hi every One I need to Make My application connected to SQL Server from another machine in Local Area Network I have tried with changing data source name and IP Addres and port number but i fiald Plz Help Hi thanks for replay, My SQL Server Version is 2000 Enterprise Edition , and the error is SQL Server Dose not Exist Or Could not be access But i have tried some thing after posting problem ,I have installed MSDE on client pc and used command osql -L and it have listed my SQL Server so the Server is Exist and the problem Now How Could I Access It Thanks For Your time ok, it could be because the password entered, or even the user account, is invalid. You seem to be connecting to the ...Show All

• Sweeps78 UserControl A use a UserControlB (VBExpress 2005)

  Supose we have two usercontrols A and B named usrA and usrB. usrA ShowDialog() a WindowsForm that contains usrB. usrB contains a DataGribView. The user select a Row from DataGridView and then the form Close. How usrA can know wich DataGridViewRow was Selected in tha DataGridView in usrB witch at its time is contiened in the WindowsForm Please help. Thks very much Dustin, i will try it rigth now. I'll comment you the results. was really amzing the anwer time, thks Here's a quick example how to open another control and set the onclose to capture it's data before the control closes. Public Class Form1 Dim frm2 As New Form2 ...Show All

• Melvinsb Combobox with multiple columns

  I'm filling a combobox from a dataset that has three columns, DealerID, DealerName, DealerState. I can only get one column to display. Is it possible to show two or more columns in a combobox My code follows: adapter.Fill(datList, "tblDealerID")) Dim drDealer as DataRow For Each drDealer in datList.Tables("tblDealerID").Rows cboDealer.Items.Add(drDealer("DealerID")) Next The combobox only handles a single coulmn of displayed data...it does have a displaymember and a valuemember property for binding to the datasource..However if you must display multicolumn in a combo box then you can concantenante you column values: Dim TheValues as String For Each ...Show All

• ieatskunk Eliminate "close" bouton of a form

  hello. A question please. How can I eliminate the "close" bouton of a form Thanks... you have to P/Invoke to do this http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=895666&SiteID=1 VB.NET translation: <DllImport( "user32.dll" , SetLastError:= True )> Private Shared Function GetSystemMenu( ByVal hWnd As IntPtr, ByVal revert As Integer ) As IntPtr End Function <DllImport( "user32.dll" , SetLastError:= True )> Private Shared Function GetMenuItemCount( ByVal hmenu As IntPtr) As Integer End Function <DllImport( "user32.dll" , SetLastError:= True )> Private Shared F ...Show All

• MillBear Traversing Arrays

  I have a text box that contains a Vendor's name, First and last eg; Randy Thomas. I have another text box that I would like to populate with the first initial of the first name and the first 3 characters of the last name to create a vendor code. I am not sure how to create and traverse an array to do this. can anyone help Thanks in advance. tattoo try this out for size Private Sub Button1_Click ( ByVal sender As Object , ByVal e As System . EventArgs ) Handles Button1 . Click For x As Integer = 0 To Me . TextBox1 . Text . Length - 1 If x = 0 Then Me . TextBox2 . Text = Me . TextBox1 . Text . Substring (0, 1) Else If Char . ...Show All