Reputation: 2 Apprentice
- Active Posts:
- 22 (0.01 per day)
- 09-February 09
- Profile Views:
- Last Active:
- Jun 14 2012 01:00 PM
- OS Preference:
- Favorite Browser:
- Favorite Processor:
- Favorite Gaming Platform:
- Your Car:
- Dream Kudos:
Posts I've Made
Posted 7 Jun 2012you could try this.
Dim strSQL2 As String strSQL2 = "delete from EMT where Empno='" & mskEmpno.ClipText & "'" Dim comDA as new oledb.oledbdataAdapter comDAdeletecommand = new oledb.oledbdataAdapter(strSQL2, conpayroll) comDA.deletecommand.ExecuteNonQuery() MessageBox.Show("Record is delete from EMT sucvessfully", "Deleteing and existing record", MessageBoxButtons.OK, MessageBoxIcon.Information)
Posted 7 Jun 2012Sounds like windows server 2003 doesn't contain a native driver for the hard disk controller (common enough with newer hardware and older software).
Go with server 2008 if possible or use the F6 to specify a third party driver during startup (when dell drivers site is functioning correctly again).
Posted 7 Jun 2012Thanks John, I don't have the dataset.xsd in solution explorer, only Proj_Name with sub entried My Project and form1.vb
Also I am using visual studio 2008 express edition so some features are not available though. The other problem is while
I can click and get this information, I need the code / program to do it. Seems to be a tricky one alright.
Posted 6 Jun 2012Probably not related to the cast error but you are missing the line "comEMT.commandtext = strSQL2" in the last section
I added it in here
Dim strSQL2 As String strSQL2 = "delete from EMT where Empno='" & mskEmpno.ClipText & "'" comEMT.commandtext = strSQL2 comEMT.ExecuteNonQuery() MessageBox.Show("Record is delete from EMT sucvessfully", "Deleteing and existing record", MessageBoxButtons.OK, MessageBoxIcon.Information)[/b]
Posted 6 Jun 2012Thanks for the reply, I think I may have worded that incorrectly. I can get the column data alright but its the design of the tables I need. I want to see which columns in the tables are primary keys, data type, allow duplicates / nulls etc.
- Member Title:
- New D.I.C Head
- 36 years old
- June 7, 1977
- Years Programming:
- Programming Languages:
- Website URL:
fatbunny hasn't added any friends yet.