408 Topics
| |
Imports DemoExcelFileHandling.DataSet1 Imports DemoExcelFileHandling.DataSet1TableAdapters Public Class ReadFromExcel Private dt As New dtMonthDataTable Private ta As New taMonth Private bs As New BindingSource Private Sub BindUI() dgvExcelData.AutoGenerateColumns = False colYear.DataPropertyName = "Year1" colMonth.DataPropertyName = "Month1" colFacility.DataPropertyName = "Facility" colProductCode.DataPropertyName = "ProductCode" colProductDesc.DataPropertyName = "ProductDesc" colUnit.DataPropertyName = "UnitOfIssue" colBegBalance.DataPropertyName = "Beginning_Balance" colQtyReceived.DataPropertyName … | |
There are many examples of reading an xml file and populating a datagridview. I would like to pull the xml from a string instead. Dim myXMLfile As String = "C:\tmp\accountlist.xml" Dim ds As New DataSet() ds.ReadXml(myXMLfile) DataGrid1.DataSource = ds DataGrid1.DataMember = "account" The above code works when the xml data … | |
I am populating a datagrid with 3 columns with varying rows depending on the data. how can i print the column data straight to a com port printer | |
hey all once again i have a little issue ... i'am really having a hard time with this issue i have a datagridview that contain one column as a text and another column as a combobox i would like to populate the combobox from MS Access Table and as a … | |
Dear All Master, please help me for my first program that i want to create...i have problem for save from datagridview to access database...everytime i try to save , only first line have save...another not save...sory for my bad english language...thank's here my code.... Sub simpen() Dim i As Integer … | |
I am creating a pageant scoring system. I managed to display the field names from different tables : [Click Here](http://oi58.tinypic.com/5c0jz5.jpg) The first column "Participants" is from Participant table and the succeeding columns is looped from the Criteria table. This is the code: Private Sub CreateDataEntry(ByVal CatID As Integer) Me.CriteriaTableAdapter.FillByCategory(Me.PSSdbDataSet.Criteria, CatID) … | |
I have 2 tables in sql , one is called stock and the other stock warning the stock table has columns ' Pid, pdescr,current stock, stock warning' this shows up in datagridview 2nd table(stock warning) has columns 'pdescr, current stock' showing in datagridview in the stock table when the 'current … | |
I am trying to bind data to my DataGridView. (However, this is the easy explanation.) Background on what I am trying to accomplish: I have a rather large program here. This part of the code uses a DataGridView to display the data I have read and parsed (from another program … | |
hi everyone my question is how to clear a datagrid view in vb.net 2010 i have tried DatGridView1.Clear() but it only works once and i would like to clear my datagrid every time i click the load button hers my code Private Sub Button15_Click(sender As System.Object, e As System.EventArgs) Handles … | |
Hi Im just wondering if anyone can help me out? I have a text file that contains data that i want to load into a datagrid view I'm new to vb.net so i really have no idea on how iam supposed to start im using vb.net 2010 thanks in advance | |
i want to comare textbox value with datagridview items before adding this textbox value in datagridview | |
*new to C#* I have created a form , with a working coding , but i need an extra assistance. Somewhat , i am stuck on trying to figure out how to let the 3rd combobox value , determined by the first and second. Like this : [Main Form](http://i.imgur.com/1rePOge.png) For … | |
I have created a form , with a working coding , but i need an extra assistance. Somewhat , i am stuck on trying to figure out how to let the 3rd combobox value , determined by the first and second. and what i wanted is , something like , … | |
I am trying to get a value from a DataGridViewComboBoxColumn cell that is named "Item". When I run the program and make a selection from the combobox, string itemValue always returns ""; ie string.null. What am I doing wrong in getting this value that I need to set price on … | |
I was wondering if I can fill up an edited row based on the value in my Label. Here's the scenario: An employee will add and edit rows in the DataGridView1. All rows involved in adding and editing will fill up the last row with the Employee ID of the … | |
Hi I need help in making an auto complete feature in my datagridview where if I input a certain cell it will automatically have a value or it will have a autocomplete suggestion (like a textbox link to a table) based on my other table. I don't have any clues … | |
As the title says I'm having trouble in my Vehicle Maintenance routine where I will have a a monthly maintenance based on the last maintenance date. If the vehicle has reach 1 month since last maintenance it will show in a datagrid. Also it should select those vehicle that reach … | |
Hello, I would appreciate some help to import data from a text file to a datagridview. If anyone could give me a hint to get started... The textfiles have the column name in the "[ ]" I would like to read the data after the [wp], [pos], [rad] blocks, the … | |
Hi, I have a class called "car" with - I have no ideia how to say this in english - "data members" as the following: Public pneu As classDoor Public mat As classTire Public length As Double And so on. All the related classes have null constructors. I have a … | |
i have been doing like the code below, but why when i clicking the "delete" button, it is delete all records in the datagridview, but it does not updating to the database. And, how do i make only the selected row that has been selected by the user that gonna … | |
Am developing a software for submission as project. As a part of it, am planning to create a Phonebook package. I created a database in access and i integrated it in VB.Net. Information: Database name : Contacts.accdb DataTable : Contacts Contents in table : First Name,Last Name, Phone, Address... Platform … | |
I have two forms "Sales" and "PurCh". The datagridview in the Sales form is being populated by a stored procedure that is carried out when the form loads and it works perfectly. But the datagridview from the "PurCh" form has refused to populate when the form loads. I initially thought … | |
Hi everyone! I have a datagridview and I want to automatically fill it Let me explain: I have a matrix (gainMatrix) and I want to fill my datagridview by the latter, here is a piece of code that I use for filling: for (int i =0; i <ala.size(); i++ ) … | |
Hi there ! how to select row from datagridview when column have cells is empty I tried this but nothing worked Please help on this private void selectrow() { int i; for( i=0 ;i<dataGridView1 .Rows .Count -1;i++) { string row = dataGridView1.Rows[i].Cells["Name"].Value.ToString(); if (row =="") { sqlconn.Open(); string sqlquery = … | |
If I have a datagridview of say 7 Rows and 27 Columns and if I need to compare the values of cells with another cells how to do it? Detail: I need to compare 1st Row cell value with rest of the 6 rows cell values, same thing repeats for … | |
Dear All I am unware the fact that whether it is possible to show different values from access table to a single datagridview cell. For example. If table xyz contain data like this col1 col2 col3 col4 Col5 B1 P1 P1 P2 P1/P1 B2 P1 P2 P3 B3 P1 P2 … | |
Is there any way to show data from access table to some particular columns. For eg. Table have following data BCode TCode1 Slot1 TCode2 Slot2 TCode3 Slot Batch1 T1 10:00 T2 12:00 Batch2 T1 08:00 T2 09:00 T3 11:30 Batch3 T1 08:00 T2 10:00 T3 11:00 I want to show … | |
Windows Application Form: I have a problem with filtering winform datagridview by listbox items (multiselect). For example: My listbox items have guest name of 'Lim', 'Jack' and 'May'. I would like to filter my gridview data by these 3 guests. Which each guest has their own entry. This is my … | |
I want to filter my datagrid view in my winform with a date range. I have 2 label with StartingDate(lblStart) and EndingDate(lblEnd) which is called from the datepicker on another form. Filter = "(DATE >= '" + Convert.ToDateTime(lblStart.Text).ToString("dd/MM/yyyy") + "' and DATE <= '" + Convert.ToDateTime(lblEnd.Text).ToString("dd/MM/yyyy") + "')"; And this … | |
I have a access database from where I am populating the datagridview on button click event. but what I exactly I want to add record of access database in datagridview when button is clicked. Means on 1st click 1 record should be add in datagridview, on 2nd click another record … |
The End.