I have the following dataset and datatable:
Dim topics As New DataSet()
Public Function JT_PullData(ByVal TableName As String) As DataTable
If topics.Tables.Count >= 1 Then
topics.Clear()
[Code]...
I am supposed to set the dataset and then set the values that would be shown.
I have a normal DGV on my form.To make this more readable I want to custom color the rows. 1 row blue, 1 row white, ex... I attached an image to show what I want to do. The smaller dgv in the picture is what i want to achieve.
View 3 RepliesI have an unbound DataGridView control that displays a few columns of account data. The first column is a combobox that I fill with data from a dataset of names filtered by what's in a customer field on the form. When you click on a combo on one of the populated rows, the available names come up in the combo. But if the first click in the datagridview is on a new row's combo, various (incorrect) names appear. Only after you click on one of the populated row's comboboxes, does the correct data appear in the new row's combobox control.
I don't really understand why this is happening. I have been using the EditingControlShowing event to populate and add the combo to the new row, but it doesn't seem to be working very well. I hope someone out there has some ideas about the correct way to do this.
I have a vb.net website with a gridview that currently has exam questions displaying vertically in each row like this:
Name question answer
-----------------------
Joe question1 answer1
Joe question2 answer2
[code]....
But I would like to change it, so that each question is a header, like this:
Name question1 question2 question3
----------------------------------
Joe answer1 answer2 answer3
Jill answer1 answer2 answer3
This makes it more readable since each user is only listed once.I would like to stick with a gridview instead of rewriting all my code.I am actually binding my data to the gridview via some other programmers class. I am using LINQ like this:
Return (From entry In report.FetchAllEntries()
Select questionID = entry.Question.QuestionID,
userID = entry.Session.User.ID,
[code]....
I am having issues assinging values to a multi-dimensional array.
I am trying to build a 2 col, unlimited row array and populate with data from a data reader.
Dim tblArry(,) As String = {}
If reader.HasRows Then
While reader.Read()
[Code].....
When I use a Jagged Array I can get this to work. The Reader portion is workig just fine, but the coding is just not clean for this problem.
I've got a window with multiple datagridviews. Each with data from a separate dataTable. All of which are part of the same DataSet. There are a couple of places where one DataTable has a field joined with the lookup dataTable from the dataset. For example a lookup table for LugSizes has a field called LugSize that is also it's primary key. Another table called Device Terminations has a field called LugSize to which the user can only select those values from the LugSize lookup table. I thought it would be as simple as using the Items.Add method for the combobox column whenever a new lookup table row was added to its own datagridview. Unfortunately, when I try to initially clear the items list, the data error event is triggered for every row.
Here's a sample of my code if it helps:
HTML
Private Sub FillLugSizeComboBox()
Try
If colDTLugSize.Items.Count > 0 Then colDTLugSize.Items.Clear()
[Code]....
I am wondering if data grid automatically shows a first column (empty) before the others, if that can be edited out.
View 14 RepliesI'm sick today and cannot think straight but I have to get this done. I have an array: newarray() I need to populate this array if a condition applies as such:
[Code]...
I Want to populate a combo box in vb 2008 with mysql, but when i run the thing that appear is "System.__ComObject"..kindly check the errors..
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
conn = New ADODB.Connection
[Code].....
I would like to populate a drop down list using values from the database. I would like to know how I can add to the dropdown list both the display member and value member straight all from the database
Display Name: Account_Name
Member Value: Account_ID
I am trying to populate a datagridview with the content of a text file.
the text file contents are as follows:
[Code].....
I get no error while building the project. The textline variables are being populated correctly.
Imports MySql.Data.MySqlClient
Public Class Form2
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim conn As MySqlConnection
[code]....
I can't quite figure out how to populate the dang list with that code, am I doing something wrong?
What I want it to do, is when a id is selected to be modified, another form will pop up with the fields are filled in with the relative data. Every time I run this I keep getting the following error -- "Syntax error in string in query expression '(the wombat ID selected)'"when it gets to the following line of "fillformDataReader = fillformCommand.ExecuteReader()"What is going wrong and how do I go about fixing this error so the new form is populated with the correct data?
Dim fillformCommand As New OleDbCommand
Dim nameView, idView, regionView, sexView, ageView, weightView, lengthView, sampleView, commieView, descriptionView As String
[code].....
I am trying to populate an Access table with data from a csv file. Here is my code
csvConn.Open()
Dim objAdapter As New OleDb.OleDbDataAdapter
Dim objCmdSelect As New OleDb.OleDbCommand("SELECT * FROM [reporting.csv]", csvConn)
[Code]....
The csv has 58 rows of data. The Access table I get is 58 rows of the same data as the first row of the csv. Am I not using parameters correctly?
I have a form with a DataGridView and ComboBox, both of which are populated with data from an Excel spreadsheet, the source is unbound. My problem is in repopulating the DataGridView with data from another worksheet in the same Excel file when the user selects the corresponding value from the ComboBox. For example if they were to select January from the ComboBox then the DataGridView would load in and display the data contained on say Sheet2, selecting February would load Sheet 3 and so on. I am running Visual Studio 2008.
View 6 RepliesI have a few drop down lists that I'd like to populate from a table in an SQL database. I tried setting it in the DataBindings section of Properties but I guess that doesn't work.
View 11 Repliesif this question has already been answered many times, but I am new to VB and I don't really understand any of the examples I have found by trying to research this topic. I am using VB 2008 Express Edition. My List View is called listView.
View 4 RepliesIm trying to populate a combo box with a column in an excel file.Im not even sure where to start. I searched around but couldn't find the info I needed or samples to learn from.
Can anyone point me in the right direction to where I may accomplish this?
I'm trying to create a treeview in a VB 2008 project that shows all the elements and attributes of an XML Schema.The MSDN documentation for XML schemas seems to imply that by loading the schema into an XMLSchemaSet and compiling it I should get access to all the elements and attributes with their values but this doesn't seem to work in practice.
Using a for loop such as:For Each elem As XmlSchemaElement In compiledSchema.Elements.Values
I can use elem.Name to get the element name (and attribute name with a similar nested loop) for a simple type but this doesn't work for a complex type.Whenever (and however) I try to get values for complex types I hit a brick wall.
[Code]...
I've been playing with a DGV. Let's say for my question here, I want a grid that is 10x10. I would like the font in each cell to be Arial 10 regular. Only one character will be in each cell (I'll use "M"). I would LIKE the cells to be 17 pixels by 17 pixels. But, if I manually force the column width to be 17, I get about half of my M and three dots "M...". I'm thinking this is a padding thing but as far as I can tell, everything is set to 0. See code and then more comments below:
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
With DataGridView1
[Code]....
Question 1: How can I reclaim some of what seems to be lost space around the cell contents so I don't have to make them bigger than they need to be? I'd like them to be 17x17 with the single character centered within.
Question 2: Do I have to manually set the height and width of each row and column? I'm thinking the RowTemplate setting but can't seem to get it to work.
FYI: This is a new project with a DGV dragged onto the form. All changes have been made programatically.
I have a field in an access database with decimals in it. I am using ADO to read in the data and are trying to assign it to a textbox in a form. This works fine when its a whole number. But it doesnt seem to work when its a decimal for some reason.
I have declared the variable i have assigned the access field to as a double, but when i set up a test textbox which i point the variable at and times it by 1000, it doesnt work. Works perfectly when i change the access field entry to a whole number though.
This sounds like im not using the right syntax or something.
I have some code that is extracting tracked changes from a document. The trouble is its very slow, taking around 60 seconds to capture each tracked change. I originally thought that pagination was slowing down the code (its quite a large word document). However I have turned that off but its made no difference to the speed of the function.
[Code]...
i am having an issue populating two combo boxes on form load. The program will connect to an access database and pull data as instructed. Then as it pulls each record it puts it into the combo box.
This was working.. atleast i think it was. i dont recall it ever not working, however i wasn't looking for it.
My problem is that if when i load the MDI parent form and have it skip the selection form and the login form and load the next form in the sequence, it loads everything perfectly. However if the select form is loaded first, then the login form and then the form i need loaded, it will not populate. The only difference between the two different loads is that the login form calls a function that loads the form as a new project.form
I did this so that I can have multiple forms open at a time. I am assuming my problem is that I need to get the child forms handle then populating controls using that handle? but i think if I had to do that then I would beable to populate the comboboxes on the first form load using the login method of opening the form.
Here's my code.
vb.net
Private Sub frmLine1t5_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.Text = "Line " & LineNumber & " Test Form"
[Code].....
How to add a checkbox column at first column of datagridview including column header?After adding, how to code to "check all" or "uncheck all"?
View 27 RepliesI have a datagridview in a winform for my .net application. Using access 07 for db. I am trying to retrieve the name of the selected column but I have found nothing available to assist me. This is what I do on the ColumnheaderMouseClick event :
[Code]...
In a DGV there are 3 columns. we need to populate a column with a value corresponding to the previous column value,
like,
DefaultValues:
Id | Name
[code].....
how do I set a column of a datagrid so that it will only accept numbers? I have this column labeled "Grade" which of course, should not accept letters. I have done setting its Format property but it is not working.
View 3 RepliesI am using VB.Net 2008 and have build a windows form with a datagridview that displays a query of records for the current client. One of the columns is for Fee. I need to total that column and place the result in a Label or Textbox. I am using the Query builder to pull the records and so I can not get away with the SQL expression in the query returns the Schema does not match error. I have tried to code it pulling the information directly into the form from the Datagridview and could not make that work either.
View 1 RepliesI have following codes
str2 = "select sno,name from employees where sno =" & Val(Me.TextBox1.Text)
cmd2 = New SqlClient.SqlCommand(str2, con)
da2 = New SqlClient.SqlDataAdapter(cmd2)
dt2 = New DataTable
da2.Fill(dt2)
Now dt2 has two columns as sno and name
But I want to add a 3rd column city type char(80)
Right now when I need to refer to a cell to update the text I do it this way:
DG1.Rows(intRow).Cells(1).Value = "Hello!"
Is there a way to use the column name for column #1 rather than the number? This way if I decide to add columns later in an update and it's not at the end of the current columns, I do not have to re-number all my code. I tried searching but must not be looking for the right keywords.