| | |
canot find a column
Please support our VB.NET advertiser: Intel Parallel Studio Home
Thread Solved |
•
•
Join Date: Jun 2009
Posts: 132
Reputation:
Solved Threads: 13
VB.NET Syntax (Toggle Plain Text)
frmColourName.ShowDialog() 'adding a customer m_Customercount = m_Customercount + 1 Dim drNewRow As DataRow = m_CustomerDataTable.NewRow() drNewRow("CustID") = m_Customercount drNewRow("Company") = txtCompName.Text.Trim drNewRow("Address") = txtAddress.Text.Trim drNewRow("Telephone") = txtContact.Text.Trim drNewRow("Address") = txtAddress.Text.Trim drNewRow("Email") = btnEmail.Text.Trim Dim counter As Integer = 0 While counter < m_CustomerDataTable.Rows.Count If m_CustomerDataTable.Rows(counter)("Company") = txtCompName.Text.Trim Then MessageBox.Show("This company already exists") Exit Sub End If counter = counter + 1 End While m_CustomerDataTable.Rows.Add(drNewRow) m_CustomerDataAdapter.Update(m_CustomerDataTable) 'end of add 'adding a colourcombination m_Colourcount = m_Colourcount + 1 Dim drNewRow1 As DataRow = m_ColourDataTable.NewRow() drNewRow1("CID") = m_Colourcount drNewRow1("CustID") = m_Customercount drNewRow1("ColourName") = g_colourname m_ColourDataTable.Rows.Add(drNewRow1) m_ColourDataAdapter.Update(m_ColourDataTable) 'end of add cboColourName.Enabled = True cboColourCode.Enabled = True lstColourName.Items.Add(g_colourname) lstColourName.SelectedItem = g_colourname txtCompName.Enabled = False txtAddress.Enabled = False txtContact.Enabled = False btnEmail.Enabled = False btnNewCombination.Enabled = False End Sub
this was working fine for quite a while
but after i made some changes to the other part of the programs which do not seem to be related to this in any way i get this error msg
VB.NET Syntax (Toggle Plain Text)
cannot find column CustID
thn i get the same error for the second line
VB.NET Syntax (Toggle Plain Text)
cannot find column company
![]() |
Similar Threads
- binary search trees (Java)
- Find value from Cell in dataGridView (C++)
- SelectedIndex_changed event of ListBox control (VB.NET)
- select statement in a procedure (Oracle)
- Drivers for PCI Ethernet Controller and/or networking help (Windows 95 / 98 / Me)
- SQL Create table error (ASP.NET)
- Reading CSV in VC++ (C++)
- CSV file (C)
- Media Disconnected/RPC is Unavailable?? (Community Introductions)
- Simple sql questions (broken commands and retrieving columns) (Database Design)
Other Threads in the VB.NET Forum
- Previous Thread: Saving Drawing on PictureBox to SQL Database
- Next Thread: Disable MDI parent form button from MDI child form
| Thread Tools | Search this Thread |
"crystal .net .net2005 30minutes 2008 access add application arithmetic array assignment basic binary box button buttons center click code combo combobox component connectionstring convert cpu data database databasesearch datagrid datagridview design dissertation dissertations dissertationthesis dosconsolevb.net editvb.net employees excel exists firewall folder image images isnumericfuntioncall login math memory mobile module ms msaccess mssqlbackend mysql navigate net opacity pan peertopeervideostreaming picturebox picturebox1 port print printpreview problemwithinstallation project record regex reports" reuse right-to-left save savedialog search serial sorting sqldatbase storedprocedure string temp textbox timer txttoxmlconverter updown useraccounts usercontol usercontrol vb vb.net vb.netcode vb.nettoolboxvisualbasic2008sidebar vbnet view vista visual visualbasic visualbasic.net visualstudio web wpf xml






