为datagridview绑定数据

 

 private void BangDing()
        {
            string id = this.Tag.ToString();
            string sql = string.Format("select createtime,content,yingmoney,zhekou,shishou from info where userid = {0}",id);
            da = new SqlDataAdapter(sql, new SqlHelper().conn);
            ds = new DataSet();
            da.Fill(ds, "info");
            this.dataGridView1.DataSource = ds.Tables["info"];
            dataGridView1.Columns["createtime"].HeaderText = "消费时间";
            dataGridView1.Columns["content"].HeaderText = "消费项目";
            dataGridView1.Columns["yingmoney"].HeaderText = "应收金额";
            dataGridView1.Columns["zhekou"].HeaderText = "应打折扣";
            dataGridView1.Columns["shishou"].HeaderText = "实收金额";
            dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;  ///根据数据内容自动调整列宽   
            dataGridView1.ReadOnly = true; //dataGridView1不能修改数据
            
        }