How to Generate random rows in dataset using c#.net

For generating the random rows from the data set first you have to generate the random numbae and this number is pass to the dataset
CODE:

 SqlConnection con = new SqlConnection("Data Source=NIRAV-PC;Initial Catalog=Student;Integrated Security=True");
            con.Open();

            string str = "select * from StudentDetail";
            SqlCommand cmd =new SqlCommand(str,con);
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            DataSet ds =new DataSet();
            sda.Fill(ds);

            Random RandomNumber = new Random();
            int no = RandomNumber.Next(0,ds.Tables[0].Rows. Count);
            textBox1.Text = ds.Tables[0].Rows[no][0].ToString();
        
 

Comments

  1. abir dasguptaSeptember 23, 2015 at 10:41 PM

    This comment has been removed by the author.

    ReplyDelete
  2. phd thesis helpDecember 22, 2017 at 7:09 AM

    Thanks for this code. Could you please tell me how can i show data of two tables in a one cell. Please guide me.

    ReplyDelete
    Replies
    1. Nirav DaraniyaDecember 26, 2017 at 10:58 AM

      Please tell me in detail, I have not understood. What you actually want ?

      Delete

Post a Comment

Popular posts from this blog

How to make and use web service in Microsoft Dynamics Navision.

Image
Web services is use to do operation on data of NAV from outside the NAV environment, you can’t insert, update, delete the data of NAV using web service with proper authentication. For creating the web service in NAV follow below steps. (Here we are making the web service with gives vendor name based on vendor number. And we consume this service in windows application outside the NAV area.) Open NAV development environment and create the new code unit. Make one function “GetVendorName” Function name: GetVendorName Input Parameter : VendorNumber Output (Return) parameter : VendorName Now write below code in function. IF Vendor.GET(VendorNo)THEN BEGIN     EXIT(Vendor.Name); END ELSE BEGIN     EXIT('Vendor Not Found'); END Now save this codeunit with proper Id and Name. Now open the client application module and search for ‘Web service’ in search text box.  Open the “Web service page” and click on “NEW” button, it will ask following details Object Type: Codeunit Obj...
Read more

How to use Format function in Microsoft Dynamics Navision.

Image
Format function is use to display date in various format some example given below. Format function take 3 input argument First: date which you want o display Second: number of character return by default is 0 (o means return all the string) Third: string format in witch you want to convert. Example: 1 MESSAGE('Today  date is : %1 ', FORMAT(TODAY,0,'<Month Text> <Day,2> <Year4>')); OURPUT: Emaple:2 MESSAGE('Today  date is : %1 ', FORMAT(TODAY,0,' <Day,2> <Month,2> <Year4>')); OUTPUT:
Read more

How to create simple report in Microsoft Dynamics Navision.

Image
Report is one type of data representation in NAV , report is use to display data from the database to outside user. Here we make simple customer list report as example, for creating simple report using Microsoft SQL server report builder you have to follow below steps. Open the Microdot Dynamics Navision development Environment and  go to “Tools  >> Options ” and go to “Use Report Builder” variable and set it to “Yes” and  then close screen by clicking on OK. Now go to “Report” table and click on “new” button. It will open new windows, here you have to specify the data item as any table which you want to display in report, and here we take “Customer” table as show in below image Now we have to add column which is used in report so for adding this we have to add data columns  for this, so go to next row and select column as data type and for adding column you can go to Option >> Field  menu option as show in below image. Now select the field which you...
Read more