Lowyat.NET: Latest topics by Scud_eSpade

[WTS] Coach handbag

Scud_eSpade — Wed, 13 Nov 2013 21:29:24 +0800

Item(s): original coach handbag from US store as per picture

Package includes: the handbag

Price: bought at USD398 - willing to sell at RM1000

Dealing method: COD

Location of seller: KL/bangi/semenyih

Contact method/details: PM

Age of item: 1 week

---

Item(s) conditions: new unsued

Reason for sale: Bought as souvenir. somehow someone dont like it

panda cloud

Scud_eSpade — Fri, 28 Aug 2009 22:24:00 +0800

Im using win xp. I just installed panda cloud and immediately it detects tons of virusses, ttrojan and worm in my lappy.. (no av before.. hehe) after reboot cant connect to internet. Cannot dial up. No setting to configure. Anybody how to fix this?

mangement trainee

Scud_eSpade — Mon, 22 Jun 2009 11:54:12 +0800

hi all,

Im a fresh graduated in E&E Engeneering. I hv noticed that a lot of job advertisement offer management trainee. From my understanding, a management trainee will be train in various department to gain experiences. So, these are my doubts about MT:

1) What are the usual career path for MT?
2) How long MT usually stay as MT before move to the higher level?
3) How suitable is it for engineering student like me to apply for MT?
4) In ur opinion, if I was offered both MT and engineers position, which one is better? why? (assume i like both job and the pay is same)

thanks

query ms access database after sending data

Scud_eSpade — Fri, 20 Feb 2009 10:12:56 +0800

Hi,

im not very good in vb. Im building an application for my fyp project. It use barcode scanner as an input device. I hv manage to build a database and connect the the serial port to my app.

for now i have to click a "search" button to query the database after i finished scanning the barcode... which i dont really want. My target is for it to automatically query the database after finished received the barcodes via rs232. Is there any way I can do it? Any example would be appreciated

cannot save to access database using vb2005

Scud_eSpade — Wed, 21 Jan 2009 22:44:37 +0800

Hi,
Im trying to built an application using vb and ms access database. I can successfully update and view the data but cannot add new data. I got this error when trying to save a data from my application to the ms access database:

CODE

System.Data.OleDb.OleDbException was unhandled
ErrorCode=-2147217900
Message="Syntax error in INSERT INTO statement."
Source="Microsoft JET Database Engine"
StackTrace:
at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
at System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
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 PSA.Form1.btnCommit_Click(Object sender, EventArgs e) in E:\Documents\4th year 2nd sem\FYP2\Visual Basic\Database\PSAx\PSAx\Form1.vb:line 110
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.Run(ApplicationContext context)
at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.OnRun()
at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoApplicationModel()
at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(String[] commandLine)
at PSA.My.MyApplication.Main(String[] Args) in 17d14f5c-a337-4978-8281-53493378c1071.vb:line 81
at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()

This is my full program code:

CODE

Imports System.Data
Public Class Form1
Dim inc As Integer
Dim MaxRows As Integer

Dim con As New OleDb.OleDbConnection
Dim ds As New DataSet
Dim da As OleDb.OleDbDataAdapter
Dim sql As String

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = C:\PSA.mdb"
con.Open()
sql = "SELECT * FROM tblX"
da = New OleDb.OleDbDataAdapter(sql, con)

da.Fill(ds, "AddressBook")
con.Close()

MaxRows = ds.Tables("AddressBook").Rows.Count
inc = -1

End Sub

Private Sub NavigateRecords()

txtBarcode.Text = ds.Tables("AddressBook").Rows(inc).Item(1)
txtProduct.Text = ds.Tables("AddressBook").Rows(inc).Item(2)

End Sub

Private Sub btnNext_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnNext.Click
If inc <> MaxRows - 1 Then
inc = inc + 1
NavigateRecords()
Else
MsgBox("No More Rows")
End If
End Sub

Private Sub btnPrev_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPrev.Click
If inc > 0 Then
inc = inc - 1
NavigateRecords()
ElseIf inc = -1 Then
MsgBox("No Records Yet")
ElseIf inc = 0 Then
MsgBox("First Record")
End If
End Sub

Private Sub btnLast_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLast.Click
If inc <> MaxRows - 1 Then
inc = MaxRows - 1
NavigateRecords()
End If
End Sub

Private Sub btnFirst_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnFirst.Click
If inc <> 0 Then
inc = 0
NavigateRecords()
End If
End Sub

Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click
Dim cb As New OleDb.OleDbCommandBuilder(da)

ds.Tables("AddressBook").Rows(inc).Item(1) = txtBarcode.Text
ds.Tables("AddressBook").Rows(inc).Item(2) = txtProduct.Text

da.Update(ds, "AddressBook")

MsgBox("Data updated")
End Sub

Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
btnCommit.Enabled = True
btnAdd.Enabled = False
btnUpdate.Enabled = False
btnDelete.Enabled = False

txtBarcode.Clear()
txtProduct.Clear()
End Sub

Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click
btnCommit.Enabled = False
btnAdd.Enabled = True
btnUpdate.Enabled = True
btnDelete.Enabled = True

inc = 0
NavigateRecords()
End Sub

Private Sub btnCommit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCommit.Click
If inc <> -1 Then

Dim cb As New OleDb.OleDbCommandBuilder(da)
Dim dsNewRow As DataRow

dsNewRow = ds.Tables("AddressBook").NewRow()

dsNewRow.Item("Barcode") = txtBarcode.Text
dsNewRow.Item("Product") = txtProduct.Text

ds.Tables("AddressBook").Rows.Add(dsNewRow)

da.Update(ds, "AddressBook") <<<<<<<<<<<<<<<<<<<<<<<-----------------COMPILER STOP HERE

MsgBox("New Record added to the Database")

btnCommit.Enabled = False
btnAdd.Enabled = True
btnUpdate.Enabled = True
btnDelete.Enabled = True

End If
End Sub
End Class

I am newbie to vb and have tried to google but i couldnt find any answer. Any sifus can help me?

ntfsmount

Scud_eSpade — Fri, 16 Dec 2005 00:09:45 +0800

QUOTE

What ntfsmount can do?
* Resize files. (the kernel driver can resize only small files, and extension of large ones is comeing along soon).
* Create files. (50% chance for it to work at the moment. Up to 10 files in a newly created directory)
* Create directories. (50% chance for it to work too)
* Remove files/directories (works most of the time)

write to ntfs

just want to ask if anybody had a success in using this tool..
i just afraid of losing my precious ntfs.. hehe

Format my hd

Scud_eSpade — Mon, 04 Jul 2005 18:18:00 +0800

so.. i get ta prob here..
i actually format all my hd to ext3..
but then i change my mind and want to install windows as my other os. but the problem is the win xp boot cd unable to detect my hd.. ive read in other forum says this is due win cant read linux partition.

so my questition is how can i format my hd in linux to fat 32 or ntfs?
i use fc4.. can i use resque disk? how?

Disk management tool

Scud_eSpade — Mon, 27 Jun 2005 19:44:30 +0800

anyone know any disk management tool that i can use to keep my hdd healthy and also check problem (like disk defragmenter and scandisk)

Paragon NTFS for Linux

Scud_eSpade — Thu, 23 Jun 2005 00:57:10 +0800

Paragon NTFS for Linux

this is a utility to mount ntfs in linux.. can write and read also.
i just sceptical.. is this tool works? anyone hv tried it.. me scare to try becoz later if wrong hv to format my hd .
or r there other tool u used that done the same thing?

help with my ext hd

Scud_eSpade — Sun, 19 Jun 2005 18:38:37 +0800

i hv pata fat 32 usb hd. im currently using fc2..
is there any distro that can automatically mount the drive?
i hv modified the fc2 kernel so it can automatically mount my win partion.. but i cant make it work for my usb hd.. anyone know how?
any help is a welcome.. btw im a noob