Asp.net Gridview with sqlserver query

Question

0.00/5 (No votes)

See more:

Hello sir,
In my project an employee table is there.having a gridview column of that table i.e. Grade,values are A,B,C,D.And also having a column age .I want to delete the records of grade-A,B,C whose age>58 And of grade-D whose age>60.

Plz sir send the solution. ~~Urgent~~.

Posted 5-Dec-12 22:35pm

Nalini Ranjan Sahoo

Updated 5-Dec-12 23:00pm

Prasad_Kulkarni

v3

Add a Solution

6 solutions

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)

ashp.net · Answer 1 · 2012-12-05T23:28:00

Solution 5

create a stored pro

create proc proce_name
as begin
Delete A,B,C from table_name where age>58
Delete D from table_name where age>60
end

execute stored

Posted 5-Dec-12 23:28pm

ashp.net

ashokmmrk · Answer 2 · 2012-12-05T23:33:00

Solution 6

Hi,

Try this

delete from grade where grade in('A','B','C') and age>58 or grade='d' and age>60

Posted 5-Dec-12 23:33pm

ashokmmrk

MohsenSaleh · Answer 3 · 2012-12-05T22:54:00

Solution 1

hi
you can use sqlCommand from ado.net or newer technology, and delete sql query to remove info from table.

Posted 5-Dec-12 22:54pm

MohsenSaleh

Comments

Nalini Ranjan Sahoo 6-Dec-12 4:58am

Sir What is sqlCommand from ado.net?Plz Clarify it.

MohsenSaleh 6-Dec-12 5:15am

//connection string for connecting to database
SqlConnection cn=new Connection(@"Data Source=PHANNY-PC\PHANNY; Initial Catalog=db_stuRegisterPay; Integrated Security=SSPI");
cn.Open();
//SqlCommand for exacut Command on DB

SqlCommand com = new SqlCommand();
com.Connection = cn;
com.CommandText = "delete from employee where Grade in ('A','B','C') and age>58";
com.ExecuteNonQuery();
MessageBox.Show("Saving is done);

Deenuji · Answer 4 · 2012-12-05T23:00:00

cn.ConnectionString = @"Data Source=PHANNY-PC\PHANNY; Initial Catalog=db_stuRegisterPay; Integrated Security=SSPI";
            cn.Open();
SqlCommand com = new SqlCommand();
            com.Connection = cn;
            com.CommandType = CommandType.Text;
          
            com.CommandText = "Delete A,B,C where age>58 and age>60";
com.ExecuteNonQuery();
MessageBox.Show("Saving is done

!");

Devang Vaja · Answer 5 · 2012-12-05T23:04:00

Solution 3

delete from employee where Grade in ('A','B','C') and age>58

then second query

delete from employee where Grade='D' and age>60

May this will Help you nalini ji

hApPy cOdInG:)

Posted 5-Dec-12 23:04pm

Devang Vaja

Patel Shailendra · Answer 6 · 2012-12-05T23:26:00

Solution 4

delete from employee where Grade in ('A','B','c') and age >58
union
delete from employee where grade =D and age >60

This is the query what u required implement as you wise.

Posted 5-Dec-12 23:26pm

Patel Shailendra

Updated 5-Dec-12 23:42pm

v2