how to write select query in the below code in sql.

Question

1.00/5 (2 votes)

See more:

C#

Sqlstr = "select sum(sal_bonus) as bonusamt from salary_master where sal_deleted = 0 "+
         " and year(sal_bonusdate) = " + lngPreviousYear + " and comp_id = " + strCompanyid +
        " and emp_code = '" + Txt_Employee.Text+ "'" ;
       if (vpcn.gbHalfSalary == true)
       {
           Sqlstr += " and sal_type = '" + vpcn.cSalary_2Half + "' ";
       }
       strBonus = cfs.get_data(Sqlstr);

Posted 27-Aug-14 1:53am

Member 10928697

Updated 27-Aug-14 2:19am

Gihan Liyanage

v2

Add a Solution

Comments

[no name] 27-Aug-14 7:58am

First thing to do is to stop repostng this over and over. Second thing is your SQL query is already SQL so your code dump does not make sense anyway. We can't read your mind to know what it is that you are trying to do.

Ashi0891 27-Aug-14 12:57pm

Sqlstr = "select sum(sal_bonus) as bonusamt from salary_master where sal_deleted = 0 "+
" and year(sal_bonusdate) = " + lngPreviousYear + " and comp_id = " + strCompanyid +
" and emp_code = '" + Txt_Employee.Text+ "'" ;

Is this code statement giving you any error?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ClimerChinna · Answer 1 · 2014-08-27T01:58:00

Solution 1

this query is correct only

C#

Sqlstr = "select sum(sal_bonus) as bonusamt from salary_master where sal_deleted = 0 "+
         " and year(sal_bonusdate) = " + lngPreviousYear + " and comp_id = " + strCompanyid +
        " and emp_code = '" + Txt_Employee.Text+ "'" ;
       if (vpcn.gbHalfSalary == true)
       {
           Sqlstr += " and sal_type = '" + vpcn.cSalary_2Half + "' ";
       }
       strBonus = cfs.get_data(Sqlstr);

why r u reposting your question
what do you want here tell us clearly

Posted 27-Aug-14 1:58am

ClimerChinna

Updated 27-Aug-14 1:59am

v2

Comments

Member 10928697 27-Aug-14 8:04am

in the above code is windows form..convert the above code in sql query formet sir.

ClimerChinna 27-Aug-14 8:09am

what is vpcn, is it a table, if so what are the fields in vpcn table and alary_master table send them so that i can write the query

Member 10928697 27-Aug-14 8:12am

k sir
no need vpcn sir.
salary_marter table is
------------------------

sal_id int Unchecked
comp_id int Checked
emp_code nvarchar(50) Checked
sal_year int Checked
sal_month int Checked
sal_paydate datetime Checked
sal_type nvarchar(20) Checked
sal_salary decimal(18, 2) Checked
sal_comp_cpf decimal(18, 2) Checked
sal_emp_cpf decimal(18, 2) Checked
sal_earn_additional decimal(18, 2) Checked
sal_comp_cpf_additional decimal(18, 2) Checked
sal_emp_cpf_additional decimal(18, 2) Checked
sal_total_income decimal(18, 2) Checked
sal_total_deductions decimal(18, 2) Checked
sal_netpay decimal(18, 2) Checked
sal_agency nvarchar(20) Checked
sal_fund decimal(18, 2) Checked
sal_status nvarchar(10) Checked
sal_approved bit Checked
sal_approved_by nvarchar(50) Checked
sal_approved_date datetime Checked
sal_canceled_by nvarchar(50) Checked
sal_canceled_date datetime Checked
sal_createdby nvarchar(50) Checked
sal_createddate datetime Checked
sal_updatedby nvarchar(50) Checked
sal_updateddate datetime Checked
sal_deleted bit Checked
sal_sdl decimal(18, 2) Checked
sal_fwl decimal(18, 2) Checked
sal_bonus decimal(18, 2) Checked
sal_bonusdate datetime Checked
sal_bonus_comp_cpf decimal(18, 2) Checked
sal_bonus_emp_cpf decimal(18, 2) Checked
sal_exported bit Checked
sal_exported_date datetime Checked
sal_1half_pay decimal(18, 2) Checked
sal_payleave decimal(18, 2) Checked
sal_remarks nvarchar(250) Checked
sal_isemail_sent bit Checked
dept_code nvarchar(50) Checked
sal_paymode nvarchar(20) Checked
sal_usedby nvarchar(200) Checked
sal_project1 nvarchar(30) Checked
sal_project1Time decimal(18, 2) Checked
sal_project1Price decimal(18, 2) Checked
sal_project2 nvarchar(30) Checked
sal_project2Time decimal(18, 2) Checked
sal_project2Price decimal(18, 2) Checked
sal_project3 nvarchar(30) Checked
sal_project3Time decimal(18, 2) Checked
sal_project3Price decimal(18, 2) Checked
sal_project4 nvarchar(30) Checked
sal_project4Time decimal(18, 2) Checked
sal_project4Price decimal(18, 2) Checked
sal_project5 nvarchar(30) Checked
sal_project5Time decimal(18, 2) Checked
sal_project5Price decimal(18, 2) Checked
sal_1half_cpf decimal(18, 2) Checked
Unchecked

ClimerChinna 27-Aug-14 8:17am

the below is stored procedure for your code you need to pass parameters to it.

CREATE Procedure GetBonus
@lngPreviousyear int,
@CompanyId int,
@empCode varchar(50),
@SalType varchar(50),
@Bonussal money output
AS
BEGIN
select @Bonussal=sum(sal_bonus) from salary_master where sal_deleted=0 and year(sal_bonusdate)=@lngPreviousyear
and comp_id=@CompanyId and emp_code=@empCode and sal_type=@SalType
END

ClimerChinna 27-Aug-14 8:18am

below is select query
Sqlstr = "select sum(sal_bonus) as bonusamt from salary_master where sal_deleted = 0 "+
" and year(sal_bonusdate) = " + lngPreviousYear + " and comp_id = " + strCompanyid +
" and emp_code = '" + Txt_Employee.Text+ "' and sal_type = '" + vpcn.cSalary_2Half + "' ";

Gihan Liyanage 27-Aug-14 8:14am

Simply remove " + from the code from variables, But how can we edit query for if (vpcn.gbHalfSalary == true)
{
You may know what are they, But code project users cant think what is that???