Single Form With DataGridView Showing Values From Oracle DB
Feb 2, 2010
I have a single form with a datagridview on it showing values from an oracle database. I am trying to set up a way of detecting if the row/column I click on is empty or not, just as a little exercise. I have so far got this:
Private Sub DataGridView1_CellClick(ByVal sender As Object, _
ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) _
Handles DataGridView1.CellClick
Dim c, r As Integer
c = e.ColumnIndex
r = e.RowIndex
[Code] .....
The message going into lbl2 shows the co-ordinate values of any box I click in but as you can see with the IF statement below I am trying to see if the system can detect whenever I click in a value that is empty (null or ''). When I run my form and populate the list with a column of names I can click in 0, 0 cell and I get a message saying the 'Box is not empty' as above.
But when I click in any of the next boxes e.g. (1,0) (2,0) etc I get this:
'Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index'
Pointing to this line of
If Not DataGridView1.Item(r, c).Value Is Nothing Then
Not sure what this means at all. I am under the impression that my piece of code is gathering the value of the item depending on the co-ordinate values. so why should this fail? What index/collection is VB talking about?
View 8 Replies
ADVERTISEMENT
Apr 21, 2010
I am using oracle database and i already created a connection and retrieved data from my oracle DB to Datagridview using oledb commands,now my major challenge which has gotten me sick is to update any changes made in the datagridview to the oracle database. I tried using sqlcommandbuilder but failed. This code is what i used to retrieved the data from oracle and place it into the datagridview.
These are my declarations i made at the beginning of the form:
Private myDA As OleDbDataAdapter
Private myDataSet As DataSet
These are the codes inside the search button to load the retrieved data from oracle into the datagridview
Public con As OleDbConnection = New OleDbConnection("Provider=MSDAORA.1;User ID=SYSTEM; Password=simon; database=project")
[Code]
View 1 Replies
Sep 9, 2010
I'd like to see how others might handle this scenario and perhaps provide some comments on this particular solution for handling null values. I have run into a situation where my application requires data from an ancillary source that cannot be altered/changed, which of course means dealing with poor database architecture and implementation! In this case, my app is running into errors when attempting to set some form controls (textbox) to values from a single ADO.NET DataRow. Perhaps I should be handling this when attempting to set the controls? Not sure, but here is the current way this is done:
View 7 Replies
Dec 11, 2010
I am creating one application using visual basic.net and sqlce I have two forms name Form1 and Form2.
I used Form1 to add data to database using OLeDb command I used Form2 to show data in datagridview by using dataset[code]...
Form2 Datagridview show the old data only, it do not show the recently added data by form1. I mean when I build my application datagridview show the data which is already in the database, but it does not show the data which is added by the form1 during run time.
Some one suggested me to fill the datagridview at run time by using OLeDB command. Then I created Form3 to fill the datagridview2 by using OLedb command and datareader and found that Form3 shows the recently(added by Form1 at run time) added data.
View 5 Replies
Mar 30, 2010
I have a datagridview control on a form that I want to make readonly, before showing the form. I can disable it before showing the form with the [code]...
View 2 Replies
Aug 15, 2011
I have a DataGridView which populates from an SQL query just fine in default mode
using these table names
[firstName] [varchar](20) NOT NULL,
[lastName] [varchar](20) NOT NULL,
[code]....
I have edited the column headers and set the column names to the same values as my table names yet the data is not showing in form load I have set datagridview.AutoGenerateColumns = False I know the data is there if I delete datagridview.AutoGenerateColumns = False then the data is shown with the default headings?
View 3 Replies
Mar 26, 2008
I am using VB2008 Express and a MSSQL Server 2005 db by the way! I have a comprehensive SQL statement, which should fill my Grid:
DECLARE @Sum NUMERIC(9,2)
SELECT @Sum = SUM(I_LS.lmenge)
FROM dbo.lfs AS I_L
[CODE]...
Now here is my problem! I want to have a form with a datagridview that displays all of the values I am querying. This shouldn't be a problem I guess. However, I have no idea how I can integrate two textboxes that can be used to enter the selection criteria (WHERE I_L.lfsnr LIKE '%1253') AND (l.sped_journal = '11-08')[/SIZE]. I have googled and read many threads so far but didn't stumble upon anything that would suit my needs and answer my question. Maybe it's just too elementary!? By the way, it is very important that the input of textbox1 ((WHERE I_L.lfsnr LIKE '%1253')) is linked to 3 positions in my SQL query to define the search criteria!
The worst thing is that I don't want to have a bindingnav displayed! I do not need any delete, update or add functions just the select option, however!
View 1 Replies
Jan 12, 2011
I got a string array & I need to show the contents of it to a single label. It acts like a clock. The thing is I tried with everything I could but I failed. This is the code I've been trying. Its in vb.net. And theres a thread running to slow down the loop so I can display the contents in a label for 2 seconds.
Dim j As Integer
For j = 0 To readText.Length
label.text=readText(j)
Thread.Sleep(2000)
Next
View 5 Replies
Oct 6, 2010
This is bugging me. I have a "main" form named frmMain with a DataGridView object named objDataGrid.When a user double clicks on a row or clicks another button, I hide the main form, open a new form and want to reference the values in the row selected by the user but I keep getting an error when I try to access some, but not all, of the datagridview's properties.
[Code]...
View 1 Replies
Aug 16, 2011
I have a MainForm which contain SecondaryForm as a control of the MainForm.SecondaryForm contains DataGridView which loads data from sql server and I add a collumn named SUM that SUMs all the values of the same row. This is provided within the LOAD event of the SecondaryForm.When SecondaryForm.Load events finishes, the program goes back to MainForm right after the line "SecondaryForm.Show" and here the values of the column SUM disappear.When i write those values runtime, they never disappear.
View 6 Replies
May 15, 2009
i have a datagridview at form1 filled with 2 columns, mailName and callName. upon clicking an edit button, form2 will show with the details of the selected row in the datagridview from form1. how can i pass the values in the selected row from the datagridview to form2? my select statement at form2:
[Code]...
View 3 Replies
Oct 17, 2011
I had a datagridview with databound. I want to write a coding is when user click at any cell of the datagridview, then it will get the whole data of the row and save it into oracle database.
View 7 Replies
Jun 22, 2010
I am filling a datagridview with multiple columns from my oracle database. It has become necessary that I add a column with a checkbox. I figured this out.
[Code]...
View 4 Replies
Aug 30, 2011
I am looking for a way to make my app running in a single instance mode and showing the MainWindow of the first instance when another instance is launched.I do a quick search on the internet but I did'nt find anything to open the MainWindow of the first instance or it was for Windows Form not for WPF.
View 1 Replies
Nov 25, 2011
I have a datagrid on my form, it is set to loads CSV
Can someone tell me how I can show the values of a particular column (showing no duplicates) in a combobox?
View 6 Replies
Feb 21, 2010
Just sorting a value and displaying them with original values. Procedure is displaying the sorted values in msgbox but in place of the original values, it displays the original values again.
Public Sub FlagProb2()
Dim Count() As Integer = {2, 1, 4, 3} 'Original Array
Dim SortedCount() As Integer = Count 'New array for sorted values of original array
Array.Sort(SortedCount) 'Sorting values
For j As Integer = 0 To Count.GetUpperBound(0)
MsgBox(SortedCount(j) & " , " & Count(j)) ' Displaying sorted and unsorted values
Next
End Sub
View 3 Replies
Oct 18, 2011
This is a 2 part question about list comparisons. I see lots of threads on comparing two separate lists, but I need to know how to compare values in a single list.
Part 1:I have a bunch of string values that I am first splitting and then adding to two separate lists. The strings look something like this... 3-ABC, 6-DEC, 11-RFG, 6-ABC, 12-ABC, etc... So, with the code below(vb) I am splitting the numerical portion of the string and putting it into myLeadQtys(saved for later). I then take the rest of the string and put it in another list (myLeadVals):
Dim myLeadVals As New List(Of String)
Dim myLeadQtys As New List(Of String)
Dim strMtextValue As String
[code]....
View 3 Replies
Feb 18, 2011
let me explain further i have table account. in the table are 2 columns namely account_type,Account_name.So on the forms, i want the combo to show the 2 columns even though ony one column would be saved. Am able to do this in access as attached.[code]...
View 5 Replies
Jun 6, 2011
the code display 2 colunms in one combo box from a table. i have table with 2 columns account_type and account_name. the account_type is an abbreviation(codes) which would be stored in a new table when selected. I want the code when the combo is click, would display the code-account_type and account_name in the same combo box.
Private Sub cboAccount_type_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cboAccount_type.SelectedIndexChanged
Dim cn As New SqlConnection(ConnectionString)
Dim query As String = "Select Concat(Account_type, ' - ', Account_Name) As AccountDesc, Account_type from Accounts"
[code]....
View 13 Replies
Mar 22, 2011
I have a few problems i need to solve. Firstly, I am looking for a piece of code i can use to display a picture from a bank of pictures. It will work on the basis of generating a random number and loading a picture that corresponds to that number.
i.e. Dim RandNumber As Integer
Dim RandClass As New Random
RandNumber = RandClass.next(1, 10)
If RandNumber = 1 Then
Picturebox1.image = picture1
[Code]...
Secondly, can I then use subsequent picture boxes to display pictures from the same bank of images, without displaying the same image? Finally, I then need to be able to click the picture or a button beneath the picture to select it as an answer to a question and then the whole process starts again.
View 1 Replies
Mar 4, 2010
I am reading a csv file in to a datatable in vb.net and making a few checks and appending an extra column. I then want to perform a bulk insert using microsofts Oracle.DataAccess (no choice in this) to an Oracle database. what would be the best way to perform this as there is no bulkImport like in SQLserver.
View 2 Replies
Dec 29, 2009
can you tell me,how can i add a provider for oracle(Microsoft Provider oledb for oracle).Actually i had Microsoft ODBC for oracle but i want to add a provider above mention.
View 2 Replies
Feb 18, 2011
I am developing a form which needed to display 2 values from a combo . I have table Account with these fields Account_type, Account_name in this table. Even though I am saving only the Account_type in to a new table but when selecting from the combo, I want the account_name also display since the account_type is a code so that user would understand the mening of the acount_type. vb.net code that would display both the code and the account name to this. I used data binding to do this, it also displayed only the code.
View 1 Replies
Jul 9, 2009
I have this working for a single field in a text but im trying to add more than one fields data .[code]...
View 7 Replies
Dec 13, 2011
I need to execute a stored function in oracle or sql through vb.net. I created a command object. Depending on the database type(oracle or SQL) i am preparing the Command text as Select functionName(?,?,?,?,?,?,?,?) from dual; (For Oracle) Adding the parameter values of the function. Now performing the ExecuteScalar which is not working saying invalid parameter. This works with ODBC connection string. But ODBC doesn't with 64bit. My Requirement: Code should execute a user defined stored procedure by taking the values at runtime.
View 1 Replies
Feb 1, 2011
i can't get the data to be shown in the datagridview what am i doing wrong here? i think the problem starts in the ---- if then statement
[Code].....
View 2 Replies
Nov 15, 2011
Unable to display data in datagridview : vb 2010 express + mysql server 5 + odbc connector
1. I am able to connect database successfully. I am using arraylist to set data.& also i m
getting till it set to dataview (Object name )
2. Till now i am not added any column name in datagridview property setting .
[add/remove column]'[code...]
View 2 Replies
Feb 23, 2010
I'm using VB.Net and SQL Server 2005.
I have two Listboxes that users can select multiple values. Selection Mode = Multiple.
Listbox1 has Customers
Listbox2 has Products
I would like users to select a Customer (single value) from Listbox1 and Products (Multiple values) from ListBox2 I need to insert the selected values into the database like this:
John Shampoo
John Toothpaste
John ShowerGel
How can I Insert these values with a single Click event into the History table?
View 2 Replies
Nov 30, 2011
I am trying the following to select a long date, but becase the value is stored in SQL database as DateTime I am unable to return any results unless minutes and seconds match perfectly...I then tried to use 2 calendars and have the same issue with the DateTime format..
CODE:
View 1 Replies
Jun 10, 2011
I have tested my code in order to pass single value to single parameter field in crystal report from VB.NET Form, it is ok but the problem is that I want to pass multiple values to only one parameter field called "Product Name" and it displays only one last record.
I want to display like this
Receipt : 0001 Product Name
pencil
pen
stamp
book
[Code]....
I already set parameter field "productname" for allowing to multiple values, but it is still the same.
View 2 Replies