Load the information in Grid View from SQL

I need to load the database values into the grid view by checking the attribute "id".

If the id value which 开发者_如何学CI entered is equal to database, then it'll load in the grid view.

Help me to do that

---

You have to loop through the records on the backend and parse out the records you don't want to show before you bind to the gridview; it's much easier that way.

HTH.

---

You might want to try to add this to the code-behind module

void Page_load(object sender, EventArgs e)      
{                                   
  if (!Page.IsPostBack)
  {
     CreateGrid();          
  }     
}

void CreateGrid()
{
  DataSet ds = new DataSet(); 
  string str = "select * from Personal where id='" + TextBox1.Text + "'"; 

  SqlDataAdapter da = new SqlDataAdapter(str, con); 

  da.Fill(ds, "Personal"); 

  GridView1.DataSource = ds.Tables["Personal"].DefaultView; 
  GridView1.DataBind(); 
}