Search results for query: *

Hi Everyone, I'm using oledb to populate a DataGridView with data from an MS Access database. Can you tell me how to update the database with all changes the user makes in the DataGridView which includes inserts, changes and deletes? The DataGridView is also using a DataView. Thanks. Truly...

Hi Everyone, I would like to get the index number of a tab collection when the user clicks on a tab. I already have a click event in place. Here is what I tried so far: Private Sub Ribbon1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Ribbon1.Click...

Hi Everyone, Can you tell me how do you remove items from the "Choose Toolbox Items" dialog? I uninstalled some WinForms controls but the installer did not remove the items in that dialog. Thanks. Truly, Emad

Hi Everyone, I have been reading that placing all SQL queries into ref cursors is more secure than having them float around the Visual Basic exe file. That is way I would like to know how to load data from an Oracle ref cursor into a datagrid. For now I would use the scott, tiger default...

Hi Everyone, I created this error handler to trap when the user types in an dependent id from a data grid view using Oracle as the database. I did it to replace the default error dialog that is displayed when an error occurs: Public Sub DataErrorEventHandler(ByVal sender As System.Object...

Hi Everyone, I have a scoping question. I have 2 forms and on the main form there are several variables like this: Public Class frmMainForm Dim strSourceMSDataFolder As String = "c:\data\ms data" Dim strSourceDBADataFolder As String = "C:\Data\DBA" Dim strDestinationDrive As...

Hi Everyone, Can you show me the code needed to fill a listbox with only directory (folder) names? Thanks. Truly, Emad

Hi Everyone, Can you show me what code to use to find out what event fires and what control triggered the event to fire? Thanks. Truly, Emad

Hi Everyone, I would like to write some code that will locate the 1st. available removable disk drive such as a thumb drive and store that drive letter into a variable. Can you tell me how do this. Thanks. Truly, Emad

Hi Everyone, I noticed something I did not expect when using the Publish wizard to publish for a CD. After it finished, my Firefox browser loaded up and it tried to load a file but I don't know why. I noticed that all of the necessary files are in the application's publish folder but later I...

Hi Everyone, can you tell me how to locate and delete an item in a listbox? Thanks truly, emad

Hi Everyone, I have a listbox that does not clear. I issued this command while the listbox has focus: lstDBAData.Items.Clear() Can you tell me what I'm missing to get the listbox to clear? Do I need to get focus away from the listbox? If so how do I do that? Thanks in advance. Truly, Emad

Hi Everyone, If I use the following code to create a parameter can you tell me how to extract the parameter name and the parameter value? objSqlCommand.Parameters.AddWithValue("@MyParam", "CA").DbType = DbType.String Truly, Emad

Hi Everyone, I'm experimenting with manually navigating through a DataSet created by the wizard. Please check my navigation code. I can navigate ok through the DataSet but the data on the form is not refreshing. Can you tell me how to refresh it? I already tried to use: Me.Refresh() but I can...

Hi Everyone, I have been reading some books on VB 2008 and also going through the videos provided by Microsoft and wanted to know if hard coding data access more accepted vs using the wizards? I ask because it seems that using the wizards and doing the data binding to the items such as data...

Hi Everyone, Does anyone know of a good detailed tutorial on doing reports with the ReportViewer control? Thanks. Truly, Emad

Hi Everyone, Can a DataReader be used to populate a DataGridView? If yes can you show me what coding I need to use to do this? Thanks. Truly, Emad

Hi Everyone, Can you tell me how to right-align the text in a DataGrid using code? The data in the grid displays OK. I just want to right align the headers. Here is how the grid is populated: Public Class frmComplaints Private objDatabaseStuff As New clsDbUtil Public intComplaintID...

Hi Everyone, Can you look at my code? Can you tell me why I can't display data in my data grid view? The connection string comes directly from pasting the connection string from the server explorer and the SQL statement is from the query builder so I know those are ok. Here's the code...

Hi Everyone, I guess you know from my few posts that I'm new to Visual Basic 2008. I'm looking for a tutorial that show me how to joint 2 separate DataGridView's on a single form. I would like to joint them in a parent child way. I have been able to set up each one to a database table, but I...