Column Width in a Gridview

[=?Utf-8?B?SGVsZW4gVHJpbQ==?=]

How can I change the column width in a gridview filled with a dataset? I
can't get TableStyle to work. Has anyone any sample code, please?

Thanks,
Helen

PS. I am creating a web page in ASP.Net 2.0 using C#.

This is my code so far:

SqlConnection cn; // Connection to the SQL database
SqlDataAdapter da;
DataSet ds;

cn = new SqlConnection();
da=new SqlDataAdapter("Select * From Patient",cn);
ds = new DataSet();

OpenConnection(cn); // Connects to the database
da.Fill(ds,"PatientTable");
dgPatients.DataSource = ds.Tables["PatientTable"];
dgPatients.DataBind();
cn.Close();

[marss]

Helen Trim wrote:

How can I change the column width in a gridview filled with a dataset? I
can't get TableStyle to work. Has anyone any sample code, please?

Thanks,
Helen

PS. I am creating a web page in ASP.Net 2.0 using C#.

This is my code so far:

SqlConnection cn; // Connection to the SQL database
SqlDataAdapter da;
DataSet ds;

cn = new SqlConnection();
da=new SqlDataAdapter("Select * From Patient",cn);
ds = new DataSet();

OpenConnection(cn); // Connects to the database
da.Fill(ds,"PatientTable");
dgPatients.DataSource = ds.Tables["PatientTable"];
dgPatients.DataBind();

Hi,
Add event handler for the RowCreated event:

.... OnRowCreated="GridView1_RowCreated" ...

protected void GridView1_RowCreated(object sender,
GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Header)
{
for (int i = 0; i < e.Row.Cells.Count; i++)
{
DataControlFieldCell cell =
(DataControlFieldCell)e.Row.Cells[i];
//here add custom logic of column width settings, for example:
//if (cell.ContainingField.HeaderText == "Id")
// e.Row.Cells[i].Width = new Unit("100px");
}
}
}

cn.Close();