Asgill
Feb 16th, 2004, 02:37 AM
hi...pls correct me if im wrong...cos im still new so i mite b wrong here...dataforms ae use to view and modify data right.
but can i use it to add/delete data into/from the database?..
Arvinder Gill
Magiaus
Feb 16th, 2004, 01:14 PM
I'm not sure what you mean by dataforms but you answered your own question
MasterBlaster
Feb 16th, 2004, 04:55 PM
If you mean the DataForm Wiz that comes with VS.net then yes you can create forms that add/modify/delete data. Click the Options that allow the user to A/M/D data on (i think) the second to last page of the wizzard.
Asgill
Feb 17th, 2004, 07:25 AM
aight!....got it thx man oh yeah btw can someone help me out with this code.
myCommand = new SqlCommand("INSERT INTO Patient(Acct ID, Name, Age, Height, Weight, Address, IcNo, HomeNo, HpNo, EName, EPhoneNo, ERelation, Date, Status, Remarks) VALUES('"+@txtAcctId.Text+"','"+@txtName.Text+"','"+@txtAge.Text+"','"+@txtHeight.Text+"','"+@txtWeight.Text+"','"+@txtAdd.Text="','"+@txtICNO.Text+"','"+@txtHomeNo.Text+"','"+@txtHPNO.Text+"','"+@txtEName.Text+"','"+@txtEPhoneNo.Text+"','"+@txtERelation.Text+"','"+@dTimeDate.Text+"','"+@txtStatus.Text+"','"+@txtRemarks.Text+"')",myConnection);
i compile the .cs file and get this error
->
D:\ASGill\D E G R E E\D. Final Year Project (7)\SOFTWARE\C.I.System\CLINICINFORMATIONSYSTEM\AddPatient.cs(534): The left-hand side of an assignment must be a variable, property or indexer <-
what does it mean?...
Magiaus
Feb 17th, 2004, 09:18 PM
SqlCommand myCommand will fix that error
and i hear \" is cool
have you ever programmed before?
Asgill
Feb 18th, 2004, 05:11 AM
well magius..this is (i think) my third time programming, im a law student (over here in Malaysia...we are "FORCED" to go tru computer subjects to keep ourself IT literate..sighh). im currently doin my assigment for DBMS subject which requires me to create an app not so simple yet not so sophisticated which comm. with the Database...u know Inserting and Deleting and so on...but i gotta give this site a heads up!...it has helped it alot...unlike another web site like this...the guys over there always tell me to read the .Net SDK Doc....whoa....reality check guys...dont u think going tru law books a whole lot of reading and now u want me to read the whole SDK stuff..puhleesseee!.. :(
anyways sorry if i sounded kinda harsh about computers and IT..but i just had to vent out my frustration...
oh yeah...magius...thx for the answer and for bein so nice
when i become a lawyer which is soon...finishin off next month...ill handle ur legal issues for free...(that is if ur in Malaysia..lol)...i know i know...LAWYERS!!!...seesh!
till my next question...chow and take care