Button column select!

• • Reply

  13 years ago

  by nclauder

  Ndayahundwa Claude

  , Uganda

  Joined 14 years ago

  Hi all,
  I have a datagrid with Button column select in form of hyperlink. On the same page, I have another datagrid that insert data and one column(Name) has Names of a user that is inserting data(using windows authentication). 
  Now this is how it's supposed to work: When any user want to see data about a particular user it's a matter of selecting his name and the data Writen by the selected user should be the only ones to be shown.
  I got some examples on Google but they all seem not to be working. When a user is selected the page remains the same data is not selected. How would can I solve this problem?
  My code looks like this:
  HTML part:
  <Columns>
  <asp:ButtonColumn HeaderText="Operations" DataTextField="TeamOperation" ButtonType="LinkButton"></asp:ButtonColumn>
  </Columns>
  and code behind:
  private void dgoperation_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
  SqlCommand myCommand=new SqlCommand();
  myCommand.Connection=con;
  myCommand.CommandText="select * from dbo.DashBoard where Name = @Billing";     
  myCommand.Parameters.Add(new SqlParameter("@Billing",SqlDbType.VarChar,50));
  myCommand.Parameters["@Billing"].Value= dgbilling;
  SqlDataAdapter myAdapter=new SqlDataAdapter(myCommand);
  DataSet ds = new DataSet();
  myAdapter.Fill(ds);   
  dgis.DataSource=ds; 
  dgis.EditItemIndex = -1;
  dgis.DataBind();
  }
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  

  dgis: this is the datagrid that where user inserts data.
  dgbilling: this is the datagrid with the name list.
  Thanks.
  
  
  
  

  Report abuse
• • Reply

  13 years ago

  by chezhian_in05

  chezhian

  chennai, India

  Joined 15 years ago

  hi check this url

  u can find the working example witht the code of it.

  http://quickstarts.asp.net/QuickStartv20/aspnet/Default.aspx

  Report abuse