current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

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);
        }
share|improve this question
    
Are you getting data with a stored procedure? –  dansasu11 Jun 17 at 13:16
    
@paabobo No Just a simple SQL select from where statement –  user3339242 Jun 17 at 13:22

1 Answer 1

up vote 1 down vote accepted

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(); 
 } 
} 
 } 
 }
share|improve this answer
    
Ok so I changed it to use my selectquery but the gridview does not change. –  user3339242 Jun 17 at 13:58
1  
Can you post your code? –  dansasu11 Jun 17 at 13:58
1  
you didnt set gridview.DataSource = ds before doing gridview.DataBind –  dansasu11 Jun 17 at 14:03
1  
take the datasouceid out and just do the datasource –  dansasu11 Jun 17 at 14:07
1  
Let us continue this discussion in chat. –  dansasu11 Jun 17 at 14:13

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.