title: asp.net bind a gridview and change its style
body: <p>i have a gridview which is binded to a table in sql server . i wrote a c# code at code behind i.e :</p>
  
  <pre><code>    protected void Page_Load(object sender, EventArgs e)
      {
          SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["myconectionstring"].ConnectionString);
          SqlCommand cmd = new SqlCommand("select fldCompany,fldModel 'مدل',fldYear 'سال',fldPrice 'قیمت',fldCountPhoto  'تعداد عکس',fldActive  'موقعیت نمایش' from tbl_Usercar where fldTbl_UserID =@fldTbl_UserID", con);
          cmd.Parameters.AddWithValue("@fldTbl_UserID", Session["se_userID"] as string);
          SqlDataAdapter da = new SqlDataAdapter(cmd);
          DataSet ds = new DataSet();
  
           da.Fill(ds);
  
          GridView1.DataSource=ds;
  
           GridView1.DataBind();
  
  
      }
  </code></pre>
  
  <p>now my table appear as i want to but i cant change my gridview style Eg i can't change the Columns color or font and etc . i tried to use my datasource and make  attribute in my asp page but it will show each Columns 2 times . </p>
  
  <p>please help me to fix this problem . Thank you</p>