I have som problems with my litle loop, it dosen't return the gratest number in the datagridview.
Dim NumberOfRowsInDGV1 As String = dgv1.BindingContext(dgv1.DataSource, dgv1.DataMember).Count
Dim SearchResultat As String = 0
Dim SearchRow As Integer = 0
NewNumber = 0
[code]...
I use ODBC connection for my application (controlpanel -> administrativetools -> odbc -> DSN) to sql server 2008, and windows authentication
it works perfect on windows xp,but now I run it on windows7 and sql server 2008 with sql server authentication.when I make the DSN and query the connection its ok and I got this message (TESTS COMPLETED SUCCESSFULLY!)but when I run the application I got this error (ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''. ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''.) I think a little more and I found that Maybe my password doesn't save for my user, when I make that DSN?
Some codes here on how could I validate my datagridview? I mean, a certain column on my datagridview should accept integers only, otherwise, it will return a messagebox. Kindly include on which event it should be posted.
View 17 RepliesIn the function it returns the no in one digit .I want it to always return 2 digit number.Like if it is 0, it should return 00.
Public Function GetHexColor(colorObj As System.Drawing.Color) As String
Return Hex(colorObj.R) & Hex(colorObj.G) & Hex(colorObj.B)
End Function
I am working on a lottery application for homework. I am trying to have the Compare function return a number. I want to know how many numbers matched. I don't think that I am moving the random numbers into my lottery array in the correct place.
Module LotteryModule
'Array to hold user numbers.
Public intUserNumbers(4) As Integer
[code].....
want to return decimal number but because of "UBound" its keep displaying as integer how can i display decimal numbers?Public Class frmPrintbooks
Private Sub frmPrintbooks_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
For x = 0.0 To UBound(Form1.printBookName)
lstPrintbooks.Items.Add(Form1.printBookName(x) & " " & String.Format("{0:C}", Form1.printBookPrice(x)))
Next x
End Sub
[Code]...
I have like a collection of numbers like in a hashtable for instance
Code:key / val----+------ 1 / 2349 2 / 939 3 / 49444 4 / 93 5 / 114
How would I go about checking which one of those keys holds the biggest value?
Code:For Each dict As DictionaryEntry In htNumbers
'What?
MsgBox(dict.Value.ToString)
Next
I've just intserted a row into a database, how can i return the ID number of that row that's just been inserted?
Here is my insert code
vb.net
Dim command As New OleDb.OleDbCommand("INSERT INTO StaffData(PaxTitle, FirstName, Middlename, Lastname, DOB, @LastUpdated)", connection)
command.Parameters.AddWithValue("@PaxTitle", TitleTxt.Text)
command.Parameters.AddWithValue("@FirstName", FirstnameTxt.Text)
command.Parameters.AddWithValue("@MiddleName", MiddlenameTxt.Text)
command.Parameters.AddWithValue("@LastName", LastnameTxt.Text)
command.Parameters.AddWithValue("@DOB", DOBTxt.Text)
command.Parameters.AddWithValue("@LastUpdated", Now.ToString)
I have a very simple question: I have a string that may say "3x itemname", or "32x itemname". How do I get it to return the number infront of the x?
View 4 RepliesI want to return a value of a ListBox item, NOT the index number.
My attempt: Dim pInt1 As Integer = ListBox2.Items.Item(0)
i want this code to return the ListBox item's integer value, and not the index number itself how can i return a ListBox item's value?
I can open and read and write to excel, but I need some help on how to search through column A to find a particular text such as B22-11, once found then I need to get the row number (count).
View 11 RepliesI'm trying to search for text that is known to be in a TextBox.
Once it is found, I want to return the line number it was found on.
Also, I would like to know how to delete all blank lines from a TextBox.
These two problems have been plaguing me for the last 2 days.
how can i return the number of records processed from an sql procedure whether it is a select or update/insert query and how can i receive it in the calling method in vb .net.
View 4 RepliesIm trying to return the value contained in a datagridview cell upon clicking on the cell
View 1 Repliesway to return letters like a,b,c,d,.......,x,y,z,aa,ab,ac,ad,.......az,ba,bb,bc,bd,.......bz, in visual basic. I am adding them to the headers of a datagridview. Sort of like excel numbers the headers on columns.
View 2 RepliesI am trying to limit what a data set will return to a DatagridView. Is this possible?For example if I wanted to only show Data that was logged between 2 dates.I have the full Dataset done and am trying to figure out how to use a button to then manipulate the data to show what I want to and not every record in the dataset.
View 7 RepliesI have been having major problems with Datagridviews and attempting to retrieve one row at a time and then assigning that row to an array , Which can be used in another function.I have tried numerous ways to achieve this but none of them seem to work. something like 'Start array of no values to be filled during the while.
dim myArray as Array
While myDataGrid has Rows
assign myArray the values held within the cells of the first row
send myArray to another function for processing
END WHILE
how to handle the keypress event but I can't find a way to update the datagridview cell with the new contents of the editing textbox control. If I add a character to a the text of a cell I want it to react with the new cell contents.
Private Sub DGV_EditingControlShowing(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewEditingControlShowingEventArgs) Handles DGV.EditingControlShowing
[Code].....
How do I trigger a sub after the user hits the Return key within a cell in a specific column in a DataGridView. I know its columnIndex 1 that I care about. I want the sub to fire when the user is editing (i.e. DataGridView1.CurrentCell.IsInEditMode = True).
View 2 RepliesI have an access table and I want to write a query that has a case in it, but it gives me an error message when running the query Error "Syntax Error missing operator in query expression"
[Code]...
In vb.net datagridview the default Enter/Return key behavior is to move to the next row is there a quick and easy way to avoid that.
View 3 Repliesthere had to be an event that fires when mouse moves over the different areas of the Monthcalendar control.without clicking anything, i can see the "focus" moving to the different numbers. What is this event? the hover is for the entire control, but i am looking to return to the user the day or "number" day of the month without having to click on the day?
View 5 RepliesI am unable to load the dat into the data Grid. Here is where I keep getting stuck.
dgvOleDb1 = table.Select
dgvOleDb1.DataSource = DataGridViewEditMode.EditProgrammatically
dgvOleDb1.DataSource = ds.Tables(0)
I am confused; I am using VB2010, IBM.iSeries.DB2 on an as400 V5R4. I am trying to establish an OLEDB connection, and return the values from the selected table to a DataGridView. I had one of the admin's make me file named GARBAGE, in the Rprtaccess catalog. In the past, I have been able to connect via access and an ODBC connection. My project is too big for access, and the SQL middleware we have is clunky and not user friendly. This is a program that will generate the SQL statements, specifically the WHERE: clause and populate the datagrid with the selected criteria. In essence I am making a user friendly striped down program, that has variables that are manipulated by the end user, and the rest, referenced tables and libraries are coded.
Imports System.Data.OleDb
Imports System.Exception
Public Class Form11
[code]....
I'm working on a project and my boss insists I use a DataGrid for this. The grid holds information for work orders, one of the cols has a check box in it. I need the user to be able to select any number of those checkboxes/rows and then return a value to the table "stamping" that users ID. This is what I have so far to get the grids populated... I'm using 2005 with a 2000 Access Database if that helps. Though this will be changed to SQL Server once we get it working (yay more work)...
[code]...
I removed the code from the second grid to make it easier to read, obviously once I can get one to work the second shouldn't be as much trouble.
This is the check box: dgvNewBiz.Columns(1).HeaderText = "Select"At this point if someone knows how to get it to recognize the click event of the check box and pass that row info to a variable that would be super as I'm sure I could probably figure it out from there.
Is there any way to get the date (from Today.Date/User input) to a whole number and then return it to a date string?Only way I have so far thought of is:[code]
View 11 RepliesHow do you get row number DataGridView cell? Specifically, if a user has selected a single cell, how can you get that row number? It needs to access a particular cell based on what the user has selected.
I know that the RemoveAt method can be used to remove at the Focus, but you cannot get the row number at focus apparently?
I had the following code :
Dim row As Integer = 0
For row = 0 To pdgvDataGridView.RowCount - 1
pdgvDataGridView.Rows(row).Cells(0).Value = row + 1
Next
it's to add auto number into first column of each row. The codes running well, but after the codes completed, the first column of each row remain empty.
Is it possible to number the rows in DataGridView ( does this property exist)?
When I load the data from the database to DataGridView I want to show thenumbers of row. like this
0
1
2
3
.
I should move in first position rows that begin with My_Number, but my Datagrid_comb is binding. So I have try this:
[Code]....
OS: windows 7 64-bit /Programming Language: Visual Basic.net on Visual Studio 2010 express edition.I have dataset with 4 tables each one of them is a datasource to a datagridview I want to add a serial number column to the datagridview so I made this
DataGridView1.Columns.Add("serial", "SER.")
For x As Integer = 0 To (ds.Tables("workers").Rows.Count - 1)
DataGridView1("serial", x).Value = (x + 1)
Next
It was working fine untill I added a relationship to the dataset the relationships codes were
Dim relation_WC As New DataRelation("relation_WC", ds.Tables("workers").Columns("id"), ds.Tables("cources_jun").Columns("workerid"))
Dim relation_WV As New DataRelation("relation_WV", ds.Tables("workers").Columns("id"), ds.Tables("vacations_jun").Columns("workerid"))
[code]....
I breaked point the debuging and I found that the serial number column I added is fine and has it's values, but when I reach the line relations.add(the_relation) the serial number column loses it's values and turn into an empty column with no
numbers in it....why this is happening?
Note: I added another relations but the only relations that clear the serial number column are the relations that has a datatable that is a datasource to the datagridview that has the serial number column.