How to create Dashboard from Database using C# and VB.Net in ASP.Net

Hi Babloo22,

I have created sample code which full-fill your requirement. So please refer the below code and modify as per your requirement.

HTML

<div>
    <h2>
        <u>Dashboard</u></h2>
    <br />
    <table border="0" cellpadding="2" cellspacing="3">
        <tr>
            <td>
                <asp:LinkButton ID="lnkTab1" runat="server" OnClick="lnkTab1_Click">Daily</asp:LinkButton>
            </td>
            <td>
                <asp:LinkButton ID="lnkTab2" runat="server" OnClick="lnkTab2_Click">Weekly</asp:LinkButton>
            </td>
            <td>
                <asp:LinkButton ID="lnkTab3" runat="server" OnClick="lnkTab3_Click">Monthly</asp:LinkButton>
            </td>
        </tr>
        <tr>
            <td colspan="3">
                <asp:MultiView ID="MultiView1" runat="server">
                    <table width="100%" cellpadding="2" cellspacing="5">
                        <tr>
                            <td>
                                <asp:View ID="View1" runat="server">
                                    <asp:GridView ID="gvdaily" runat="server" />
                                </asp:View>
                            </td>
                            <td>
                                <asp:View ID="View2" runat="server">
                                    <asp:GridView ID="gvweekly" runat="server" />
                                </asp:View>
                            </td>
                            <td>
                                <asp:View ID="View3" runat="server">
                                    <asp:GridView ID="gvmonthly" runat="server" />
                                </asp:View>
                            </td>
                        </tr>
                    </table>
                </asp:MultiView>
            </td>
        </tr>
    </table>
</div>

C#

private string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        lnkTab1_Click(sender, e);
    }
}

private void GetData(string query, GridView gvData)
{
    SqlConnection con = new SqlConnection(constr);
    SqlCommand cmd = new SqlCommand(query, con);
    SqlDataAdapter sda = new SqlDataAdapter(cmd);
    DataTable dt = new DataTable();
    sda.Fill(dt);
    gvData.DataSource = dt;
    gvData.DataBind();
}

protected void lnkTab1_Click(object sender, EventArgs e)
{
    DateTime date = DateTime.Now.Date;
    string sql = "Select CustomerId,Name,Country,convert(varchar,CreatedDate,106) as CreatedDate from Dashboard WHERE createdDate between '" + date + "' AND '" + DateTime.Now.Date + "' ";
    GetData(sql, gvdaily);
    MultiView1.ActiveViewIndex = 0;
    lnkTab1.ForeColor = Color.Red;
    lnkTab2.ForeColor = Color.Blue;
    lnkTab3.ForeColor = Color.Blue;
}

protected void lnkTab2_Click(object sender, EventArgs e)
{
    DateTime date = DateTime.Now.AddDays(-7).Date;
    string sql = "Select CustomerId,Name,Country,convert(varchar,CreatedDate,106) as CreatedDate from Dashboard WHERE createdDate between '" + date + "' AND '" + DateTime.Now.Date + "' ";
    GetData(sql, gvweekly);
    MultiView1.ActiveViewIndex = 1;
    lnkTab2.ForeColor = Color.Red;
    lnkTab3.ForeColor = Color.Blue;
    lnkTab1.ForeColor = Color.Blue;
}

protected void lnkTab3_Click(object sender, EventArgs e)
{
    DateTime date = DateTime.Now.AddDays(-30).Date;
    string sql = "Select CustomerId,Name,Country,convert(varchar,CreatedDate,106) as CreatedDate from Dashboard WHERE createdDate between '" + date + "' AND '" + DateTime.Now.Date + "' ";
    GetData(sql, gvmonthly);
    MultiView1.ActiveViewIndex = 2;
    lnkTab1.ForeColor = Color.Blue;
    lnkTab2.ForeColor = Color.Blue;
    lnkTab3.ForeColor = Color.Red;
}

Vb.Net

Private constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
	If Not IsPostBack Then
		lnkTab1_Click(sender, e)
	End If
End Sub

Private Sub GetData(query As String, gvData As GridView)
	Dim con As New SqlConnection(constr)
	Dim cmd As New SqlCommand(query, con)
	Dim sda As New SqlDataAdapter(cmd)
	Dim dt As New DataTable()
	sda.Fill(dt)
	gvData.DataSource = dt
	gvData.DataBind()
End Sub

Protected Sub lnkTab1_Click(sender As Object, e As EventArgs)
	Dim [date] As DateTime = DateTime.Now.[Date]
	Dim sql As String = "Select CustomerId,Name,Country,convert(varchar,CreatedDate,106) as CreatedDate from Dashboard WHERE createdDate between '" + [date] + "' AND '" + DateTime.Now.[Date] + "' "
	GetData(sql, gvdaily)
	MultiView1.ActiveViewIndex = 0
	lnkTab1.ForeColor = Color.Red
	lnkTab2.ForeColor = Color.Blue
	lnkTab3.ForeColor = Color.Blue
End Sub

Protected Sub lnkTab2_Click(sender As Object, e As EventArgs)
	Dim [date] As DateTime = DateTime.Now.AddDays(-7).[Date]
	Dim sql As String = "Select CustomerId,Name,Country,convert(varchar,CreatedDate,106) as CreatedDate from Dashboard WHERE createdDate between '" + [date] + "' AND '" + DateTime.Now.[Date] + "' "
	GetData(sql, gvweekly)
	MultiView1.ActiveViewIndex = 1
	lnkTab2.ForeColor = Color.Red
	lnkTab3.ForeColor = Color.Blue
	lnkTab1.ForeColor = Color.Blue
End Sub

Protected Sub lnkTab3_Click(sender As Object, e As EventArgs)
	Dim [date] As DateTime = DateTime.Now.AddDays(-30).[Date]
	Dim sql As String = "Select CustomerId,Name,Country,convert(varchar,CreatedDate,106) as CreatedDate from Dashboard WHERE createdDate between '" + [date] + "' AND '" + DateTime.Now.[Date] + "' "
	GetData(sql, gvmonthly)
	MultiView1.ActiveViewIndex = 2
	lnkTab1.ForeColor = Color.Blue
	lnkTab2.ForeColor = Color.Blue
	lnkTab3.ForeColor = Color.Red
End Sub

Screenshot