C#

finally 
{
   xmlDoc = null;
}

for(int x=0;x<DGV.Rows.Count;x++)
{
 if(Val==DGV[COL,x].Value)
 {
  messageBox.Show("Row="+x);
  breake;
 }
}

Ice_Freez05 wrote:

what can i do if the function returns a null or 0 value?

public int getRequestedFunctionID(string strFunctCode)
    {
    SQLiteCommand SQLComm;
    SQLiteDataReader sqlDR = null;

    int intFuncNameID = 0;

    string strSQL = "SELECT FuncNameID " +
    "FROM tblFuncName WHERE FunctCode = '" + strFunctCode + "'";

    try
        {
        cnn = new SQLiteConnection(strConn);
        cnn.Open();

        SQLComm = new SQLiteCommand(strSQL, cnn);
        sqlDR = SQLComm.ExecuteReader();


        sqlDR.Read();
        if (sqlDR.HasRows)
            {
            intFuncNameID = Convert.ToInt32(sqlDR["FuncNameID"]);
            }

        }
    catch
        {
        intFuncNameID = 100;

        }
    finally
        {
        sqlDR.Dispose();
        cnn.Close();
        }
    return intFuncNameID;
    }

cnn = new SQLiteConnection(strConn);
cnn.Open();
string strSQL = "SELECT FuncNameID FROM tblFuncName WHERE FunctCode = @FC";
SQLComm = new SQLiteCommand(strSQL, cnn);
SQLComm.Parameters.AddWithValue("@FC", strFunctCode);
sqlDR = SQLComm.ExecuteReader();

if (intFuncNameID == 0)
    {
    LogToSomewhereTheDBIfNecessary(strFunctCode, sqlDR["FuncNameID"], "It returns zero!");
    }

int i = 0;