Hey Eric, I thankss alot. It works perfectly.....Thanks for the hessle all the way. It is rather fun to try out !! tc and hav a nice day see ya around =) best regards amygal

yeah, I'm trying to call it from VB.NET is there any difference?

hie again =) yea i had added the stored procedure with the parameters above, but i cant get u bout to supply them when i call the procedure any example?? *_* amygal

hey EricDV It's really cool, =) juz a simple line of code. very bravo of u Everything working fine now exept there is still some small msg box pop up. A msgbox pop up with " Procedure or function 'InsertStaffAccount expect parameter '@staffName' which was not supplied. Is that a bug? how to make it dissapear as evryhign seemed to work fine now thanks again very kind and helpful of u =) best regards amygal

Hie EricDV Thanks alot for the help. It really workos. The auto-generated staffID does populate the Login Table. But there is one weird thing, why the paswword seemed to have extra space infront of the StaffID? Eg. *****10011 * represent the space why is it so? how to eliminate the extra space in front of the password?? thanks best regard amygal

yes, the password is one of the field in staffLogin table. My intention is Once a new Staff Record is added, StaffID will be autogenerated and saved the new record in Staff Table. In the same time, I wish the StaffLogin Table will be populated with the new StaffID as autogenerated in Staff Table and together with the password. Of course, since it is a new staff record, the Stafflogin table does not have the value of staffID and the password yet, it is added as a new record only in the same time as New Staff Record is added in the Staff Account. How is this possible? The value of the password for the initial add record purpose is similar as the staffID which is auto-generated in the Staff Table, then i will add code to allow user to change the vaue of password on their first login.How is this possible? thanks again best regard amy

Hi Rainer, thanks for the reply but it seemed having some prob: I had tried the stored procedure u had specify, but is generate error says that no null value can be inserted into the Login Table. Alright, I had set the StaffID in child table of Login AS Not Allow Null, I guess tis is the prob, but yet if i changed the setting to Set as Allow Null, the result the same- IT does not insert the auto-generated StaffID in (Staff Record)Parent Record to the (Login)child table. Here is my Procedure Create PROCEDURE InsertStaffAccount @StaffName varchar(20), @Gender char(10), @Address varchar(50), @Position varchar(20), @Identity int OUT AS SET nocount On INSERT INTO StaffAccount(StaffName,Gender,Address,Position) VALUES (@StaffName,@Gender,@Address,@Position) INSERT INTO StaffLogin(StaffID,Password) VALUES (@@Identity,@Identity) SET @Identity = SCOPE_IDENTITY() go any Idea??

Hie, I tried out samples in MSDN regarding how to enable autoincrement of an ID through Stored Procedure, it works. Now I'm having doubts where I wanted to insert the ID which is auto-incremented in parent table when a new record is added, to be inserted in the child table. I just make an illustration for example, StaffAccount Table (Parent Table)having StaffID as primary key, it is auto-incremented using stored procedures-succesfully completed, now the StaffID is the foreign key in Login Table(Child Table), I want the StaffID to be added automaticallly in child table once a new record has been inserted in parent table. How is this possible? Thanks in advance for helping in reading this. =) best regards amygal

Hie, I tried out samples in MSDN regarding how to enable autoincrement of an ID through Stored Procedure, it works. Now I'm having doubts where I wanted to insert the ID which is auto-incremented in parent table when a new record is added, to be inserted in the child table. I just make an illustration for example, StaffAccount Table (Parent Table)having StaffID as primary key, it is auto-incremented using stored procedures-succesfully completed, now the StaffID is the foreign key in Login Table(Child Table), I want the StaffID to be added automaticallly in child table once a new record has been inserted in parent table. How is this possible? Thanks in advance for helping in reading this. =) best regards amygal

alright, as far as i known, there are infrared class library for .NET Compact Framework, but for normal .NET framework, I dun think it has, am I rite? Actually I'm trying to design two application between Mobile Device and Desktop. I wish to use the Infrared to send data from one another between desktop and mobile device. When I call the Infrared class as reference in mobile application, there is no prob, but when i move to normal desktop/pc application, i did the same way to call the infrared reference but i add the reference from the recent reference tab, i guess tat must be the prob occur rite? basically how to call the infrared in normal windows application? Is it the same as in smart device application? thanks for ur reply, =)

wat's the difference of mixing or seperating them both? how to seperate them. I'm a really beginer student that just started learning bout .NET programming language, may you explain to me thankss =)

yes, the version is correct

thanks for ur reply but i had add most of the reference Microsoft.Windows.CE.Froms system system.configuration system..data system.deployment system.drawing system.net.IrDA system.windows.forms system.xml but still the error appering why? regard amygal

I had add a few references such as system, system.net.Irda, system.drawing.....a few more Is that wat u meant bout the reference?

Error 1 Reference required to assembly 'System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=969db8053d3322ac, Retargetable=Yes' containing the type 'System.Net.Sockets.Socket'. Add one to your project. C:\Documents and Settings\@myg@l\My Documents\Visual Studio 2005\Projects\Merchant\Merchant\Form2.vb 11 21 Merchant Wat does this mean? regards amygal

Error 1 Reference required to assembly 'System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=969db8053d3322ac, Retargetable=Yes' containing the type 'System.Net.Sockets.Socket'. Add one to your project. C:\Documents and Settings\@myg@l\My Documents\Visual Studio 2005\Projects\Merchant\Merchant\Form2.vb 11 21 Merchant Wat does this mean regards amygal