C#

linto_11 wrote:

if (reader.HasRows)
{
rnd = SelectRandom.Next(0,totalcount - 1);
book = reader[0].ToString();
datastring = book.ToCharArray();
}

nagendrathecoder wrote:
inside While(reader.Read()) loop.
If u put that code inside while then u don't need if(reader.HasRows) loop.
Also, call reader.Close() before access.Close().

int rnd;
int totalcount = 0;
Random SelectRandom = new Random();
OleDbConnection access = new OleDbConnection();
OleDbCommand accesscmd = new OleDbCommand();
OleDbDataReader reader;
if (combo_Category.Text == "Book")
{
string connectionstring = "Provider = Microsoft.Jet.OLEDB.4.0;
Data Source = |DataDirectory|\\HangmanDatabase.mdb";
access.ConnectionString = connectionstring;
access.Open();
accesscmd.CommandText = "Select * From Book";
accesscmd.Connection = access;
reader = accesscmd.ExecuteReader();
while (reader.Read())
{
totalcount = totalcount + 1;
rnd = SelectRandom.Next(0,totalcount - 1);
book = reader.GetValue(0).ToString();
datastring = book.ToCharArray();
}
reader.Close();
access.Close();
convert();
}

nagendrathecoder wrote:

totalcount = totalcount + 1;
rnd = SelectRandom.Next(0,totalcount - 1);
book = reader.GetValue(0).ToString();
datastring = book.ToCharArray();

linto_11 wrote:

ANS: Actually "datastring = book.ToCharArray();" this line of code works.....the thing is that i have to randomly select a name from the database and display it on a txtbox....that is wt i was doin....but that code snippet of mine was of no use....the snippet which u hav given me does not take d name randomly.....suggest me how to take names randomly from d database???

float fData = Convert.ToSingle(bData[0]);