Click here to Skip to main content
15,891,607 members
Home / Discussions / C#
   

C#

 
AnswerRe: how to auto refresh listbox values Pin
CodyGen15-Jan-06 4:15
CodyGen15-Jan-06 4:15 
GeneralRe: how to auto refresh listbox values Pin
batmanAgen15-Jan-06 4:22
batmanAgen15-Jan-06 4:22 
GeneralRe: how to auto refresh listbox values Pin
Ravi Bhavnani15-Jan-06 7:39
professionalRavi Bhavnani15-Jan-06 7:39 
Questionimages...JPEG or BITMAP Pin
sa maq14-Jan-06 23:00
sa maq14-Jan-06 23:00 
AnswerRe: images...JPEG or BITMAP Pin
Guffa14-Jan-06 23:20
Guffa14-Jan-06 23:20 
Questionc# program using a barcode scanner Pin
steve_rm14-Jan-06 20:18
steve_rm14-Jan-06 20:18 
AnswerRe: c# program using a barcode scanner Pin
Robert Rohde14-Jan-06 21:27
Robert Rohde14-Jan-06 21:27 
AnswerRe: c# program using a barcode scanner Pin
cjengler15-Jan-06 3:19
cjengler15-Jan-06 3:19 
AnswerRe: c# program using a barcode scanner Pin
Dave Kreskowiak15-Jan-06 4:16
mveDave Kreskowiak15-Jan-06 4:16 
GeneralRe: c# program using a barcode scanner Pin
steve_rm15-Jan-06 5:56
steve_rm15-Jan-06 5:56 
QuestionRandom number Pin
hung_ngole14-Jan-06 18:02
hung_ngole14-Jan-06 18:02 
AnswerRe: Random number Pin
Joshua Quick14-Jan-06 18:21
Joshua Quick14-Jan-06 18:21 
AnswerRe: Random number Pin
DigitalKing14-Jan-06 20:27
DigitalKing14-Jan-06 20:27 
GeneralRe: Random number Pin
Joshua Quick14-Jan-06 20:59
Joshua Quick14-Jan-06 20:59 
GeneralRe: Random number Pin
Colin Angus Mackay15-Jan-06 23:58
Colin Angus Mackay15-Jan-06 23:58 
QuestionHelp regarding window form in a window Pin
edel_ong14-Jan-06 17:46
edel_ong14-Jan-06 17:46 
AnswerRe: Help regarding window form in a window Pin
Joshua Quick14-Jan-06 18:30
Joshua Quick14-Jan-06 18:30 
QuestionC# casting problem object to string[] Pin
plsaiuser14-Jan-06 15:34
plsaiuser14-Jan-06 15:34 
Greetings All,

Can anybody pls help in the following.
i have written 2 functions getRecordList and GetRowsList. i am getting casting problem vaResultSet = (string[])GetRowsList(ref SqlDataReader, nStart, nrows); in getRecordList function. can anybody pls have a look at my code pls give your valuable suggestions and mistakes in code. its some what urjent and really it will be very greatful for your earliest replies. thanks in advance.

protected string[] getRecordList(StringBuilder vaInput)

{

setCallerDetails();

SqlCommand sqlCommand;

SqlDataReader SqlDataReader;


string[] vaResultSet;

string[] vaOutput = new string[4];

string szSql;

long nStart;

long nrows;

long nRecordCount = 0;

short i;


try

{

if (Information.IsArray(vaInput))

{

szSql = vaInput[0].ToString();

nStart = vaInput[1];

nrows = vaInput[2];

}

else

{

szSql = vaInput.ToString();

nrows = - 1;

nStart = 1;

}

string StrLastSQL = szSql;

if (openDatabase() == C_RET_SUCCESS)

{

if (Information.Err().Number == 0)

{

if (szSql.Length> 0)

{

sqlCommand = new SqlCommand(szSql, sqlConnection);

sqlCommand.CommandTimeout = iCommandTimeOut;

SqlDataReader = sqlCommand.ExecuteReader();


vaResultSet = (string[])GetRowsList(ref SqlDataReader, nStart, nrows);

if (Information.IsArray(vaResultSet))

{

for (i = 0; i <= Information.UBound((System.Array) vaResultSet, 1); i++)

{

if (Information.IsArray(vaResultSet))

{

nRecordCount = nRecordCount + vaResultSet[1];

}

}

}

else

{

nRecordCount = 0;

}

vaOutput[0] = "E" + Information.Err().Number;

try

{

if (Information.IsArray(vaResultSet))

{

if (Information.UBound((System.Array) vaResultSet, 1) == 0)

{

vaOutput[1] = vaResultSet[0][0].ToString();

}

else

{

vaOutput[1] = vaResultSet.ToString();

}

}

}

catch (Exception ex)

{

HandleError(ex, C_CLASS_NAME, true);

}

vaOutput[2] = nRecordCount.ToString();

vaOutput[3] = Interaction.IIf(! Information.IsNothing(vaResultSet), Interaction.IIf(Information.IsArray(vaResultSet), Information.UBound((System.Array) vaResultSet, 1), 0), 0).ToString();

SqlDataReader.Close();


}

else

{

vaOutput[0] = "EC01";

}

}

else

{

vaOutput[0] = "E" + Information.Err().Number;

}

closeDatabase();

}

}

catch (Exception ex)

{

vaOutput[0] = C_RET_FAIL;

HandleError(ex, C_CLASS_NAME, true);

}

return vaOutput;

}

**************************************

protected object GetRowsList(ref SqlDataReader oReader, long nStart, long nRows)

{

int nCols;

long rCnt = 0;

long nbegin = 0;

long nEnd = 0;


ArrayList vaResultSet = new ArrayList();

bool bAll = false;

bool bExit = false;

//sai need to check above 2 variables false or true

try

{

do

{

rCnt = 0;

nCols = oReader.FieldCount;

if (nStart == 1 && nRows == - 1)

{

nbegin = 0;

bAll = true;

}

else if (nStart > 0 && nRows == - 1)

{

nbegin = nStart - 1;

bAll = true;

}

else if (nStart > 0 && nRows > 0)

{

nbegin = nStart - 1;

nEnd = nbegin + nRows - 1;

}

ArrayList vaArray = new ArrayList();

while (oReader.Read())

{

if (! bExit)

{

if (nbegin <= rCnt &&(nEnd >= rCnt || bAll == true))

{

try

{

object[] values = new object[nCols-1];

oReader.GetValues(values);

vaArray.Add(values);

}

catch (Exception ex)

{

HandleError(ex, C_CLASS_NAME,false);

//sai need to check, boolean is true or false

}

}

else if ((bAll == false) &&(nEnd < rCnt))

{

bExit = true;

}

}

rCnt = rCnt + 1;

}


object[] vaOut = new object[] { vaArray, rCnt };

vaResultSet.Add(vaOut);

} while (oReader.NextResult());

}

catch (Exception ex)

{

MessageBox.Show(ex.Message.ToString());

HandleError(ex, C_CLASS_NAME,false);

}

return vaResultSet;

}



Thanks in advance

Sai
AnswerRe: C# casting problem object to string[] Pin
Joshua Quick14-Jan-06 18:15
Joshua Quick14-Jan-06 18:15 
Questionimage 2 mpeg-2 Pin
Kin Tutnik14-Jan-06 14:11
Kin Tutnik14-Jan-06 14:11 
AnswerRe: image 2 mpeg-2 Pin
Sasuko14-Jan-06 14:33
Sasuko14-Jan-06 14:33 
Questionhow do I implement scrolling? PART 2 Pin
Sasuko14-Jan-06 13:46
Sasuko14-Jan-06 13:46 
AnswerRe: how do I implement scrolling? PART 2 Pin
Dave Kreskowiak14-Jan-06 16:10
mveDave Kreskowiak14-Jan-06 16:10 
AnswerRe: how do I implement scrolling? PART 2 Pin
Robert Rohde14-Jan-06 21:30
Robert Rohde14-Jan-06 21:30 
GeneralRe: how do I implement scrolling? PART 2 Pin
Sasuko15-Jan-06 0:41
Sasuko15-Jan-06 0:41 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.