Manipulate data in a DataGrid Asp.Net C#

Question

I'm creating a datagrid using the code below

 //Establishing the MySQL Connection
        SqlConnection conn = new SqlConnection(@"Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\aspnet-StudentMoneySaver-20160203040444.mdf;Initial Catalog=aspnet-StudentMoneySaver-20160203040444;Integrated Security=True");

        string query;
        SqlCommand SqlCommand;
        SqlDataReader reader;

        SqlDataAdapter adapter = new SqlDataAdapter();
        //Open the connection to db
        conn.Open();

        //Generating the query to fetch the contact details
        query = "SELECT EvtName, EvtType, EvtDescription, EvtDate, EvtVote FROM Events";
        SqlCommand = new SqlCommand(query, conn);
        adapter.SelectCommand = new SqlCommand(query, conn);
        //execute the query
        reader = SqlCommand.ExecuteReader();
        //Assign the results 
        GridView1.DataSource = reader;
        //Bind the data
        GridView1.DataBind();

and this is the front end code

<asp:DataGrid runat="server" ID="GridView1">

             </asp:DataGrid>

At the moment, this is outputting each row within the table one after another. I'm not sure how I can output each row into a separate jumbotron with the it being styled a bit better. For example, EvtType could he H1, Event Description H2 etc.. Any help as always is much appreciated. I'm looking to separately display each row

TheRotag · Accepted Answer · 2016-04-05 16:00:10Z

1

I'd suggest using an <asp:Repeater instead of a DataGrid or GridView. Then you have complete control over how each item is rendered. It would look something like this:

<asp:Repeater ID="Repeater1" runat="server">
    <ItemTemplate>
        // Your HTML here, which will be repeated for each item
    </ItemTemplate>
</asp:Repeater>

answered Apr 5, 2016 at 16:00

TheRotag

4183 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Manipulate data in a DataGrid Asp.Net C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related