Hi ucrhlyn,
Check this sample. now take its reference.
Database
For this example I have used of Northwind database that you can download using the link given below.
Download Northwind Database
HTML
Search Order :
<asp:TextBox ID="txtSearchOrder" runat="server" />
<asp:Button ID="btnSearch" Text="Search" runat="server" OnClick="OnSearch" /><br /><br />
<asp:Repeater ID="rptCustomers" runat="server">
<HeaderTemplate>
<table>
<tr>
<th></th>
<th>Order ID</th>
<th>Customer ID</th>
<th>Price</th>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td>Order Date</td>
<td><asp:Label ID="Label1" Text='<%# Eval("OrderDate","{0: dd/MM/yyyy}") %>' runat="server" /></td>
</tr>
<tr>
<td></td>
<td><asp:Label ID="lblOrderID" Text='<%# Eval("OrderID") %>' runat="server" /></td>
<td><asp:Label ID="lblCustomerID" Text='<%# Eval("CustomerID") %>' runat="server" /></td>
<td><asp:Label ID="lblPrice" Text='<%# Eval("Freight","{0:N2}") %>' runat="server" /></td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
Namespaces
C#
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
VB.Net
Imports System.Configuration
Imports System.Data
Imports System.Data.SqlClient
Code
C#
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
this.BindOrders(txtSearchOrder.Text.Trim());
}
}
protected void OnSearch(object sender, EventArgs e)
{
this.BindOrders(txtSearchOrder.Text.Trim());
}
private void BindOrders(string orderID)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("SELECT TOP 5 OrderID,CustomerID,OrderDate,Freight FROM Orders WHERE CustomerID=@CustomerID OR @CustomerID IS NULL GROUP BY OrderDate,OrderID,CustomerID,Freight", con))
{
cmd.CommandType = CommandType.Text;
if (!string.IsNullOrEmpty(orderID))
{
cmd.Parameters.AddWithValue("@CustomerID", orderID);
}
else
{
cmd.Parameters.AddWithValue("@CustomerID", DBNull.Value);
}
con.Open();
this.rptCustomers.DataSource = cmd.ExecuteReader();
this.rptCustomers.DataBind();
con.Close();
}
}
}
VB.Net
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
If Not Me.IsPostBack Then
Me.BindOrders(txtSearchOrder.Text.Trim())
End If
End Sub
Protected Sub OnSearch(ByVal sender As Object, ByVal e As EventArgs)
Me.BindOrders(txtSearchOrder.Text.Trim())
End Sub
Private Sub BindOrders(ByVal orderID As String)
Using con As SqlConnection = New SqlConnection(ConfigurationManager.ConnectionStrings("constr").ConnectionString)
Using cmd As SqlCommand = New SqlCommand("SELECT TOP 5 OrderID,CustomerID,OrderDate,Freight FROM Orders WHERE CustomerID=@CustomerID OR @CustomerID IS NULL GROUP BY OrderDate,OrderID,CustomerID,Freight", con)
cmd.CommandType = CommandType.Text
If Not String.IsNullOrEmpty(orderID) Then
cmd.Parameters.AddWithValue("@CustomerID", orderID)
Else
cmd.Parameters.AddWithValue("@CustomerID", DBNull.Value)
End If
con.Open()
Me.rptCustomers.DataSource = cmd.ExecuteReader()
Me.rptCustomers.DataBind()
con.Close()
End Using
End Using
End Sub
Screenshot
