Database

Erdinc276-Dec-10 4:50

6-Dec-10 4:50

i am not sure if u really meant that..here i sent cek_no value to my stored proc. like that..
cmd.Parameters.AddWithValue("cek_no", System.Data.SqlDbType.NVarChar).Value=table.Row[i][0].ToString();

vemedya.com

tasumisra6-Dec-10 5:13

tasumisra

6-Dec-10 5:13

Thanks for the answer i ment in my question was suppose u need to pass 5 parameters .. so we can wither pass them separately or is there any other way to pass them when i can pass as single argument.

vikas da

jschell6-Dec-10 11:57

jschell

6-Dec-10 11:57

Then you repeat the above 5 times.

Mycroft Holmes6-Dec-10 13:27

Mycroft Holmes

6-Dec-10 13:27

Create a command object (sql client)
add an array of sql parameters
add a valid connection string to the command object
execute the command (executescalar)

Will you please do some research, a simple Google query will do - this question has been answered 1000s of times before and there are many many examples on the net showing you how to do this.

Never underestimate the power of human stupidity
RAH

PIEBALDconsult6-Dec-10 14:43

PIEBALDconsult

6-Dec-10 14:43

No, it seems that he wants to pass a class or struct or something.

Mycroft Holmes6-Dec-10 15:19

Mycroft Holmes

6-Dec-10 15:19

PIEBALDconsult wrote:
pass a class or struct

How did you get that from the OP.

The the answer would still be the same with an explanation that you cannot pass objects unless they are as xml data type Dead | X|

Never underestimate the power of human stupidity
RAH

adding Group by result to each other

Jörgen Andersson6-Dec-10 20:13

Jörgen Andersson

6-Dec-10 20:13

Mycroft Holmes wrote:
How did you get that from the OP.

He's cheating, the mindreader function is to be released with SQL:2012.

"When did ignorance become a point of view" - Dilbert

Erdinc276-Dec-10 1:50

6-Dec-10 1:50

i have a table which was created in MsSql 2005 Express..
http://img441.imageshack.us/f/numaralar.jpg/[^]
i have numbers in 6 columns..i can group every column and count which number was selected how many times in columns...
but for example number 10 exist in column1 and column2 and column3 also..how i can add that count results that i found for every column seperately to each other to find the total of the number 10 selected ...

vemedya.com

Goutam Patra6-Dec-10 2:09

Goutam Patra

6-Dec-10 2:09

Are you looking for something like this

SELECT

CASE WHEN NUM1 = 10 THEN 1 ELSE 0 END + 
CASE WHEN NUM2 = 10 THEN 1 ELSE 0 END + 
CASE WHEN NUM3 = 10 THEN 1 ELSE 0 END +
CASE WHEN NUM4 = 10 THEN 1 ELSE 0 END +
CASE WHEN NUM5 = 10 THEN 1 ELSE 0 END +
CASE WHEN NUM6 = 10 THEN 1 ELSE 0 END
AS TOTAL

FROM MYTABLE

Erdinc276-Dec-10 2:27

6-Dec-10 2:27

thanks for reply friend..when i write that code

SELECT num1,count(*) FROM NumaraBilgileri
GROUP BY num1

i got that http://img827.imageshack.us/f/num1column.png/[^]
as u see i have 22 numbers there..it is just for column1 and i have 5 more columns.. i mean that after that Select executed i have number 10 here 4 times..and in column2 i have 5 times number 10 so total makes 9..and so on.. i want to get the all numbers total in that table from 1 to 49..how i can get it

vemedya.com

Goutam Patra6-Dec-10 2:38

Goutam Patra

6-Dec-10 2:38

Then try using UNION Query like

SELECT A.NUM, SUM(A.TOTAL) AS TOTAL FROM (
SELECT num1 AS NUM,count(*) AS TOTAL FROM NumaraBilgileri
GROUP BY num1
UNION ALL
SELECT num2 AS NUM,count(*) AS TOTAL  FROM NumaraBilgileri
GROUP BY num2
) AS A
GROUP BY A.NUM

You need to create union for all fields.

Erdinc276-Dec-10 2:55