How to count total number of row

Question

Hii sir, How to count total inserted table number of row from msaccess database and display it into a label using c# ?

Amit Mohanty · Answer

Using dataset. OleDbConnection OleDbCon = new OleDbConnection( "Your Connection Strig" ); string strQuery = "SELECT COUNT(*) AS nCount FROM tblYourTable" ; if (OleDbCon.State == ConnectionState.Closed) { OleDbCon.Open(); } OleDbCommand OleDbCmd = new OleDbCommand(strQuery, OleDbCon); OleDbDataAdapter OleDbDa = new OleDbDataAdapter(OleDbCmd); DataSet dsData = new DataSet(); OleDbDa.Fill(dsData); OleDbCon.Close(); lblCount.Text = dsData.Tables[0].Rows[0][ "nCount" ].ToString(); Let me know its working or not.

Mageshwaran R · Answer

Hi, try thisquery: SELECT COUNT (*) As 'Row_Count' FROM Employee sqlconnection sqlcon = new sqlconnection(ConnectionString); sqlcommand sqlcmnd= new sqlcommand( "SELECT COUNT(*) As 'Row_Count' FROM Employee" ,sqlcon); sqlcmnd.Executenonquery(); sqldatareader reader=sqlcmnd.executereader(); if (reader.read()) { lblcount.text=reader[0][ "Row_Count" ].Tostring(); }

Sonu Gupta · Answer

Hi, Try this for Dataset - string connetionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=your .mdb file;"; string sql = " select COUNT(*) AS StudCount from student "; OleDbConnection connection = new OleDbConnection(connetionString); OleDbDataAdapter dataadapter = new OleDbDataAdapter(sql, connection); DataSet ds = new DataSet(); connection.Open(); dataadapter.Fill(ds); connection.Close(); dataGridView1.DataSource = ds; lblCounter.Text = ds .Tables[0].Rows[0][" StudCount "].ToString();

Kausar Ali · Answer

pls write this code using dataset.

Kausar Ali · Answer

dear sir , The code you given is not working sonu gupta sir,and amit sir.

Sonu Gupta · Answer

Hi, This code may help you - OleDbConnection my_con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C\db.accdb"); my_con.Open(); OleDbCommand cmds = new OleDbCommand("select COUNT(*) AS StudCount from student", my_con); OleDbDataAdapter da = new OleDbDataAdapter(cmds); DataTable dt = new DataTable(); da.Fill(dt); lblCounter.Text = dt.Rows[0][" StudCount "].ToString();

Amit Mohanty · Answer

Hey try this. OleDbConnection OleDbCon = new OleDbConnection( "Your Connection Strig" ); string strQuery = "SELECT COUNT(*) AS nCount FROM tblYourTable" ; if (OleDbCon.State == ConnectionState.Closed) { OleDbCon.Open(); } OleDbCommand OleDbCmd = new OleDbCommand(strQuery, OleDbCon); OleDbDataAdapter OleDbDa = new OleDbDataAdapter(OleDbCmd); DataTable dtData = new DataTable(); OleDbDa.Fill(dtData); OleDbCon.Close(); lblCount.Text = dtData.Rows[0][ "nCount" ].ToString();

Chittaranjan Swain · Answer

Hi Ali, Refer below links, https://stackoverflow.com/questions/20160928/how-to-count-the-number-of-rows-from-sql-table-in-c https://www.aspforums.net/Threads/616597/Count-number-of-rows-in-a-table-using-C-and-VBNet-in-ASPNet/

Farhan Ahmed · Answer

https://www.aspsnippets.com/Articles/Display-Count-of-Total-number-of-records-in-ASPNet-GridView-using-C-and-VBNet.aspx

How to count total number of row

Answers (9)