How to display data in custom table using asp.net?

Question

I want to display data from my SQL database in a custom table format. So basically this is what I would like to achieve:

A. To display all entries in SQL table in a gridview with a view button next to each row

B. Click on the view button to display the below in a new web page

 ______________________________________
|           Customer Info              |
----------------------------------------
|Customer Name:   "From DB Table"      |
|Address:         "From DB Table"      |
----------------------------------------

Then the next table below the one above

 ______________________________________
|           Customer Network           |
----------------------------------------
|Network Location:   "From DB Table"   |
|APs:                "From DB Table"   |
----------------------------------------

All of the above is from one ID in my SQL DB table. So I want to break it up into sections to display all the data in the SQL Table

I don't have any code yet as I am not sure on how to do this.

To sum up: When the page loads it the shows all the entries in the database in a gridview with a view button next to each row

Then when the user clicks on the view button it opens a new page with the above table.

Thanks

CODE

GridView

Then Code Behind

                GridView1.DataSource = GetData();
                GridView1.DataBind();
            }
        }
    }

    DataTable GetData()
    {
        DataTable dt = new DataTable();
        using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["OfficeConnection"].ConnectionString))
        {
            con.Open();
            using (SqlCommand cmd = new SqlCommand("SELECT DisplayName 'Display Name', Replace(PrimaryEmailAddress,'SMTP:', ' ') 'Email Address', Replace(Licenses,'reseller-account:', ' ') 'License Type', LastPasswordChangeTimestamp 'Last Password Reset' FROM Consulting ", con))
            {
                for (int i = dt.Rows.Count - 1; i >= 0; i--)
                {
                    if (dt.Rows[i][1] == DBNull.Value)
                        dt.Rows[i].Delete();
                }
                dt.AcceptChanges();
                SqlDataAdapter adpt = new SqlDataAdapter(cmd);
                adpt.Fill(dt);
            }

        }
        return dt;
    }
}
}

This is some code from a different section in my web app. I can use the same code with a few changes, but how do I add the View button and to achieve the above question?

dpant · Accepted Answer

A. This should work:

Customers.aspx


    
        
        
                            
        <%--add other data fields here--%>

Code-behind

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        GetData();
    }
}

private void GetData()
{
    SqlDataReader dr;
    using (SqlConnection con = new SqlConnection([YOUR CONNECTION STRING]))
    {
        con.Open();
        // replace with your query
        using(SqlCommand cmd = new SqlCommand("SELECT ID,Name,Email,Address FROM Customers", con))
        {
            dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            GridView1.DataSource = dr;
            GridView1.DataBind();
        }
    }           
}

B. The "view" page accepts the customer ID as parameter to display his details in any html layout you like, for example:

View.aspx


    
        
            Customer Info
        
        
            Customer Name:
            
        
        
            Address:
            
        
    



    
        
            Customer Network
        
        
            Email:
            
        
        
            Network Location:

Code-behind

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        GetData();
    }
}

private void GetData()
{
    SqlDataReader dr;
    using (SqlConnection con = new SqlConnection([YOUR CONNECTION STRING]))
    {
        con.Open();
        // replace with your query
        using (SqlCommand cmd = new SqlCommand($"SELECT Name,Email,Address FROM Customers WHERE ID={Request["id"]}", con))
        {
            dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            if (dr.Read())
            {
                Name.Text = dr["Name"].ToString();
                Address.Text = dr["Address"].ToString();
                Email.Text = dr["Email"].ToString();
                // etc
            }
        }
    }
}

As said, you can replace both the code to fetch data from the database and the HTML layout with anything you like. This is the bare minimum.

How to display data in custom table using asp.net?

Answers (2)

Related Questions