此代码搜索但在我搜索时在Datagridview中创建新列 [英] This Code Search But Make New Column In Datagridview When I Search

问题描述

using(SqlConnection con = new SqlConnection(cs.Dbcon))
              {
              string sql ="SELECT ClassName FROM Class where ClassName Like'%" + TxtSearch.Text + "%' ";
              using (SqlDataAdapter ada = new SqlDataAdapter(sql,con))
              {
                  using (DataTable dt = new DataTable())
                  {
                      con.Open();
                      ada.Fill(dt);

                      dataGridView1.DataSource = dt;
                      con.Close();

                  }


              }

              }

推荐答案

尝试

ada.Fill(dt);

dataGridView1.DataSource = null;
dataGridView1.Columns.Clear();

dataGridView1.DataSource = dt;
con.Close();

目前无法测试它但你可能实际上并不需要这些额外的代码行......试一试，看看会发生什么。

Can't test it at the moment but you might not actually need both of those extra lines of code ... give it a try and see what happens.

这篇关于此代码搜索但在我搜索时在Datagridview中创建新列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！