Display search result in ASP.Net GridView inside Bootstrap Modal Popup using C# and VB.Net

Hi Aauniverse,

Check this example. Now please take its reference and correct your code.

Database

For this sample I have used of Northwind database that you can download using the link given below.

Download Northwind Database

HTML

<div>
    <link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.2/css/bootstrap.min.css" />
    <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script>
    <script type="text/javascript" src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.2/js/bootstrap.min.js"></script>
    <script type='text/javascript'>
        function OpenModal() {
            $('[id*=myModal]').modal('show');
        }
    </script>
    <asp:TextBox runat="server" ID="txtSearch" CssClass="form-control" />
    <asp:Button Text="Search" runat="server" OnClick="Search" CssClass="btn btn-default" />
    <div class="modal fade" id="myModal" role="dialog">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span></button>
                    <h4 class="modal-title">
                        Search result</h4>
                </div>
                <div class="modal-body">
                    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" CssClass="table table-responsive">
                        <Columns>
                            <asp:BoundField DataField="CustomerID" HeaderText="ID" />
                            <asp:BoundField DataField="ContactName" HeaderText="Name" />
                            <asp:BoundField DataField="Country" HeaderText="Country" />
                        </Columns>
                    </asp:GridView>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-default" data-dismiss="modal">
                        Close</button>
                </div>
            </div>
        </div>
    </div>
</div>

Namespaces

C#

using System.Configuration;
using System.Data.SqlClient;
using System.Data;

VB.Net

Imports System.Data.SqlClient
Imports System.Data

Code

C#

protected void Search(object sender, EventArgs e)
{
    string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
    string query = "SELECT TOP 5 CustomerID,ContactName,Country FROM Customers";
    if (!string.IsNullOrEmpty(txtSearch.Text.Trim()))
    {
        query += string.Format(" WHERE Country = '{0}'", txtSearch.Text.Trim());
    }
    SqlCommand cmd = new SqlCommand(query);
    using (SqlConnection con = new SqlConnection(conString))
    {
        using (SqlDataAdapter sda = new SqlDataAdapter())
        {
            cmd.Connection = con;
            sda.SelectCommand = cmd;
            using (DataSet ds = new DataSet())
            {
                sda.Fill(ds);
                GridView1.DataSource = ds;
                GridView1.DataBind();
            }
        }
    }
    ClientScript.RegisterStartupScript(this.GetType(), "Pop", "OpenModal();", true);
}

VB.Net

Protected Sub Search(ByVal sender As Object, ByVal e As EventArgs)
    Dim conString As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
    Dim query As String = "SELECT TOP 5 CustomerID,ContactName,Country FROM Customers"
    If Not String.IsNullOrEmpty(txtSearch.Text.Trim()) Then
        query += String.Format(" WHERE Country = '{0}'", txtSearch.Text.Trim())
    End If
    Dim cmd As SqlCommand = New SqlCommand(query)
    Using con As SqlConnection = New SqlConnection(conString)
        Using sda As SqlDataAdapter = New SqlDataAdapter()
            cmd.Connection = con
            sda.SelectCommand = cmd
            Using ds As DataSet = New DataSet()
                sda.Fill(ds)
                GridView1.DataSource = ds
                GridView1.DataBind()
            End Using
        End Using
    End Using
    ClientScript.RegisterStartupScript(Me.[GetType](), "Pop", "OpenModal();", True)
End Sub

Screenshot