How to use SqlDataSource with button on click to get results from gridview

Question

My overall goal is to be able to type in information into my textbox and click a button to search and get results from the database using gridview. So far I have my SqlDataSource SQL statement set up. I need to figure out how to link my button on click event with my SqlDataSource and Textbox.

Here is what I have so far:

 protected void Button1_Click(object sender, EventArgs e)
 {
     SqlConnection connection = new SqlConnection("Data Source=********;Initial Catalog=*******;User ID=*******;Password=*******");
     connection.Open();
 }

I am not sure how to use my SqlDataSource that I have already set up.

Updated Code:

SqlConnection sqlCon = new SqlConnection("*******");
        SqlDataAdapter dt = new SqlDataAdapter();
        DataSet ds = new DataSet();
        try
        {
            sqlCon.Open();
            dt.SelectCommand = new SqlCommand("SELECT* FROM  Core.Form_Section_SubSection_Item_Rel WHERE ([DataCollectionPeriodID] = @DataCollectionPeriodID)", sqlCon);
            dt.Fill(ds);
            sqlCon.Close();
            GridView1.DataBind();
        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
        }

Are you getting data with a stored procedure?

dansasu11
– dansasu11

2014-06-17 13:16:52 +00:00
Commented Jun 17, 2014 at 13:16 — dansasu11
– dansasu11, Commented Jun 17, 2014 at 13:16
@paabobo No Just a simple SQL select from where statement

user3339242
– user3339242

2014-06-17 13:22:14 +00:00
Commented Jun 17, 2014 at 13:22 — user3339242
– user3339242, Commented Jun 17, 2014 at 13:22

dansasu11 · Accepted Answer · 2014-06-17 15:05:15Z

1

I will advice you use are stored proc with a parameter and do something like below but you can change this to use your select query, just change commandtype

  using (SqlConnection sqlCon = new SqlConnection("connection string")) 
{ 

 using (SqlCommand cmd = new SqlCommand()) 
{ 
 sqlCon.Open(); 
 cmd.Connection = sqlCon; 
  cmd.CommandType = CommandType.Text; 
 cmd.CommandText = "SELECT* FROM Core.Form_Section_SubSection_Item_Rel WHERE         DataCollectionPeriodID = @DataCollectionPeriodID"; 
 cmd.CommandTimeout = 30; 
cmd.Parameters.Add("@DataCollectionPeriodID", SqlDbType.VarChar).Value = TextBox1.Text 
SqlDataAdapter dt = new SqlDataAdapter(cmd); 
DataSet ds = new DataSet(); 
 dt.Fill(ds); 

if (ds.Tables.Count > 0) 
{ 
 if (ds.Tables[0].Rows.Count > 0) 
 { 
 GridView1.DataSource = ds; 
  GridView1.DataBind(); 
 } 
} 
 } 
 }

edited Jun 17, 2014 at 15:05

answered Jun 17, 2014 at 13:28

dansasu11

9131 gold badge9 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

user3339242 Over a year ago

Ok so I changed it to use my selectquery but the gridview does not change.

dansasu11 Over a year ago

you didnt set gridview.DataSource = ds before doing gridview.DataBind

user3339242 Over a year ago

in my GridView property DataSourceID is already set and when I ran it it said DataSource and DataSourceID cannot be used at the same time.

dansasu11 Over a year ago

take the datasouceid out and just do the datasource

dansasu11 Over a year ago

Let us continue this discussion in chat.

|

Collectives™ on Stack Overflow

How to use SqlDataSource with button on click to get results from gridview

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related