This method returns integer type value, actually, it returns top tuple no of record from the table. Here I will provide you an example of ExecuteScalar ( ) method. By using this example you can retrieve top tuple no from the record.
Source Code
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="Label1" runat="server"></asp:Label>
<br />
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Get Record" />
</div>
</form>
</body>
</html>
CodeBehind Code
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
public partial class GetfirstRecord : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionStringtr"].ToString();
con.Open();
SqlCommand cmd=new SqlCommand();
cmd.CommandText="select * from [user_table]";
cmd.Connection=con;
int a = Convert.ToInt32(cmd.ExecuteScalar());
Label1.Text = a.ToString();
}
}
Code Generates the following output:
