using repeater to get data

Hello

Please check out the below sample code for repeater control in asp.net.

aspx code
 

  
                  
                              
                
aspx.cs code
public partial class _Default : System.Web.UI.Page  
{  
    SqlConnection con;  
    SqlCommand cmd = new SqlCommand();  
    protected void Page_Load(object sender, EventArgs e)  
    {  
        con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString);  
        cmd.Connection = con;  
        cmd.CommandText = "select * from student";  
        con.Open();  
        RepeatInformation.DataSource = cmd.ExecuteReader();  
        RepeatInformation.DataBind();  
        con.Close();  
    }  
}
 
Thanks 
Vishal Joshi
Vijay Pratap Singh2y agoPosted Apr 16, 2024, 9:51 AM
// Assuming you have a SQL Server database
using System;
using System.Data.SqlClient;
using System.Web.UI.WebControls;

public partial class YourPage : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            // Connection string to your database
            string connectionString = "YourConnectionString";
            
            // SQL query to retrieve data in descending order
            string query = "SELECT * FROM YourTable ORDER BY YourColumn DESC";
            
            // Create a connection
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                // Open the connection
                connection.Open();
                
                // Create a command with the query and connection
                using (SqlCommand command = new SqlCommand(query, connection))
                {
                    // Execute the command and get a data reader
                    using (SqlDataReader reader = command.ExecuteReader())
                    {
                        // Bind the data reader to the Repeater control
                        repeater.DataSource = reader;
                        repeater.DataBind();
                    }
                }
            }
        }
    }
}


Now bind data to the repeater

 


    
        
        

            
        
    



Hope this will help.



Thanks
Jayraj Chhaya2y agoPosted Apr 16, 2024, 9:45 AM
To display data in descending order using a repeater in a .NET application, you can sort the data before binding it to the repeater control. Here's a simple example using C#:

// Assuming you have a DataTable named 'dataTable' with the data from the database
// Sort the DataTable in descending order based on a specific column
dataTable.DefaultView.Sort = "ColumnName DESC";
DataTable sortedData = dataTable.DefaultView.ToTable();

// Bind the sorted data to the repeater control
repeater.DataSource = sortedData;
repeater.DataBind();


replace 'ColumnName' with the actual column name you want to sort the data by in descending order. This approach ensures that the data displayed by the repeater is in the desired descending order.
  
                    
  
                        
  
                                Roll No  
                            
  
                            
  
                                Student Name  
                            
  
                            
  
                                Total Fees  
                            
  
                          
                    
  
              
  
                    
  
                        <%#DataBinder.Eval(Container,"DataItem.RollNo")%>  
                    
  
                    
  
                        <%#DataBinder.Eval(Container,"DataItem.Name")%>  
                    
  
                    
  
                        <%#DataBinder.Eval(Container,"DataItem.Fees")%>