如何从asp.net中的文本框搜索数据库 [英] how to search database from textbox in asp.net

问题描述

向我发送代码以搜索数据库中文本框中给出的项目
前端asp.net
后端Sql server2008
IDE visual studio

send me the code to search a item which is given in textbox in a database
frontend asp.net
backend Sql server2008
IDE visual studio

推荐答案

CREATE TABLE [dbo].[StateMaster](
	[StateIdfr] [bigint] IDENTITY(1,1) NOT NULL,
	[StateName] [varchar](50) NULL
) 

使用网格为前端的文本框和按钮编写代码

Write Code for Textbox and Button in Front End with a Grid

Sub BindGrid()
        Dim dt As New DataTable
        dt = Obj.GetStateDetails(txtSearch.Text.Trim)
        If dt.Rows.Count > 0 Then

            dgdState.DataSource = dt
            dgdState.DataBind()

        Else
            lblMsg.Text = "No Records"
            dgdState.DataSource = Nothing
            dgdState.DataBind()
        End If
    End Sub

单击搜索按钮时，调用上述Bindgrid函数

---

函数类

Call the Above Bindgrid function when Click Search Button

---

Function Class

Public Function GetStateDetails(ByVal StateName As String) As DataTable

 Dim dt As New DataTable
        Dim da As New SqlDataAdapter("Select StateIdfr,StateName, from StateMaster where StateName='%" & StateName & "", Con)
        da.Fill(dt)
        Return dt

End Function

我们不在这里给你代码.

您需要在Asp.net和Ado.net上学习东西，您可以从以下内容开始:

为初学者使用ADO.NET [初学者ASP.NET简介 [

We are not here to give you code.

You need to learn stuffs on Asp.net and Ado.net, you can start from these:

Using ADO.NET for beginners[^]

Beginners Introduction to ASP.NET[^]

受保护的无效btnSearchGrid_Click(对象发送者，EventArgs e)
{
如果(txtnamesearch.Text ==")
{
Label7.ForeColor = Color.Red;
Label7.Text =请输入学校名称以进行搜索";
}
其他
{
字符串模式="G";
pr.Mode =模式;
pr.SchoolName = txtnamesearch.Text;
dt = new DataTable();
dt = logic.GetAlldetails(pr);
如果(dt.Rows.Count> 0)
{
GridView1.DataSource = dt;
GridView1.DataBind();
Label7.ForeColor = Color.Green;
Label7.Text =已成功搜索"；
}
其他
{
字符串Mode1 ="G";
pr.Mode =模式1;
pr.SchoolName = txtnamesearch.Text;
dt = new DataTable();
dt = logic.GetAlldetails(pr);
如果(dt.Rows.Count == 0)
{
GridView1.DataSource = dt;
//GridView1.Dispose();
GridView1.DataBind();

}
Label7.ForeColor = Color.Red;
Label7.Text =不存在您搜索的名称:::";
}
}
}


尝试此代码

再见

protected void btnSearchGrid_Click(object sender, EventArgs e)
{
if (txtnamesearch.Text == "")
{
Label7.ForeColor = Color.Red;
Label7.Text = "Plz Enter SchoolName to Search";
}
else
{
string Mode = "G";
pr.Mode = Mode;
pr.SchoolName = txtnamesearch.Text;
dt = new DataTable();
dt = logic.GetAlldetails(pr);
if (dt.Rows.Count > 0)
{
GridView1.DataSource = dt;
GridView1.DataBind();
Label7.ForeColor = Color.Green;
Label7.Text = "Searched Sucessfully";
}
else
{
string Mode1 = "G";
pr.Mode = Mode1;
pr.SchoolName = txtnamesearch.Text;
dt = new DataTable();
dt = logic.GetAlldetails(pr);
if (dt.Rows.Count == 0)
{
GridView1.DataSource = dt;
//GridView1.Dispose();
GridView1.DataBind();

}
Label7.ForeColor = Color.Red;
Label7.Text = "The Name Your Searching DoesNot Exist:::";
}
}
}


Try this Code

Bye

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