I'm in the process of converting an app to vb.net 2008. I was using an msflexgrid previously. I am not using a database to fill the datagrid but as the application recieves data via a tcp connection I place the data into the datagrid's columns. The problem I am having is with column widths. I found this code by doing a search on here and added to my form.
[Code]...
I am trying to execute a stored procedure and place the data in a datagrid manually (without using the .net wizard). I am using vb.net and asp.net in visual studio.Here is my code but I can't figure out where I'm going wrong.
Imports System.Data.Sql,
Imports System.Data.SqlClient
Imports System.Diagnostics
Imports System
[code].....
My goal is to connect to my database either manually or using an sqladapater, and get information from two of my databases on sql server 2005. Then I want to take this information and on run-time begin to add/subtract/divide/multiply certain columns and place the information into other columns. I can do this in queries, however, I want to do it on run-time what is the best way to achieve this.I had some of this working, but I just want to start fresh and see how you would go about doing this.
[Code]...
I have a datagridview control that will be used to allow the user to input records. The control uses a combobox column to select a type of service. There is a rate associated with the type of service that I then want to display in the grid. The user then enters a quantity and the last column mulitplies the rate and quantity to get a total. I have the combobox , quantity and total columns figured out but I don't know how to get the rate column to automatically be selected when the type of service is selected. Below is the code.... sets up the datagridview
Dim dv As New DataView(LookupManager.Lookups.LookupServiceType)
Dim Column1 As New DataGridViewComboBoxColumn
With Column1
[code].....
I finally got this code to work after hours of toiling:
[Code]...
Now that I figured that out I was going to try and place the data in a specific location. On my application I have a datagridview set up with 4 columns. What I would like to do is put column A of the excel file under the 1st column of the datagridview and column C of the Excel File in the second column of the datagridview.
[Code]...
I finally got this code to work:
vb
Dim path As String = OpenFileDialog1.FileName
Dim myDataset As New DataSet()
Dim strConn = New OleDbConnection("Provider=Microsoft.ACE.Oledb.12.0;Data Source=" & path & ";Extended Properties=""Excel 12.0;HDR=YES;IMEX=1""")
Dim myData As New OleDb.OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn)
myData.Fill(myDataset)
DataGridView1.DataSource = myDataset.Tables(0).DefaultView
Now that I figured that out I was going to try and place the data in a specific location. On my application I have a datagridview set up with 4 columns. What I would like to do is put column A of the excel file under the 1st column of the datagridview and column C of the Excel File in the second column of the datagridview.
So replace:
vb
DataGridView1.DataSource = myDataset.Tables(0).DefaultView
With:
vb
DataGridView1.columns(0) = myDataset.Tables(0).columns(0)
DataGridView1.columns(1) = myDataset.Tables(0).columns(2)
Obviously this doesnt work, and something tells me I might need a for loop to import the data, but I have never imported information from an Excel file before and to make it worse I have never worked with datagridviews before so I have no idea how to go about this.
I would like to do something like this if I could:
vb
For x = 1 To xldoc.rows.length - 1
DataGridView1.Item(0, x).Value = CType(xlDoc.Cells(0, x + 1), Excel.Range).Text
Next
I have a few forms that the user uses to select data records and then perform some analysis on them.So the selected records are presented in a datagrid and each in turn it reviewed and the analysis data added to the extra columns, works very.
However, if the user clicks on a column to sort the grid, the unbound fields are not sorted with it, just blanked out. I can prevent them from sorting, but it would be nice if it could sort the full grid.
I trying to place a datetimepicker on a datagrid, code I'm using is below. when I run it I receive an error at the yellow highlight point in the code, "Null reference exception was unhandled by user code." not sure what I'm miss or should be corrected.
Imports System
Imports System.Windows.Forms
Private picker
As DateTimePicker
[code]....
I'm using VB.net 2005. I have working programs that I populate DataGridViews with something like the following:
[Code]...
I have set up my connection to SQL Database.
Public Sub ConnectToSql()
Dim conn As New SqlClient.SqlConnection
' TODO: Modify the connection string and include any
' additional required properties for your database.
[Code] .....
How can I export specific columns from datagrid to specific SQL Table (and match up the columns (column names in datagrid are different to Column Names in SQL Table).
How can I set up my WPF datagrid to sort on multiple columns similar to having two sortable columns, clicking on the header of the first column for a primary sort and then SHIFT clicking on the header of the second column for a secondary sort. I would like the multiple column sort to happen automatically when the user clicks on the header of the first column without having to SHIFT click on the second column header. Is there a way to do this entirely in the xaml? If not how can I do this in the code behind? Currently using VB.Net but a C# snippet is acceptable if you have one.
View 2 Repliesi want to make a datagrid with 2 columns and many rows
the columns i want to have databinding with a datatable
i want the 1 row 1 column of datagrid have data from 1 row of datatable
i want the 1 row 2 column of datagrid have data from 2 row of datatable
[code].....
Got a data grid view with two check box columns in it. Currently, got one set up and working how I want it using this
[Code]...
I am using DataGrid control in VB. I have created a DataTable at runtime and added 5 columns in this Datatable. I binded the data table with DataGrid control.
Width of DataGrid is 880. The default width of 5 columns of data table in DataGrid is 100. So for 5 columns width used = 500. So an empty space of 380 left at the right hand cornor of DataGrid. I want to fill this empty space with these 5 columns. I want to increase the width of columns so that it fully covered in DataGrid.
In my datagrid, I know the number of rows that it will have - it will always have 12 rows.Can I scroll through the cells downwards via the columns instead of the usual horizontal way via the rows?
View 3 RepliesI want to add more than one column to a grid...The following does NOT work, how can i do it?
Dim AmountRounds As Integer
DataGridView1.ColumnCount = Amount + 2
Dim contcolumn As New DataGridViewTextBoxColumn
For AmountRounds = 1 To Amount - 1
[code]....
how can I know what are the indexes of the columns in my datagrid?
View 6 RepliesI want to allow the user to select which table they want to be displayed in the datagrid by selecting the table name from a comboBox - this bit I have managed but I want to limit the number of columns displayed. Each of my tables have the same fields (it is for a plant database, there is a table for each type of plant tree, shrub etc) so I know the column headings but
View 2 RepliesI have a datagrid with customer data such as ID, name, email, phone etc.When I select a row (with a button or selectionchanged) I want to store that row's columns in variables like
dim email as string
dim name as string
email = dgCustomers.theselectedrow.theselectedcell
[code].....
I have a datagrid, I am filling it with LINQ as well as a custom class to add data to it.Afterwards, I need the data in a specific order - it seems to ignore me.How do I change a columns properties, like index etc??[code]
View 3 RepliesI read data from a xml file and display all the contents in datagrid view. I want to extract collection of columns with same or similar contents - i.e I have three columns A,B,C and five rows in xml file. In column C, row no. 1,3,5 is filled with 'X's and row no. 2,4 is filled with 'Y's. I want to extract all columns which is related to the Columns C's content 'X'.Right now I am only able to extract one column which is related to X from Column C. How can I fix this ??
[Code]...
I have some questions formating my datagrid and its columns but unfortunately unsuccessfully. How to change the alignment of a DataGridViewTextBoxColumn? I could only set the alignment of the whole datagrid. I tried to do this by code but it didn't do anything:
datagridOnlineStores.Columns("osowner").DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight
I tried defaultcellstyle but it doesn't do anything then is there any way I could change the color of the border of the whole datagrid because it's black I don't like it.
I'm trying to create a datagrid with auto generating columns. Let's say my Collection is a property named Articles of my viewmodel of type ObservableCollection<ArticleWrapper>.
I bind now the ItemsSource to this collection:
<wpf:DataGrid ItemsSource={Binding Articles} />
The class ArticleWrapper is like this:
[c#]
public class ArticleWrapper
{
public ArticleConfigurationSet ArticleConfigurationSet { get; set; }
public string Description { get; set; }
[Code]....
But now my problem: I want to bind the displayed data to my ArticleConfigurationSet property. But I cannot change my ItemsSource Binding, because the SelectedItem property of the datagrid must be of ArticleWrapper (for command handling).
The datagrid should also look like this:
how to change nthe columns widths and the row height within a datagrid view
View 2 RepliesI have an ArrayList that are separated by the pipe:
colA | colB | colC | colD
How can I bind that array into separate columns in a datagrid each with their own column header?
I have an application with various datagrids. I have a specific need for the order of the columns (which I set at design time) but for some reason Visual Studio regularly changes the order of my columns on me when opening the project is VS. So, every time I compile I have to go make sure the columns are still in the correct order. Sometimes they are, sometimes they aren't.
I remember this same behavior in 2002/03 version of Visual Studio with tabs and tab order. If it makes a difference, these datagrids are created at design time with LINQ2SQL Data Sources. I did this all the time with VS2008 and never noticed this behavior.
This is what i have for my set of columns:
[Code]...
2nd question. How can i bind other queries from different table to these columns. like Column[2]and Column[3] should come from a different query.
is there any way to stretch a datagrid's control columns so they would take all the space width of the form?I can set datagrid's dock property to bottom so it will take all the bottom by height but the right side of the data grid will stay empty which is not good.If I set datagrid's dock property to right it jumps all over the form...So I need a way to fill up my datagrid's bottom and right (width) side so I would not have empty space.
View 3 RepliesI am using datagridview to show the data when the form load.Datagridview have a template checkbox column also where the user will select the class to attend.I want to loop the datagrid and find the selected row ro columns value when the user click the save button How i do this am using vb.net 2008?
View 8 RepliesI placed a datagrid in my form which l retrive data from my sql. i am using oledb connection. if i run the form i can retrive the data but i am not getting the data in the grid at first ,there is a "+" sign, i have to clik that then it shows the table name and after clicking the table name i can view the data displays in the grid..
View 1 Replies
