Database

Chaminda Aruna Bandara wrote:

as a Senior Technical Support Analyst

id	int 
operation nvarchar(50)
table_name nvarchar(200)
col_name nvarchar(200)
key_col nvarchar(200)
key_val nvarchar(200)
col_val_prior nvarchar(MAX)
col_val_new nvarchar(MAX)
username nvarchar(50)
transaction_dt datetime
batch nvarchar(MAX)

1. Get the records from your database, using a SELECT clause.
2. Save that response into a variable of type array (or a generic list).

public void GetDatainArr()
{
        string strSQl = "";
        string[] Arr = new string[50];
        strSQl = "select [Id] from [tblname] ";
        DataTable dt = GetDataTable(strSQl); //GetDataTable function 
        if (dt.Rows.Count > 0)
        {
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Arr[i] = Convert.ToString(dt.Rows[i][0]);
            }
        }
}
public DataTable GetDataTable(string Sql)
{
        SqlConnection conn = new SqlConnection("ConnectionString ");
        conn.Open();
        DataTable dt = new DataTable();
        SqlCommand cmd = new SqlCommand(Sql, conn);
        SqlDataAdapter ad = new SqlDataAdapter();
        ad.Fill(dt);
        conn.Close();
        return dt;
}

Row Rank in a MySQL View[^]

Use:

SQL

SELECT t.id,
       t.variety,
       (SELECT COUNT(*) FROM TABLE WHERE id < t.id) +1 AS NUM
  FROM TABLE t