我正在尝试在这里搜索。如何在Datagridview中显示搜索值？ [英] I Am Trying To Do A Search Here. How Can I Show In the Datagridview The Searched Value?

问题描述

if(cbSearchByEmployee.SelectedItem.ToString() == "Username")
            {
                MySqlConnection con = new MySqlConnection("Server=localhost;UID=root;Database=db_cignal");
                con.Open();
                MySqlCommand command = new MySqlCommand();
                command.Connection = con;
                command.CommandText = "SELECT * FROM employee WHERE Username=@Username";
                command.Parameters.AddWithValue("@Username", txtSearchByEmployee.Text.ToUpper());
                command.Prepare();

                MySqlDataReader reader = command.ExecuteReader();
                
                while(reader.Read())
                {
                    String user = reader["Username"].ToString();
                    String pass = reader["Password"].ToString();
                    String first = reader["Firstname"].ToString();
                    String middle = reader["Middlename"].ToString();
                    String last = reader["Lastname"].ToString();
                    int age = Convert.ToInt32(reader["Age"].ToString());
                    String gender = reader["Gender"].ToString();
                    String position = reader["Position"].ToString();
                    int contact = Convert.ToInt32(reader["Contact"].ToString());
                    String email = reader["Email"].ToString();
                    String address = reader["Address"].ToString();

                    dataGridView1.Rows.Add(user, pass, first, middle, last, age, gender,position,contact, email, address);
                }
                reader.Close();
                con.Close();

推荐答案

参考文章：

1）带有搜索选项的ASP.NET GridView（SearchableGridView）

2）在带有搜索功能的GridView中显示大量数据

3）从DataBase搜索记录并使用ASP.Net C＃在Gridview中显示

首先，



使用类似过滤器的声明

Hi,


First,

use like Statement for Filter

command.CommandText = "SELECT * FROM employee WHERE Username like @Username +'%' ";

在旧案例中，只有当搜索文本与确切的用户名。



现在搜索过滤器用户名以您输入的文本开头





二，





而不是执行读卡器使用数据适配器

In Old Case you only get result when Search text match with exact user name.

Now Search filter Username Start with your Entered Text


Second,


Instead of Execute Reader Use Data Adapter

 command.Connection = con;
  command.CommandText = "SELECT * FROM employee WHERE Username=@Username";
  command.Parameters.AddWithValue("@Username", txtSearchByEmployee.Text.ToUpper());

DataTable dt = new DataTable();
 MySqlDataAdapter da = new MySqlDataAdapter(command);
 da.Fill(dt);

dataGridView1.DataSource = dt;
dataGridView1.DataBind();

谢谢



Siva Rm K

Thanks

Siva Rm K

这篇关于我正在尝试在这里搜索。如何在Datagridview中显示搜索值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！