Visual Basic

FirstPrevNext

Re: Please Help.. Update MS Access using DataGridView in VB2005 vbDigger'z8-Oct-07 19:43 vbDigger'z 8-Oct-07 19:43  Do? OleDbDataAdapter.Update() supports (multiple or INNER JOIN) MS Access Table to be update?? or any other way to update two tables at the same time without making manual hardtype code or such a very long codes?? because in some instance of my application.. I have a DataGridView which its records came from an sql query which are two join table.. The Loading of record works fine.. but when i try to make changes into the DataGridView which also means dataset has also committ changes?? and i try to update the record using: <b>OleDbDataAdapter.Update()</b> then an ERROR occur just like this: <b>System.InvalidOperationException: Dynamic SQL generation is not supported against multiple base tables. at System.Data.Common.DbDataAdapter.UpdatingRowStatusErrors(RowUpdatingEventArgs rowUpdatedEvent, DataRow dataRow) at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping) at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping) at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable) at System.Data.Common.DbDataAdapter.Update(DataSet dataSet) at Employee.frmDTR.UpdateRecord() in C:\Employee\frmDTR.vb:line 136</b> ****************** Heres my Code... ************************** Private Sub LoadRecord(ByVal strSQL As String) Try Me.Cursor = Cursors.WaitCursor oleConnection.ConnectionString = dbConnectionString oleConnection.Open() oleDataAdapter = New OleDbDataAdapter(strSQL, oleConnection) oleCommandBuilder = New OleDbCommandBuilder(oleDataAdapter) dbDataSet = New DataSet() oleDataAdapter.Fill(dbDataSet) DataGridView1.DataSource = dbDataSet.Tables(0).DefaultView Me.Cursor = Cursors.Default Catch ex As Exception MsgBox(ex.ToString()) Finally oleConnection.Close() End Try End Sub Public Sub UpdateRecord() Try oleConnection.Open() oleDataAdapter.Update(dbDataSet) Catch ex As Exception MsgBox(ex.ToString()) Finally oleConnection.Close() End Try End Sub *************************** heres my SQL Query ******************************* LoadRecord("SELECT p.IDno as [ID No],p.Lastname,p.Firstname,t.[Time In],t.[Time Out],t.[Date In],t.[Date Out],t.[Remarks] FROM tblPersonal as p inner join tblTimeEntry as t on t.IDNo = p.IDNo Order by p.Lastname") ************ Please anybody there.. Re: Please Help.. Update MS Access using DataGridView in VB2005 Dave Kreskowiak9-Oct-07 1:51 Dave Kreskowiak 9-Oct-07 1:51  DataAdapters only work with single-table queries. Anything more complicated and you have to supply ALL the SQL statements and objects to update the database yourself. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Re: Please Help.. Update MS Access using DataGridView in VB2005 vbDigger'z9-Oct-07 15:57 vbDigger'z 9-Oct-07 15:57  Thank your very much... I've already created a manual/hardtype code to do that... i'm just wondering if VB2005 has that kind of function so i can make the code much easier... ehehe.. anyway... thank so much again.. such a great help! Want To Make My Software as Trial Version [modified] aarti838-Oct-07 16:50 aarti83 8-Oct-07 16:50  Plz can Any one tell me how to make a s/w as Trial Version....For 15 Days.... Thanks -- modified at 23:01 Monday 8th October, 2007 Re: Want To Make My Software as Trial Version Dave Kreskowiak8-Oct-07 17:53 Dave Kreskowiak 8-Oct-07 17:53  Due to the large subject, you're going to need to do some research into licensing. Google "vb.net licensing"[^] A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 report ini vb.net di3.ny288-Oct-07 15:56 di3.ny28 8-Oct-07 15:56  hello.... I need article to report in vb.net 2005,, do you have this article? please... Iam very...very... need it. Re: report ini vb.net Dave Kreskowiak8-Oct-07 17:50 Dave Kreskowiak 8-Oct-07 17:50  Geez. Was typing ""vb.net report"[^] into Google so difficult?? A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 retrieve the length of an mp3 file? Mr Oizo8-Oct-07 8:04 Mr Oizo 8-Oct-07 8:04  Hi can anybody help me? I need to retrieve the song play length for mp3 files for my program? I'm not concerned about the other ID3 tag information. Just the mp3 song length(aka individual mp3 file play lengths). please help. thanks Mr Oizo Re: retrieve the length of an mp3 file? JamesS[C1]8-Oct-07 8:24 JamesS[C1] 8-Oct-07 8:24  Hello Mr Ozio, I hope the code below helps to retrieve information about MP3 file: Option Explicit Public Type MP3Info Tag As String * 3 Songname As String * 30 Artist As String * 30 Album As String * 30 Year As String * 4 Comment As String * 30 Genre As String * 1 End Type Function MP3GetInfo(strFileName As String) As MP3Info Dim sTemp As String, iFreeFile As Integer On Error GoTo ErrFailed iFreeFile = FreeFile Open strFileName For Binary As iFreeFile With MP3GetInfo Get #1, FileLen(strFileName) - 127, .Tag If Not .Tag = "TAG" Then Debug.Print "No tag for " & strFileName Else Get #1, , .Songname Get #1, , .Artist Get #1, , .Album Get #1, , .Year Get #1, , .Comment Get #1, , .Genre End If End With Close iFreeFile Exit Function ErrFailed: Debug.Print "Error in MP3GetInfo: " & Err.Description Close iFreeFile End Function Thanks, James Smith James Smith www.componentone.com Re: retrieve the length of an mp3 file? Mr Oizo8-Oct-07 10:44 Mr Oizo 8-Oct-07 10:44  Half that code doen't run.I think thats like vb6 or something. Dunno. I'll try change it a bit but I'm really looking to just get the mp3file play time length(song length)? What line or 2 do I use thanks for the reply Mr Oizo Re: retrieve the length of an mp3 file? Christian Graus8-Oct-07 13:41 Christian Graus 8-Oct-07 13:41  Assuming this works at all, it looks to me like it reads id3 tags, which don't include length. Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum ) Re: retrieve the length of an mp3 file? Christian Graus8-Oct-07 13:40 Christian Graus 8-Oct-07 13:40  Both managed DirectX and the Windows Media Player can give you this info. MDX might be better, I think it will do it without a control being required on a form. Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum ) Enquiry TheSpiritSong8-Oct-07 7:03 TheSpiritSong 8-Oct-07 7:03  Hello all. I am in college, my major is CNS. However, we are taking programming I for VB.Net, and either my teacher is awful OR I am just dense when it comes to this stuff. Is there any websites that I can go to get Help via tutorials etc. for this? Any help is appreciated. Thank you Kristi Re: Enquiry Ajay.k_Singh8-Oct-07 7:42 Ajay.k_Singh 8-Oct-07 7:42  Search for ‘vb.net’ on Google and you will get enough links for tutorials. However one which I may suggest you is www.startvbdotnet.com, check other sites also. -Dave. Dave Traister, ComponentOne LLC. www.componentone.com Re: Enquiry TheSpiritSong9-Oct-07 8:01 TheSpiritSong 9-Oct-07 8:01  Thank you Dave Re: Enquiry Kschuler8-Oct-07 8:01 Kschuler 8-Oct-07 8:01  Hello. Like Dave said in his reply, and I know it sounds crazy, a lot of times when programmers get stuck the best place to start is google. Here is a tutorial I found via google: http://visualbasic.about.com/od/learnvbnet/a/LVBE_L1.htm[^] If you run into any specific problems you can always post it here. Good Luck. Re: Enquiry TheSpiritSong9-Oct-07 8:01 TheSpiritSong 9-Oct-07 8:01  Thank you very much Re: Enquiry GuyThiebaut8-Oct-07 8:22 GuyThiebaut 8-Oct-07 8:22  Hi, Here is a good VB .NET tutorial Click Here The tutorial is a programming tutorial so it misses quite a bit of the background to .NET - however if you want to get stuck in to programming immediately it is well worth a look at. In fact I used this to teach myself VB .NET so it comes highly recommended. Good luck on your journey through .NET and enjoy Guy You always pass failure on the way to success. Re: Enquiry TheSpiritSong9-Oct-07 8:00 TheSpiritSong 9-Oct-07 8:00  Thank you so much for your help How to find who last logged on to a PC over the network DJH18-Oct-07 6:21 DJH1 8-Oct-07 6:21  Hi Anybody out there know how to trace who was the last user to logon to a PC using a LAN account as opposed to a local account. I have tried various options searching the AD using the DSQuery and DSGET commands but rather think this may need some kind of vbs or VB script. Thanks Re: How to find who last logged on to a PC over the network Dave Kreskowiak8-Oct-07 6:42 Dave Kreskowiak 8-Oct-07 6:42  This isn't tracked by AD or the machine, unless auditing is turned on. Only then will it show up in the machines event log. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Re: How to find who last logged on to a PC over the network DJH18-Oct-07 6:48 DJH1 8-Oct-07 6:48  Thank you for your quick response Enumerator Class help barney_19728-Oct-07 5:47 barney_1972 8-Oct-07 5:47  I want to create a class to hold the many enums i have created, instead of having them in various applications. I have need where somewhere where the class contents can be accessed without instantiating the class, for example. Instead of.... Dim EnumObject as New EnumeratorClass Dim Integer as int32 Integer = EnumObject.FileActionEnum.Open I want to do......... Imports SomeNamespace.EnumeratorClass (or something similar) Dim Integer as Int32 = EnumeratorClass.FileActionEnum.Open Can anybody give me a nudge in the right direction? (Yes i am new to VB.NET) Thanks Re: Enumerator Class help Dave Kreskowiak8-Oct-07 6:43 Dave Kreskowiak 8-Oct-07 6:43  It's a bad idea to put all of your enums into a single class. They belong with the class(es) that's going to use them. That's where you building your own class library comes in. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 Re: Enumerator Class help GuyThiebaut8-Oct-07 8:31 GuyThiebaut 8-Oct-07 8:31  I agree with Dave. It is well worth reading up on OOP to get at least an idea of how classes etc work. It sounds like you are using a more procedural view point where macros, functions, constants etc are stored in a single place. I mention this because coming from procedural languages myself I have had to shift my viewpoint - which can feel like parking an oil tanker in a space barely the size of a small car. What I would suggest as a starter is to look at the wiki article on polymorphism - in fact here is a link Click Me. Guy You always pass failure on the way to success.

Last Visit: 31-Dec-99 18:00     Last Update: 8-Jun-24 15:04 Refresh ᐊ Prev1...2101210221032104210521062107210821092110 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.