Lowyat.NET: Latest topics by jaclyn

Infopro - Have anybody heard of infopro

jaclyn — Mon, 01 Jun 2009 17:01:47 +0800

Hi guys,
Just wondering have anyone of you heard of INFOPRO before?
How's the company? The working environment? BEnefits n such info...
please do share...

Cannot connect to BT

jaclyn — Thu, 04 Jan 2007 17:51:25 +0800

Hello all,

I'm just wondering that is it true that Malaysia had filter all P2P application? Coz I was trying to download using Bittorent but not one is running...Or is it anything wrong due to the earthquake and the connection is not fully recovered yet?

BTW,I'm sharing streamyx together along with my housemate, there's approx. 5 of us using one account...

Thank you for answering my question.

Help! SQL Problem

jaclyn — Mon, 20 Nov 2006 20:34:11 +0800

QUOTE

Private Sub btnFree_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnFree.Click

myConn = New MySqlConnection("server=localhost; user id=root; password=jaclyn; database=sw_maintenance")
myConn.Open()
myCommand1.Connection = myConn

'MySql command
myCommand1.CommandText = "Update penyelenggara set status=0 where NoPekerja = '" & txtNoPekerja.Text & "'"
myConn.Close()
End Sub
End Class

Hi everyone..anyone can help me on this? This is part of a codings vb.net/asp.net and the database I'm using is MySQL. THere's no syntax error on it but it still cannot execute my command..It does no changes to my tabe. I tried chaging fields but to no avail..still nothing happen. txtNoPekerja.Text definitely can be read! No wrong on that..Is it a connection problem? Coz others are working fine~

Or is there anybody can tell me the sql command of setting a field to its default value? The default value for status is actually 0.

Thanks a lot!!

Problem with Crystal Report in VS 2005

jaclyn — Thu, 09 Nov 2006 15:18:08 +0800

This error which were found concerning Crystal Report!!

QUOTE

Error 2 Could not load file or assembly 'CrystalDecisions.CrystalReports.Engine, Version=9.1.5000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified. c:\inetpub\wwwroot\SwMaintenance\Web.config 11

This the codes.

QUOTE

THis is another error :

QUOTE

Warning 4 The element 'compilation' has invalid child element 'compilers'. List of possible elements expected: 'assemblies, buildProviders, codeSubDirectories, expressionBuilders'. c:\inetpub\wwwroot\SwMaintenance\Web.config 16 5 http://localhost/SwMaintenance/

The codes for this error.

QUOTE

Pls help, anyone.. THanks a lot!!

Send email using vb.net

jaclyn — Thu, 02 Nov 2006 13:00:32 +0800

QUOTE

Private Sub txtHantar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txtHantar.Click

Dim Mail As New MailMessage

Mail.From = txtDaripada.Text
Mail.To = txtKepada.Text
Mail.Cc = txtCC.Text
Mail.Bcc = txtBCC.Text
Mail.Subject = txtTajuk.Text
Mail.Body = txtIsiKandungan.Text
Mail.From = txtDaripada.Text

'Mail.From = "fardzly@spkt.com"
SmtpMail.SmtpServer = "localhost"
SmtpMail.Send(Mail)

lblDaripada.Text = "Emel Telah Dihantar"

End Sub
End Class

Hey,anyone pls help..I've used this code but I still can't send my email out! Anything wrong with the codes? Or is there anything I need to set up with my server? Pls enlighten me!!

Problems with Date!

jaclyn — Wed, 04 Oct 2006 13:34:04 +0800

I want the system to detect today's date n compare it with date of 3days in advance!

Eg. Today is 4 Oct 2006 n I need my website to shows all assignments due before 7 Oct 2006 as a reminder to me!

What's the sql command for this..I'm using MySQL! Thanks a lot!!

Insert values into database

jaclyn — Mon, 02 Oct 2006 11:03:43 +0800

I've problem inserting this particular one value. I'm getting this value as below which is "test".

QUOTE

test = myReader("NoPekerja")
test = "<script language='javascript'> window.alert (" & test & ") </SCRIPT>"
Page.RegisterStartupScript("RALAT", test)

Then, I would like to insert that "test" value along with other value that r input by user. This is my sql command..pls do tell me what do i have to add into the command line so that "test" can be added together into the database. Or do i do an update of that particular row?

QUOTE

myCommand.CommandText = "Insert Into Aduan(NoKontrakAduan,KodAduan,ProgramAduan,BarisAduan,PeneranganAduan,RujukanAduan,JangkaSiap,TarikhAduan,StatusAduan,BahasaPengaturcaraan,PangkalanData) " & _ "Values (?NoKontrakAduan,?KodAduan,?ProgramAduan,?BarisAduan,?PeneranganAduan,?RujukanAduan,?JangkaSiap,?TarikhAduan,?StatusAduan,?BahasaPengaturcaraan,?PangkalanData)"

I've tried putting the "test" value into a text box n it works. But,when I use the same way to insert into the database..it's not working.

Thanks for helping!! Appreciate it very much!!

How to program this code?

jaclyn — Wed, 27 Sep 2006 21:37:48 +0800

Ok,let's say that myReader had read the NoPekerja as = "123"
how can i display it with java script? coz I've tried putting that "test" but got error! It's like test can't even take the variable which was being read. Below is part of my codes..

test = myReader("NoPekerja")
test = "<script language='javascript'> window.alert(test)</SCRIPT>"
Page.RegisterStartupScript("RALAT", test)

Thanks for helping!!!

Newbie at VS.net

jaclyn — Thu, 07 Sep 2006 17:36:21 +0800

I'm just wondering..if my localhost is working..shouldn't it if I try to run a .net project..it actually can run despite the database is not working..I mean at least I get to see the interface..Or it doens't work like that for .net?

If I try running the project from VS.net(tho there's still bug in it..mainly the database problem) I get this page below

So,anyone out there..Pls help me!! Thank u in advance!

Error on MySQL

jaclyn — Thu, 07 Sep 2006 17:19:30 +0800

Ok,I'm currently continuing a project by other people where that project is done with ASP.net as my interface n VB.net as my codings. But,I guess I'm having a major problem here as I can't connect my database which is MySQL to Visual Studio here! Whenever I clicked on any of my table in MySQL..it'll say "query cannot be executed", "Decription : can't open file : filename.ibd(errno :1), " A MySQL error was encoutered. THe message is : cannot fetch information."
Above all, I can't edit my table n I can't even see it!