从asp.net中的数据库搜索数据 [英] Search data from database in asp.net

问题描述

我有一个表，其中包含列名PNR和轨道ID.当我搜索pnr/trackid是否存在时，它将给我结果.如果pnr/trackid不存在，请给我一条消息.请给我代码.

========存储过程=============

I have a table it contain a column name PNR and track id. when i search a pnr/trackid if exist then it give me result.I want to giv a message if pnr/trackid doesnt exist.please give me code.

========Stored procedure==============

ALTER proc [dbo].[sp_SearchPnr]
@pnr varchar(50)= null
as
begin
declare @str varchar(50)
set @str=(select pnr_locator from flight_booking where pnr_locator=@pnr)
if(@str=@pnr)
begin
select pnr_locator,pax_fname,pax_lname,sector,departure_date,pax_mobile,track_id from flight_booking where pnr_locator like ISNULL(@pnr,'%')
end
else
begin
select pnr_locator,pax_fname,pax_lname,sector,departure_date,pax_mobile,track_id from flight_booking where track_id like ISNULL(@pnr,'%')
end
end

======== search_click ===========

========search_click============

Protected Sub btnSearch_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSearch.Click
        Dim pnr As String = ""


        Try
            If txtPnr.Text <> "" Then
                pnr = txtPnr.Text.Trim()
            End If
            Dim adap As New SqlDataAdapter("sp_SearchPnr", con)
            adap.SelectCommand.CommandType = CommandType.StoredProcedure
            adap.SelectCommand.Parameters.AddWithValue("@pnr", pnr)
            Dim ds As New DataSet
            ds = New DataSet()
            adap.Fill(ds)
            GVResultPnr.DataSource = ds
            GVResultPnr.DataBind()
        Catch ex As Exception
        End Try



    End Sub

推荐答案

如果只有一个表，则不需要数据集.使用数据表.

A DataSet is unnecessary if you only have one table. Use a DataTable.

if(datatable.Rows.Count == 0 )
{
  //Show message
}
else
{
  // Do something else
}

如果您想一想，真的不是太困难.

Really not too difficult if you think just a bit.

这篇关于从asp.net中的数据库搜索数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！