count command in sql

pooja8389

how to use the count command?and how can store the result of count command in a veriable of integer type????

Sep 14 '10 #1

Subscribe Post Reply

2393

Frinavale

9,735

Expert Mod 8TB

Please check out this overview of how to use the Sql Count Function.

-Frinny

Sep 14 '10 #2

pooja8389

sir i want to store the result in a integer type variable
like

Expand|Select|Wrap|Line Numbers

 <%@ Page Language="VB" %>

<%@ Import Namespace="System.Data" %>

<%@ Import Namespace="System.Data.SqlClient" %>

<%@ Import Namespace="System.Web.Configuration" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">
 
    Private Sub Page_Load()

        lblMovieCount.Text = GetMovieCount().ToString()

    End Sub
 
    Private Function GetMovieCount() As Integer

        Dim result As Integer = 0

        Dim connectionString As String = WebConfigurationManager.ConnectionStrings

("Movies").ConnectionString

        Dim con As New SqlConnection(connectionString)

        Dim cmd As New SqlCommand("GetMovieCount", con)

        cmd.CommandType = CommandType.StoredProcedure

        cmd.Parameters.Add("@ReturnVal", SqlDbType.Int).Direction = ParameterDirection

.ReturnValue

        Using con

            con.Open()

            cmd.ExecuteNonQuery()

            result = CType(cmd.Parameters("@ReturnVal").Value, Integer)

        End Using

        Return result

    End Function

</script>

<html xmlns="http://www.w3.org/1999/xhtml" >

<head id="Head1" runat="server">

    <title>Show Movie Count</title>

</head>

<body>

    <form id="form1" runat="server">

    <div>
 
    There are

    <asp:Label

        id="lblMovieCount"

        Runat="server" />

    movies in the database.
 
    </div>

    </form>

</body>

</html>

but this code is in VB.what is the code in C# please tell me.

Sep 15 '10 #3

Frinavale

9,735

Expert Mod 8TB

VB.NET and C# my have different syntax but they both call the same library (the .NET Framework...) to accomplish the same thing.

Please attempt to read through the code above to understand the logic. Once you understand the logic then you should have no problem implementing the same thing in C#.

If you get stuck, ask and I'll help you through whatever you don't understand.

-Frinny

P.S.
The CType function is simply casting the value returned into an Integer.
It's the same thing as this in C#:

Expand|Select|Wrap|Line Numbers

result = (Integer)cmd.Parameters("@ReturnVal").Value;

Sep 15 '10 #4

pooja8389

thanku so much sir..
actually i had problem in this"(result = (Integer)cmd.Parameters("@ReturnVal").Value;)" line which u sortout..

Sep 16 '10 #5

by: brendonlam | last post by:

Hi there, Hoping someone could advise me here pls; I'm creating a C# class that implements a telnet client socket allowing a VB . NET application to communicate with telnet servers. After...

.NET Framework

Command Line compiling API and MFC programs

by: Dr. Laurence Leff | last post by:

How does not compile a Windows API and a Windows MFC program from the command line with Visual.net. (I can do the former, at least, with Visual Studio by creating a "Win32 Project.") However, I...

C / C++

How to parse a string like C program parse the command line string?

by: linzhenhua1205 | last post by:

I want to parse a string like C program parse the command line into argc & argv. I hope don't use the array the allocate a fix memory first, and don't use the memory allocate function like malloc....

C / C++

Wrong Count(*) on an objCommand.ExecuteScalar but it is correct on "SQL Entreprise Manager" or "SQL Query Analyser"

by: Julio Allegue | last post by:

I am getting the wrong Count(*) on vb.net using the ExecuteScalar . It returns all the rows. It doesn't seem to look at the WHERE clause. At the same time, I am getting the correct count on "SQL...

Visual Basic .NET

Command Line Interface (CLI): your recommendations

by: Roman Mashak | last post by:

Hello, All! I'm implementing simple CLI (flat model, no tree-style menu etc.). Command line looks like this: <command> <param1> <param2> ... <paramN> (where N=1..4) And idea is pretty simple: ...

C / C++

Iterating command switches from a data file - have a working solutionbut it seems inefficient

by: News | last post by:

Hi everyone, My goal is to pull command switches/options from a file and then assign the values to select variables which would eventually be included in a class object. The data file looks...

Python

Update command OledbDataAdapter problem

by: explode | last post by:

I made nova oledbdataadapter select update insert and delete command and connection veza. dataset is Studenti1data, I made it by the new data source wizard,and made datagridview and bindingsource...

Visual Basic .NET

already an open DataReader associated with this Command which must be closed first

by: Bart | last post by:

Hi, i get the error: "There is already an open DataReader associated with this Command which must be closed first" Thanks Bart ----------------------------------------- Imports...

ASP.NET

question on command line code

by: gdarian216 | last post by:

okay I had a code that asked user to input a file name and instead i changed it to take the input from the command line. I now want to output results of some functions to an output file. I have...

C / C++

count(*)

by: deeas | last post by:

hi please how i can read the result of : select count(*) command "SELECT count(*) as FROM devices"

.NET Framework

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

count command in sql

Similar topics