how to count the fetched rows by sqldatasource

Question

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
    Dim LoginChecker As New SqlDataSource()
    LoginChecker.ConnectionString = ConfigurationManager.ConnectionStrings("A1ConnectionString1").ToString()
    LoginChecker.SelectCommandType = SqlDataSourceCommandType.Text
    LoginChecker.SelectCommand = "SELECT username FROM A1login WHERE username=@username AND password=@password"
    LoginChecker.SelectParameters.Add("username", username.Text)
    LoginChecker.SelectParameters.Add("password", password.Text)
    Dim rowsAffected As Integer = 0
    Try
        rowsAffected = LoginChecker.<what i have to write here>
    Catch ex As Exception
        'Server.Transfer("LoginSucessful.aspx")
    Finally
        LoginChecker = Nothing
    End Try
    username.Text = rowsAffected
    ' If rowsAffected = 1 Then
    'Server.Transfer("A1success.aspx")
    '   Else
    'Server.Transfer("A1failure.aspx")
    '  End If

End Sub

this is the code for login.aspx.vb
it checks the username and password in the database and redirecrs to respective page on the basis of rows returned. i'm having problem in finding a right function in the sqldatareader namespace so that it counts the number of rows affected. Can anybody tell me the function I should use there? Thanks in advance.

score 3 · Answer 1 · answered Jul 08 '18 at 02:54

Use the Selected event of the SqlDataSource Control. The event is raised after the Select operation is complete.

protected void SqlDataSource1_Selected(object sender, SqlDataSourceStatusEventArgs e)
{
    lblRecordCount.Text = "Record Count: " + e.AffectedRows.ToString();
}

Samiey Mehdi · Answer 2 · 2013-08-24T05:07:52.090

1

protected void Button1_Click(object sender, EventArgs e)
{
    DataView d =(DataView) SqlDataSource1.Select(DataSourceSelectArguments.Empty);
    Response.Write(d.Count);
}

edited Aug 24 '13 at 05:07

answered Aug 01 '13 at 02:46

Samiey Mehdi

9,184
18
49
63

score 0 · Answer 3 · answered Aug 24 '13 at 08:29

0

SELECT Count(*) FROM A1login WHERE username=@username AND password=@password"

This Code return Count value

answered Aug 24 '13 at 08:29

senthilkumar2185

2,536
3
22
36

score 0 · Answer 4 · answered Nov 07 '10 at 18:10

0

Select will return an IEnumerable. You you can ToList().Count on this.

answered Nov 07 '10 at 18:10

Breandán

1,855
22
34

thanks . but, can u plz elaborate what you are saying . correct me if i'm wrong -------- objective is to count the number of IEnumerables so to do that how to code .. is it ToList(LoginChecker).Count – user481831 Nov 07 '10 at 18:24

score 0 · Answer 5 · answered Nov 07 '10 at 18:32

0

The SQLDataReader doesn't have a row count property the easiest way to get the count would be to do this...

int rowCount = 0;
if (dr.HasRows)  
{  
    while (dr.Read())  
        {  
            rowCount++;
            dgResults.DataSource = dr;  
            dgResults.DataBind();  
            dgResults.Visible = true;  
        }  

lblMsg.Text = rowCount.ToString();
dr.Close();

answered Nov 07 '10 at 18:32

Andrew Collins

2,541
3
17
16

no man there is an error , there is nothing like HasRows can u plz verify and tell me . shall i need to include any other specific namespace . – user481831 Nov 07 '10 at 18:49

score 0 · Answer 6 · edited Nov 25 '13 at 05:01

0

You should read this page

 Namespace:  System.Data 
 Assembly:  System.Data (in System.Data.dll)

edited Nov 25 '13 at 05:01

senthilkumar2185

2,536
3
22
36

answered Nov 12 '10 at 06:08

Andrew Collins

2,541
3
17
16

score 0 · Answer 7 · edited Oct 30 '13 at 22:27

0

To fetch your rows, declare sqlcommand and sqlconnection:

Dim cmd as sqlcommand
Dim con as new sqlconnection("Ur connection string")
cmd.connection=con
cmd.commandtext="SELECT count(username) FROM A1login WHERE username=@username AND password=@password"
Dim rowsAffected As Integer = cmd.executescalar()

In rowsaffected you will get the total number of rows fetched

edited Oct 30 '13 at 22:27

Nikita Silverstruk

1,097
1
20
42

answered Nov 23 '10 at 09:55

user1580004

49
3

how to count the fetched rows by sqldatasource

7 Answers7