ASP.NET

ASP.NET RSS

random selection of database entries

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Jun 2009

Posts: 8

Reputation: ariez88 is an unknown quantity at this point

Solved Threads: 0

ariez88

Offline

Newbie Poster

random selection of database entries

Jul 8th, 2009

hello,
can anyone tell me how to randomly pick entries from a database using ASP.NET as front end and SQL SERVER as backend ?

i have written
select * from table order by rand();

but instead of picking entries randomly, it simply displays the entries in the same order as they are stored in the database..

thanks alot.

•

Join Date: Jun 2009

Posts: 439

Reputation: Ramesh S will become famous soon enough

Solved Threads: 82

Ramesh S

Offline

Posting Pro in Training

Re: random selection of database entries

Jul 8th, 2009

Try this

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
SELECT TOP 100  *
FROM Your_Table_Name
ORDER BY NEWID()
SELECT TOP 100  *
FROM Your_Table_Name
ORDER BY NEWID()

This will pick 100 records randomly from a SQL Server 2005 table.

•

Join Date: Jun 2009

Posts: 8

Reputation: ariez88 is an unknown quantity at this point

Solved Threads: 0

ariez88

Offline

Newbie Poster

Re: random selection of database entries

Jul 9th, 2009

thankyou very much.. there seems to be a problem with SQL at my home so i was unable to try it yet..I'll try it in the uni the next time i go there.
another problem tht i m having is in this code..

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
protected void loginButton_Click1(object sender, EventArgs e)
   {
        DataSet temp = new DataSet();
        temp = conn.retrieve("select * from candidate_info");
        int i=0;
        int a = temp.Tables[0].Rows.Count;
        //object obj = new object();
 
        object[] obj;
 
        while( i < a)
        {
            obj = temp.Tables[0].Rows[i].ItemArray;
 
                if (this.idTextBox.Text != obj[0].ToString() && this.passTextBox.Text != obj[1].ToString())
                    i++;
 
        }   
        if (i == a)
            Response.Write("<script>alert('ERROR')</script>");  
        else
 
       Response.Write("<script>alert('Logged In')</script>");
 
}
protected void loginButton_Click1(object sender, EventArgs e)
   {
        DataSet temp = new DataSet();
        temp = conn.retrieve("select * from candidate_info");
        int i=0;
        int a = temp.Tables[0].Rows.Count;
        //object obj = new object();

        object[] obj;

        while( i < a)
        {
            obj = temp.Tables[0].Rows[i].ItemArray;
           
                if (this.idTextBox.Text != obj[0].ToString() && this.passTextBox.Text != obj[1].ToString())
                    i++;

        }   
        if (i == a)
            Response.Write("<script>alert('ERROR')</script>");  
        else
            
       Response.Write("<script>alert('Logged In')</script>");
       
}

this is the piece of code tht I have written for the sign in button. The problem here is tht whenever I input wrong entry it gives error in logging in.. Which is correct but when ever I enter an entry tht is present in the database it is stuck there and never goes to the next page and never shows the “logged in ” message. and sometimes it even shows the logged in message for wrong entries... i dont know how to handle it..i guess there is some mistake in the brackets..
can anyone help me??
thanks alot

Last edited by peter_budo; Jul 10th, 2009 at 6:24 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

•

Join Date: May 2008

Posts: 164

Reputation: dnanetwork has a little shameless behaviour in the past

Solved Threads: 24

dnanetwork dnanetwork is offline

Offline

Junior Poster

Re: random selection of database entries

Jul 10th, 2009

grab all the value from the database by using the select statment & next store it in the session array or arraylist and next to acces them use random class provided by C#...

•

Join Date: Jun 2009

Posts: 8

Reputation: ariez88 is an unknown quantity at this point

Solved Threads: 0

ariez88

Offline

Newbie Poster

Re: random selection of database entries

Jul 11th, 2009

I have tried this. please have a look at it and kindly let me know....
Errors are written within the code. and will you please explain how to access them using random class?

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
protected void loginButton_Click1(object sender, EventArgs e)
   {
       ArrayList arr = new ArrayList();
      arr =conn.retrieve("select * from candidate_info");
 
       /*
 
           Error:Cannot implicitly convert type 
 
          'System.Data.DataSet' to 'System.Collections.ArrayList' 
 
       */
 
       int i=0;
       int a = arr.Count;
       Random rand = new Random();
 
       // where to use this random class. what will it do ???
 
       while (i < a)
 
       {
 
             // rand = arr[0]; confused here ................
 
            if (this.idTextBox.Text != obj[0].ToString() && this.passTextBox.Text != obj[1].ToString())
 
               i++;
 
        }  
 
        if(i == a)
 
            Response.Write("<script>alert('ERROR')</script>"); 
 
       else Response.Write("<script>alert('Logged In')</script>");                        
}
protected void loginButton_Click1(object sender, EventArgs e)
   {
       ArrayList arr = new ArrayList();
      arr =conn.retrieve("select * from candidate_info");

       /*

           Error:Cannot implicitly convert type 

          'System.Data.DataSet' to 'System.Collections.ArrayList' 

       */

       int i=0;
       int a = arr.Count;
       Random rand = new Random();

       // where to use this random class. what will it do ???

       while (i < a)

       {

             // rand = arr[0]; confused here ................

            if (this.idTextBox.Text != obj[0].ToString() && this.passTextBox.Text != obj[1].ToString())

               i++;

        }  

        if(i == a)

            Response.Write("<script>alert('ERROR')</script>"); 

       else Response.Write("<script>alert('Logged In')</script>");                        
}

many thanks..

Last edited by peter_budo; Jul 11th, 2009 at 2:38 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

•

Join Date: Apr 2009

Posts: 217

Reputation: mail2saion is an unknown quantity at this point

Solved Threads: 32

mail2saion mail2saion is offline

Offline

Posting Whiz in Training

Re: random selection of database entries

Jul 13th, 2009

Try to modify your code segment in the following way. If matched then exit other wise after completion of all iteration its sure that no matched data found means error.

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
while (i < a)
 
{
   // rand = arr[0]; confused here ................
  // Use trim for fixed lenth db datattype if varchar then leave it            
  if (this.idTextBox.Text == obj[0].ToString().Trim() && this.passTextBox.Text == obj[1].ToString().Trim())
  {
  Response.Write("<script>alert('Logged In')</script>");
  return;
  }
  i++;
}  
 
Response.Write("<script>alert('ERROR')</script>");
while (i < a)

{
   // rand = arr[0]; confused here ................
  // Use trim for fixed lenth db datattype if varchar then leave it            
  if (this.idTextBox.Text == obj[0].ToString().Trim() && this.passTextBox.Text == obj[1].ToString().Trim())
  {
  Response.Write("<script>alert('Logged In')</script>");
  return;
  }
  i++;
}  

Response.Write("<script>alert('ERROR')</script>");