Hi Ratlin,
Refer the below code.
HTML
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title></title>
<style type="text/css">
.Grid td
{
background-color: #eee;
color: black;
font-family: Arial;
font-size: 10pt;
line-height: 200%;
cursor: pointer;
width: 100px;
}
.header
{
background-color: #6C6C6C !important;
color: White !important;
font-family: Arial;
font-size: 10pt;
line-height: 200%;
width: 100px;
text-align: center;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<asp:TextBox runat="server" ID="txtSearch" Text="Saraca" />
<asp:Button ID="Button1" Text="Search" runat="server" OnClick="OnSearch" />
<br />
<asp:GridView ID="GridView1" CssClass="Grid" HeaderStyle-CssClass="header" runat="server"
AutoGenerateColumns="true">
</asp:GridView>
<br />
<asp:Button ID="btnRowsToColumns" runat="server" Text="Convert Rows to Columns" OnClick="Convert"
CommandArgument="1" />
<asp:Button ID="btnColumnsToRows" runat="server" Text="Convert Columns to Rows" OnClick="Convert"
CommandArgument="2" Visible="false" />
</form>
</body>
</html>
Code
VB.Net
Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
If Not IsPostBack Then
Dim dt As New DataTable()
Dim strConnString As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
Using con As New SqlConnection(strConnString)
Using cmd As New SqlCommand("SELECT * FROM SampleTable")
Using sda As New SqlDataAdapter()
cmd.Connection = con
sda.SelectCommand = cmd
sda.Fill(dt)
End Using
End Using
End Using
ViewState("dt") = dt
BindGrid(dt, False)
End If
End Sub
Private Sub BindGrid(dt As DataTable, rotate As Boolean)
GridView1.ShowHeader = Not rotate
GridView1.DataSource = dt
GridView1.DataBind()
If rotate Then
For Each row As GridViewRow In GridView1.Rows
row.Cells(0).CssClass = "header"
Next
End If
End Sub
Protected Sub Convert(sender As Object, e As EventArgs)
Dim dt As DataTable = DirectCast(ViewState("dt"), DataTable)
If TryCast(sender, Button).CommandArgument = "1" Then
btnRowsToColumns.Visible = False
btnColumnsToRows.Visible = True
Dim dt2 As New DataTable()
For i As Integer = 0 To dt.Rows.Count
dt2.Columns.Add()
Next
For i As Integer = 0 To dt.Columns.Count - 1
dt2.Rows.Add()
dt2.Rows(i)(0) = dt.Columns(i).ColumnName
Next
For i As Integer = 0 To dt.Columns.Count - 1
For j As Integer = 0 To dt.Rows.Count - 1
dt2.Rows(i)(j + 1) = dt.Rows(j)(i)
Next
Next
BindGrid(dt2, True)
Else
btnRowsToColumns.Visible = True
btnColumnsToRows.Visible = False
BindGrid(dt, False)
End If
End Sub
Protected Sub OnSearch(sender As Object, e As EventArgs)
Dim dt As DataTable = DirectCast(ViewState("dt"), DataTable)
Dim dtFiltered As DataTable = dt.Clone()
Dim dataRow As DataRow() = dt.[Select]("Item='" + txtSearch.Text.Trim() + "'")
For Each dr As DataRow In dataRow
dtFiltered.Rows.Add(dr.ItemArray(0), dr.ItemArray(1), dr.ItemArray(2), dr.ItemArray(3))
Next
ViewState("dt") = dtFiltered
BindGrid(dtFiltered, False)
End Sub
C#
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt = new DataTable();
string strConnString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(strConnString))
{
using (SqlCommand cmd = new SqlCommand("SELECT * FROM SampleTable"))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
sda.Fill(dt);
}
}
}
ViewState["dt"] = dt;
BindGrid(dt, false);
}
}
private void BindGrid(DataTable dt, bool rotate)
{
GridView1.ShowHeader = !rotate;
GridView1.DataSource = dt;
GridView1.DataBind();
if (rotate)
{
foreach (GridViewRow row in GridView1.Rows)
{
row.Cells[0].CssClass = "header";
}
}
}
protected void Convert(object sender, EventArgs e)
{
DataTable dt = (DataTable)ViewState["dt"];
if ((sender as Button).CommandArgument == "1")
{
btnRowsToColumns.Visible = false;
btnColumnsToRows.Visible = true;
DataTable dt2 = new DataTable();
for (int i = 0; i <= dt.Rows.Count; i++)
{
dt2.Columns.Add();
}
for (int i = 0; i < dt.Columns.Count; i++)
{
dt2.Rows.Add();
dt2.Rows[i][0] = dt.Columns[i].ColumnName;
}
for (int i = 0; i < dt.Columns.Count; i++)
{
for (int j = 0; j < dt.Rows.Count; j++)
{
dt2.Rows[i][j + 1] = dt.Rows[j][i];
}
}
BindGrid(dt2, true);
}
else
{
btnRowsToColumns.Visible = true;
btnColumnsToRows.Visible = false;
BindGrid(dt, false);
}
}
protected void OnSearch(object sender, EventArgs e)
{
DataTable dt = (DataTable)ViewState["dt"];
DataTable dtFiltered = dt.Clone();
DataRow[] dataRow = dt.Select("Item='" + txtSearch.Text.Trim() + "'");
foreach (DataRow dr in dataRow)
{
dtFiltered.Rows.Add(dr.ItemArray[0], dr.ItemArray[1], dr.ItemArray[2], dr.ItemArray[3]);
}
ViewState["dt"] = dtFiltered;
BindGrid(dtFiltered, false);
}
