Click here to Skip to main content
15,885,365 members
Home / Discussions / C#
   

C#

 
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 
GeneralRe: how do I implement scrolling? PART 2 Pin
Robert Rohde15-Jan-06 1:58
Robert Rohde15-Jan-06 1:58 
GeneralRe: how do I implement scrolling? PART 2 Pin
Sasuko15-Jan-06 4:05
Sasuko15-Jan-06 4:05 
GeneralRe: how do I implement scrolling? PART 2 Pin
Robert Rohde15-Jan-06 5:22
Robert Rohde15-Jan-06 5:22 
GeneralRe: how do I implement scrolling? PART 2 Pin
Sasuko15-Jan-06 5:39
Sasuko15-Jan-06 5:39 
QuestionDataGridBoolColumn Question Pin
lior654#hotmail.com14-Jan-06 12:30
lior654#hotmail.com14-Jan-06 12:30 
AnswerRe: DataGridBoolColumn Question Pin
Robert Rohde14-Jan-06 21:21
Robert Rohde14-Jan-06 21:21 
GeneralRe: DataGridBoolColumn Question Pin
lior654#hotmail.com17-Jan-06 4:03
lior654#hotmail.com17-Jan-06 4:03 
GeneralRe: DataGridBoolColumn Question Pin
Robert Rohde17-Jan-06 8:15
Robert Rohde17-Jan-06 8:15 
GeneralRe: DataGridBoolColumn Question Pin
lior654#hotmail.com17-Jan-06 11:02
lior654#hotmail.com17-Jan-06 11:02 
GeneralRe: DataGridBoolColumn Question Pin
Robert Rohde18-Jan-06 0:17
Robert Rohde18-Jan-06 0:17 

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.