How can I divide single table into small Multiple tables structure

It seems to me that you want to show only one table but in 3 columns. I think you do not need multiple tables, that would be too complicated for what you need. I am not experienced with this but I find several answers saying to use a DataList control and set RepeatColumns=3. The following I think is one question like yours.

asp.net - List displayed as 2 columns - Stack Overflow
https://stackoverflow.com/questions/9103314/list-displayed-as-2-columns
 

It seems like you want to display data from a single table in multiple tables with 10 rows each, and you're using ADO.NET with MVC. You can achieve this by first fetching the data from your database using ADO.NET and then organizing it into multiple tables for display in your MVC view. Here's a step-by-step guide on how to accomplish this:

Retrieve Data from the Database:

First, you need to retrieve the data from your database using ADO.NET. You can use SQL queries to fetch the data you need. For example:

using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    string query = "SELECT * FROM YourTable ORDER BY SeatNo";
    SqlCommand command = new SqlCommand(query, connection);

    using (SqlDataReader reader = command.ExecuteReader())
    {
        // Fetch and store the data in a list or another suitable data structure.
    }
}

Organize Data into Multiple Tables:

After fetching the data, you can organize it into multiple tables, each containing up to 10 rows. You can do this by iterating through the data and creating a new table every 10 rows.

int batchSize = 10;
List> tables = new List>();
List currentTable = new List();

foreach (var item in yourDataList)
{
    currentTable.Add(item);

    if (currentTable.Count == batchSize)
    {
        tables.Add(currentTable);
        currentTable = new List();
    }
}

// Add the last table if there are remaining rows.
if (currentTable.Count > 0)
{
    tables.Add(currentTable);
}

Pass Data to the MVC View:

In your MVC controller, you can pass the list of tables to your view using a ViewModel or ViewBag.

ViewBag.Tables = tables;

Display the Data in the View:

In your MVC view, you can loop through the list of tables and generate HTML tables for each batch of data.

@foreach (var table in ViewBag.Tables)
{
    
        @foreach (var item in table)
        {
            
        }
    

        

            
Header1
            
Header2
            
        

                
@item.Property1
                
@item.Property2
                
            
}

This code will create multiple HTML tables, each containing up to 10 rows of data from your single table. You can customize the table headers and row properties according to your actual data structure.