using c# read data from the database and stored in a 2d arr

for (j = 0; j <= TagCnt - 1; j++)

{

for (i = 2; i <=16; i++)

{

if (strTag[j,1] == "0800")

{

try

{

if (Global.DBaseType == "SQL")

{

if (i == 2)

{

strQuery = "SELECT DATAVALUE_MAX, DATAVALMAX_TIME, DATAVALUE_MIN,DATAVALMIN_TIME FROM CALCANALOG_HISTORY_MONTHLY WHERE " +

" DATENAME(yyyy, DATAVALInst_TIME) = '" + intYear + "' and DATENAME(dd, DATAVALInst_TIME) ='" + DD_NameTemp + "' and DATENAME(MM, DATAVALInst_TIME) = '" + strMonth.Trim() + "' AND tag_id = " + strTag[j, i];

connMain = (SqlConnection)Global.objConnectionPool.getConnection();

SqlCommand SqlCmd = new SqlCommand(strQuery, connMain);

SqlDataReader SqlRead = SqlCmd.ExecuteReader();

while (SqlRead.Read())

{

strTag[j,2] = SqlRead.GetDouble(0).ToString("#####0.00");

}

SqlRead.Close();

SqlCmd.Dispose();

}

sir please suggest above code and how to stored this valus in array

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R6y ago

Hi,

Can you check with the below link:

https://stackoverflow.com/questions/35823408/reading-a-row-of-data-from-the-database-and-store-it-into-an-array
0
Ujjawal Arora7y ago
for (j = 0; j <= TagCnt - 1; j++)
{
for (i = 2; i <=16; i++)
{
if (strTag[j,1] == "0800")
{
try
{

if (Global.DBaseType == "SQL")
{
if (i == 2)
{
strQuery = "SELECT DATAVALUE_MAX, DATAVALMAX_TIME, DATAVALUE_MIN,DATAVALMIN_TIME FROM CALCANALOG_HISTORY_MONTHLY WHERE " +
" DATENAME(yyyy, DATAVALInst_TIME) = '" + intYear + "' and DATENAME(dd, DATAVALInst_TIME) ='" + DD_NameTemp + "' and DATENAME(MM, DATAVALInst_TIME) = '" + strMonth.Trim() + "' AND tag_id = " + strTag[j, i];
connMain = (SqlConnection)Global.objConnectionPool.getConnection();
connMain = (SqlConnection)Global.objConnectionPool.getConnection();
SqlCommand SqlCmd = new SqlCommand(strQuery, connMain);
SqlDataReader SqlRead = SqlCmd.ExecuteReader();
while (SqlRead.Read())
{
strTag[j,2] = SqlRead.GetDouble(0).ToString("#####0.00");
}
SqlRead.Close();
SqlCmd.Dispose();
}

sir please suggest above code and how to stored this valus in array
0
Piyush Pansuriya7y ago
Hello,
Please share your code for more clearity.
0