Reputation: 0 Apprentice
- New Members
- Active Posts:
- 12 (0.02 per day)
- 30-November 11
- Profile Views:
- Last Active:
- Mar 19 2012 02:01 PM
- Dream Kudos:
Posts I've Made
Posted 5 Feb 2012its nothing to do with the data types. The problem is with the query caused by the quotation mark. Please post the full SQL query you've written.
try with an extra quotation mark. D''Souza
This is my query....
@mode int=0, @EmpCode varchar(10)='', @EmpName varchar(50)='', @Desig varchar(50)='', @DptId smallint=0, @EmpGrpId smallint=0, @PPNo varchar(12)='', @PPExp datetime='', @VisaExp datetime='', @LabExp datetime='', @Password varchar(10)='', @Basic int=0, @HRA int=0, @TA int=0, @Birth smalldatetime='', @Join smalldatetime='', @Addr1 varchar(50)='', @Addr2 varchar(50)='', @Addr3 varchar(50)='', @Addr4 varchar(50)='' ) AS if @mode=1 begin set dateformat dmy insert into employee (EmpCode,EmpName,Designation,DeptId,EmpGrpId,PPNo,PPExp,VisaExp,LabExp,Password,Basic,HRA,TA,Bdate,Jdate,Addr1,Addr2,Addr3,Addr4) values(@EmpCode,@EmpName,@Desig,@DptId,@EmpGrpId,@PPNo,convert(datetime,convert(varchar,@PPExp),103),convert(datetime,@VisaExp),convert(datetime,@LabExp),@Password,@Basic,@HRA,@TA,convert(datetime,@birth),convert(datetime,@join),@addr1,@addr2,@addr3,@addr4) end if @mode=2 begin delete employee where empcode=@empcode end if @mode=3 begin select employee.Empcode,employee.EmpName,employee.PPNo,employee.PPExp,employee.VisaExp,employee.LabExp,employee.Designation,department.DeptName,EmpGroup.EmpGrpName,employee.password,employee.basic,employee.hra,employee.ta,employee.bdate,employee.jdate,employee.addr1,employee.addr2,employee.addr3,employee.addr4 from employee,Department,EmpGroup where Employee.deptId=department.deptId and employee.empgrpid=empgroup.empgrpid order by employee.EmpName end if @mode=4 begin set dateformat dmy update employee set EmpName=@EmpName,PPNo=@PPNo,PPExp=convert(datetime,convert(varchar(10),@PPExp,103)),VisaExp=convert(datetime,@VisaExp,103),LabExp=convert(datetime,@LabExp,103),Designation=@Desig,DeptId=@DptId,EmpGrpId=@EmpGrpId,Password=@Password,Basic=@Basic,HRA=@HRA,TA=@TA,Bdate=convert(datetime,@birth,103),Jdate=convert(datetime,@join,103),Addr1=@addr1,Addr2=@addr2,Addr3=@addr3,Addr4=@addr4 where empcode=@empcode end
Please go through it help me .... thanks
Posted 31 Jan 2012I know what's happening. It's because you've got the two projects in separate solutions, so the Inventory project closes when you open another one. What you need to do is copy one of your projects to the other project's solution and it should work. Also, by doing that you can access both projects from the solution explorer.
I could rectify the problem, Programme is quitting because there is a User defined control, when i create an object of a form in the user defined control, the programme is quitting when i call a form from my application
Now i cant make any event(I cant call Save, add, Edit, search, Delete buttons) for my user defined control. Any one can help me.
Posted 26 Jan 2012Any one can support in the above problem?
Posted 24 Jan 2012Can you explain it more?
What I understand is: "When you open a project in VS, it closes automatically but other projects continue to be open? You mean there is one specific project that resists to open and everytime it closes it self when you try to run it? Or you are talking about when you run it?
I am developing two Projects first is Accounting and other one is Inventory. If i open Inventory from Visual Studio, through File -> open -> Project, it is opening but If I open Accounting Project it closes while loading.
Posted 24 Jan 2012
- Member Title:
- New D.I.C Head
- Age Unknown
- Birthday Unknown
- Click here to e-mail me