从数据库中搜索数据 [英] search data from database

问题描述

你好先生，

i有2个文本框和一个按钮用于搜索.....

在我的数据库中alrady有记录，但我想在我填写搜索时searchButton上的文本框和点击按钮然后我的所有相关数据将显示在gridView ......

请帮助...

解决方案

你可以尝试这个..



<前lang =c＃> 受保护 void btnSearch_Click（ object sender，EventArgs e）
{
SqlConnection conn = new SqlConnection（ YourConnection）;
SqlCommand cmd = new SqlCommand（）;
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = sp_Search;
cmd.Parameters.AddWithValue（ @ TEXTBOX1，TextBox1.Text）;
cmd.Parameters.AddWithValue（ @ TEXTBOX2，TextBox2.Text）;
cmd.ExecuteNonQuery（）;
DataTable dt = new DataTable（）;
SqlDataAdapter da = new SqlDataAdapter（cmd）;
da.Fill（dt）;
gvYourGrid.DataSource = dt;
gvYourGrid.DataBind（）;
}

然后在你的SQL中创建这样的存储过程

  CREATE  程序 [dbo]。[sp_Search] 
  @ TEXTBOX1   AS   VARCHAR  （ 100 ），
  @ TEXTBOX2   AS   VARCHAR （ 100 ）
  AS  
  BEGIN  
  SELECT  *  FROM  YourTable  WHERE  YourColumn1 =  @ TEXTBOX1  和 YourColumn2 =  @ TEXTBOX2  
  END  

读一读为初学者使用ADO.NET [ ^ ]

你需要处理按钮的click事件和用数据库查询写的方法...





希望，这会对你有帮助..

hello sir,
i have 2 textbox and one button for Search.....
in my database alrady have record but i want to when i fill search in textbox and click button on searchButton then my all releted data will show in gridView......
please help...

解决方案

You could try this..

protected void btnSearch_Click(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection("YourConnection");
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = conn;
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.CommandText = "sp_Search";
        cmd.Parameters.AddWithValue("@TEXTBOX1", TextBox1.Text);
        cmd.Parameters.AddWithValue("@TEXTBOX2", TextBox2.Text);
        cmd.ExecuteNonQuery();
        DataTable dt = new DataTable();
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        da.Fill(dt);
        gvYourGrid.DataSource = dt;
        gvYourGrid.DataBind();
    }

And then create a stored procedure like this in your SQL

CREATE PROCEDURE [dbo].[sp_Search]
	@TEXTBOX1 AS VARCHAR(100),
	@TEXTBOX2 AS VARCHAR(100)
AS
BEGIN
	SELECT * FROM YourTable WHERE YourColumn1 = @TEXTBOX1 and YourColumn2 = @TEXTBOX2
END

Have a read of this Using ADO.NET for beginners[^]

U need to handle the click Event of button and and write method with database query...


Hope, this will help you..

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