Text Alignment In DataGrid?

[Arpan]

Assume that a database table has the following 4 columns - ID, UserID,
Subject & Marks. I am retrieving the records existing in this DB table
& displaying them in a DataGrid like this:

<script runat="server">
Sub Page_Load(obj As Object, ea As EventArgs)
Dim dSet As DataSet
Dim sqlConn As SqlConnection
Dim sqlDapter As SqlDataAdapter

sqlConn = New SqlConnection(" ........")
sqlDapter = New SqlDataAdapter( "SELECT * FROM tblMarks",
sqlConn)
dSet = New DataSet

sqlDapter.Fill( dSet, "Marks")

dgMarks.DataSou rce = dSet
dgMarks.DataBin d()
End Sub
</script>
<form eunat="server">
<asp:DataGrid ID="dgMarks" HeaderStyle-Font-Bold="true"
HeaderStyle-HorizontalAlign ="center" runat="server"/>
</form>

The above will retrieve & display all the records existing in the 4
columns in the DataGrid. By default all the records in the different
cells in the DataGrid will be left-aligned. Now I want only the records
existing under the ID column to be right-aligned & the records existing
under the Marks column to be center-aligned. The records under UserID &
Subject columns should remain left-aligned.

How do I accomplish this?

Thanks,

Arpan

[John Timney \(MVP\)]

off the top of my head in your load event after binding its something like:

dgMarks.Columns (0).ItemStyle.H orizontalAlign= HorizontalAlign .Center

or declared it would probably be something like this
<ItemStyle Width="150px" VerticalAlign=" middle" HorizontalAlign ="right" />

You might have to pick it apart a bit, its not tested.
--
--
Regards

John Timney (MVP)
"Arpan" <ar******@hotma il.comwrote in message
news:11******** *************@i 42g2000cwa.goog legroups.com...

Assume that a database table has the following 4 columns - ID, UserID,
Subject & Marks. I am retrieving the records existing in this DB table
& displaying them in a DataGrid like this:

<script runat="server">
Sub Page_Load(obj As Object, ea As EventArgs)
Dim dSet As DataSet
Dim sqlConn As SqlConnection
Dim sqlDapter As SqlDataAdapter

sqlConn = New SqlConnection(" ........")
sqlDapter = New SqlDataAdapter( "SELECT * FROM tblMarks",
sqlConn)
dSet = New DataSet

sqlDapter.Fill( dSet, "Marks")

dgMarks.DataSou rce = dSet
dgMarks.DataBin d()
End Sub
</script>
<form eunat="server">
<asp:DataGrid ID="dgMarks" HeaderStyle-Font-Bold="true"
HeaderStyle-HorizontalAlign ="center" runat="server"/>
</form>

The above will retrieve & display all the records existing in the 4
columns in the DataGrid. By default all the records in the different
cells in the DataGrid will be left-aligned. Now I want only the records
existing under the ID column to be right-aligned & the records existing
under the Marks column to be center-aligned. The records under UserID &
Subject columns should remain left-aligned.

How do I accomplish this?

Thanks,

Arpan

[David Wier]

Any formatting can be done through the style sections -
ItemStyle/HeaderStyle/FooterStyle, etc - with the actual records, you'd use
ItemStyle-HorizontalAlign ="right"

--
David Wier
MVP/ASPInsider
http://aspnet101.com
http://aspexpress.com
"Arpan" <ar******@hotma il.comwrote in message
news:11******** *************@i 42g2000cwa.goog legroups.com...

Assume that a database table has the following 4 columns - ID, UserID,
Subject & Marks. I am retrieving the records existing in this DB table
& displaying them in a DataGrid like this:

<script runat="server">
Sub Page_Load(obj As Object, ea As EventArgs)
Dim dSet As DataSet
Dim sqlConn As SqlConnection
Dim sqlDapter As SqlDataAdapter

sqlConn = New SqlConnection(" ........")
sqlDapter = New SqlDataAdapter( "SELECT * FROM tblMarks",
sqlConn)
dSet = New DataSet

sqlDapter.Fill( dSet, "Marks")

dgMarks.DataSou rce = dSet
dgMarks.DataBin d()
End Sub
</script>
<form eunat="server">
<asp:DataGrid ID="dgMarks" HeaderStyle-Font-Bold="true"
HeaderStyle-HorizontalAlign ="center" runat="server"/>
</form>

The above will retrieve & display all the records existing in the 4
columns in the DataGrid. By default all the records in the different
cells in the DataGrid will be left-aligned. Now I want only the records
existing under the ID column to be right-aligned & the records existing
under the Marks column to be center-aligned. The records under UserID &
Subject columns should remain left-aligned.

How do I accomplish this?

Thanks,

Arpan

[Arpan]

David, could you please show me an example of formatting using the
style sections?

Arpan
David Wier wrote:

Any formatting can be done through the style sections -
ItemStyle/HeaderStyle/FooterStyle, etc - with the actual records, you'd use
ItemStyle-HorizontalAlign ="right"

--
David Wier
MVP/ASPInsider
http://aspnet101.com
http://aspexpress.com
"Arpan" <ar******@hotma il.comwrote in message
news:11******** *************@i 42g2000cwa.goog legroups.com...

Assume that a database table has the following 4 columns - ID, UserID,
Subject & Marks. I am retrieving the records existing in this DB table
& displaying them in a DataGrid like this:

<script runat="server">
Sub Page_Load(obj As Object, ea As EventArgs)
Dim dSet As DataSet
Dim sqlConn As SqlConnection
Dim sqlDapter As SqlDataAdapter

sqlConn = New SqlConnection(" ........")
sqlDapter = New SqlDataAdapter( "SELECT * FROM tblMarks",
sqlConn)
dSet = New DataSet

sqlDapter.Fill( dSet, "Marks")

dgMarks.DataSou rce = dSet
dgMarks.DataBin d()
End Sub
</script>
<form eunat="server">
<asp:DataGrid ID="dgMarks" HeaderStyle-Font-Bold="true"
HeaderStyle-HorizontalAlign ="center" runat="server"/>
</form>

The above will retrieve & display all the records existing in the 4
columns in the DataGrid. By default all the records in the different
cells in the DataGrid will be left-aligned. Now I want only the records
existing under the ID column to be right-aligned & the records existing
under the Marks column to be center-aligned. The records under UserID &
Subject columns should remain left-aligned.

How do I accomplish this?

Thanks,

Arpan

[Arpan]

John, using

dgMarks.Columns (0).ItemStyle.H orizontalAlign = HorizontalAlign .Right

after binding the data to the DataGrid generates the following error:

Index was out of range. Must be non-negative and less than the size of
the collection.
Parameter name: index

pointing to the above line. Even the code

Response.Write( dgMarks.Columns .Count)

evaluates to 0! If the ItemStyle line is removed, then I can see the
DataGrid displaying the 4 columns - ID, UserID, Subject & Marks. So how
come the Columns count property evaluates to 0?

Thanks,

Regards,

Arpan

John Timney (MVP) wrote:

off the top of my head in your load event after binding its something like:

dgMarks.Columns (0).ItemStyle.H orizontalAlign= HorizontalAlign .Center

or declared it would probably be something like this
<ItemStyle Width="150px" VerticalAlign=" middle" HorizontalAlign ="right" />

You might have to pick it apart a bit, its not tested.
--
--
Regards

John Timney (MVP)
"Arpan" <ar******@hotma il.comwrote in message
news:11******** *************@i 42g2000cwa.goog legroups.com...

Assume that a database table has the following 4 columns - ID, UserID,
Subject & Marks. I am retrieving the records existing in this DB table
& displaying them in a DataGrid like this:

<script runat="server">
Sub Page_Load(obj As Object, ea As EventArgs)
Dim dSet As DataSet
Dim sqlConn As SqlConnection
Dim sqlDapter As SqlDataAdapter

sqlConn = New SqlConnection(" ........")
sqlDapter = New SqlDataAdapter( "SELECT * FROM tblMarks",
sqlConn)
dSet = New DataSet

sqlDapter.Fill( dSet, "Marks")

dgMarks.DataSou rce = dSet
dgMarks.DataBin d()
End Sub
</script>
<form eunat="server">
<asp:DataGrid ID="dgMarks" HeaderStyle-Font-Bold="true"
HeaderStyle-HorizontalAlign ="center" runat="server"/>
</form>

The above will retrieve & display all the records existing in the 4
columns in the DataGrid. By default all the records in the different
cells in the DataGrid will be left-aligned. Now I want only the records
existing under the ID column to be right-aligned & the records existing
under the Marks column to be center-aligned. The records under UserID &
Subject columns should remain left-aligned.

How do I accomplish this?

Thanks,

Arpan

[John Timney \(MVP\)]

Sorry Arpan,

I dont have a working environment in front of me. Here are a couple of
links that will help you get your example working by declaring the
<ItemStyle>

http://msdn2.microsoft.com/en-us/lib...itemstyle.aspx
http://msdn2.microsoft.com/en-us/lib...d.columns.aspx

Either way, you'll likely need to set the columns up for either approach to
work.
--
--
Regards

John Timney (MVP)
"Arpan" <ar******@hotma il.comwrote in message
news:11******** *************@m 73g2000cwd.goog legroups.com...

John, using

dgMarks.Columns (0).ItemStyle.H orizontalAlign = HorizontalAlign .Right

after binding the data to the DataGrid generates the following error:

Index was out of range. Must be non-negative and less than the size of
the collection.
Parameter name: index

pointing to the above line. Even the code

Response.Write( dgMarks.Columns .Count)

evaluates to 0! If the ItemStyle line is removed, then I can see the
DataGrid displaying the 4 columns - ID, UserID, Subject & Marks. So how
come the Columns count property evaluates to 0?

Thanks,

Regards,

Arpan

John Timney (MVP) wrote:

>off the top of my head in your load event after binding its something
like:

dgMarks.Column s(0).ItemStyle. HorizontalAlign =HorizontalAlig n.Center

or declared it would probably be something like this
<ItemStyle Width="150px" VerticalAlign=" middle" HorizontalAlign ="right"
/>

You might have to pick it apart a bit, its not tested.
--
--
Regards

John Timney (MVP)
"Arpan" <ar******@hotma il.comwrote in message
news:11******* **************@ i42g2000cwa.goo glegroups.com.. .

Assume that a database table has the following 4 columns - ID, UserID,
Subject & Marks. I am retrieving the records existing in this DB table
& displaying them in a DataGrid like this:

<script runat="server">
Sub Page_Load(obj As Object, ea As EventArgs)
Dim dSet As DataSet
Dim sqlConn As SqlConnection
Dim sqlDapter As SqlDataAdapter

sqlConn = New SqlConnection(" ........")
sqlDapter = New SqlDataAdapter( "SELECT * FROM tblMarks",
sqlConn)
dSet = New DataSet

sqlDapter.Fill( dSet, "Marks")

dgMarks.DataSou rce = dSet
dgMarks.DataBin d()
End Sub
</script>
<form eunat="server">
<asp:DataGrid ID="dgMarks" HeaderStyle-Font-Bold="true"
HeaderStyle-HorizontalAlign ="center" runat="server"/>
</form>

The above will retrieve & display all the records existing in the 4
columns in the DataGrid. By default all the records in the different
cells in the DataGrid will be left-aligned. Now I want only the records
existing under the ID column to be right-aligned & the records existing
under the Marks column to be center-aligned. The records under UserID &
Subject columns should remain left-aligned.

How do I accomplish this?

Thanks,

Arpan

[Arpan]

John, the problem in the code that I have shown in post #1 doesn't use
the <Columnscollect ion to populate the DataGrid i.e. the 4 columns
displayed in the DataGrid are generated automatically which why the
Columns count property evaluates to 0 but the examples shown in the 2
URLs you have referred use the <Columnscollect ion (like BoundColumn,
ButtonColumn, TemplateColumn) explicitly to render the DataGrid. They
don't show how to format records under auto-generated columns.

Arpan
John Timney (MVP) wrote:

Sorry Arpan,

I dont have a working environment in front of me. Here are a couple of
links that will help you get your example working by declaring the
<ItemStyle>

http://msdn2.microsoft.com/en-us/lib...itemstyle.aspx
http://msdn2.microsoft.com/en-us/lib...d.columns.aspx

Either way, you'll likely need to set the columns up for either approach to
work.
--
--
Regards

John Timney (MVP)
"Arpan" <ar******@hotma il.comwrote in message
news:11******** *************@m 73g2000cwd.goog legroups.com...

John, using

dgMarks.Columns (0).ItemStyle.H orizontalAlign = HorizontalAlign .Right

after binding the data to the DataGrid generates the following error:

Index was out of range. Must be non-negative and less than the size of
the collection.
Parameter name: index

pointing to the above line. Even the code

Response.Write( dgMarks.Columns .Count)

evaluates to 0! If the ItemStyle line is removed, then I can see the
DataGrid displaying the 4 columns - ID, UserID, Subject & Marks. So how
come the Columns count property evaluates to 0?

Thanks,

Regards,

Arpan

John Timney (MVP) wrote:

off the top of my head in your load event after binding its something
like:

dgMarks.Columns (0).ItemStyle.H orizontalAlign= HorizontalAlign .Center

or declared it would probably be something like this
<ItemStyle Width="150px" VerticalAlign=" middle" HorizontalAlign ="right"
/>

You might have to pick it apart a bit, its not tested.
--
--
Regards

John Timney (MVP)
"Arpan" <ar******@hotma il.comwrote in message
news:11******** *************@i 42g2000cwa.goog legroups.com...
Assume that a database table has the following 4 columns - ID, UserID,
Subject & Marks. I am retrieving the records existing in this DB table
& displaying them in a DataGrid like this:

<script runat="server">
Sub Page_Load(obj As Object, ea As EventArgs)
Dim dSet As DataSet
Dim sqlConn As SqlConnection
Dim sqlDapter As SqlDataAdapter

sqlConn = New SqlConnection(" ........")
sqlDapter = New SqlDataAdapter( "SELECT * FROM tblMarks",
sqlConn)
dSet = New DataSet

sqlDapter.Fill( dSet, "Marks")

dgMarks.DataSou rce = dSet
dgMarks.DataBin d()
End Sub
</script>
<form eunat="server">
<asp:DataGrid ID="dgMarks" HeaderStyle-Font-Bold="true"
HeaderStyle-HorizontalAlign ="center" runat="server"/>
</form>

The above will retrieve & display all the records existing in the 4
columns in the DataGrid. By default all the records in the different
cells in the DataGrid will be left-aligned. Now I want only the records
existing under the ID column to be right-aligned & the records existing
under the Marks column to be center-aligned. The records under UserID &
Subject columns should remain left-aligned.

How do I accomplish this?

Thanks,

Arpan

[John Timney \(MVP\)]

I suspect you will actually have to use the columns collection given your
trying to set an individual column as opposed to the whole grid.

--
Regards

John Timney (MVP)
"Arpan" <ar******@hotma il.comwrote in message
news:11******** *************@p 79g2000cwp.goog legroups.com...

John, the problem in the code that I have shown in post #1 doesn't use
the <Columnscollect ion to populate the DataGrid i.e. the 4 columns
displayed in the DataGrid are generated automatically which why the
Columns count property evaluates to 0 but the examples shown in the 2
URLs you have referred use the <Columnscollect ion (like BoundColumn,
ButtonColumn, TemplateColumn) explicitly to render the DataGrid. They
don't show how to format records under auto-generated columns.

Arpan
John Timney (MVP) wrote:

>Sorry Arpan,

I dont have a working environment in front of me. Here are a couple of
links that will help you get your example working by declaring the
<ItemStyle>

http://msdn2.microsoft.com/en-us/lib...itemstyle.aspx
http://msdn2.microsoft.com/en-us/lib...d.columns.aspx

Either way, you'll likely need to set the columns up for either approach
to
work.
--
--
Regards

John Timney (MVP)
"Arpan" <ar******@hotma il.comwrote in message
news:11******* **************@ m73g2000cwd.goo glegroups.com.. .

John, using

dgMarks.Columns (0).ItemStyle.H orizontalAlign = HorizontalAlign .Right

after binding the data to the DataGrid generates the following error:

Index was out of range. Must be non-negative and less than the size of
the collection.
Parameter name: index

pointing to the above line. Even the code

Response.Write( dgMarks.Columns .Count)

evaluates to 0! If the ItemStyle line is removed, then I can see the
DataGrid displaying the 4 columns - ID, UserID, Subject & Marks. So how
come the Columns count property evaluates to 0?

Thanks,

Regards,

Arpan

John Timney (MVP) wrote:
off the top of my head in your load event after binding its something
like:

dgMarks.Column s(0).ItemStyle. HorizontalAlign =HorizontalAlig n.Center

or declared it would probably be something like this
<ItemStyle Width="150px" VerticalAlign=" middle"
HorizontalAlig n="right"
/>

You might have to pick it apart a bit, its not tested.
--
--
Regards

John Timney (MVP)
"Arpan" <ar******@hotma il.comwrote in message
news:11******* **************@ i42g2000cwa.goo glegroups.com.. .
Assume that a database table has the following 4 columns - ID,
UserID,
Subject & Marks. I am retrieving the records existing in this DB
table
& displaying them in a DataGrid like this:

<script runat="server">
Sub Page_Load(obj As Object, ea As EventArgs)
Dim dSet As DataSet
Dim sqlConn As SqlConnection
Dim sqlDapter As SqlDataAdapter

sqlConn = New SqlConnection(" ........")
sqlDapter = New SqlDataAdapter( "SELECT * FROM tblMarks",
sqlConn)
dSet = New DataSet

sqlDapter.Fill( dSet, "Marks")

dgMarks.DataSou rce = dSet
dgMarks.DataBin d()
End Sub
</script>
<form eunat="server">
<asp:DataGrid ID="dgMarks" HeaderStyle-Font-Bold="true"
HeaderStyle-HorizontalAlign ="center" runat="server"/>
</form>

The above will retrieve & display all the records existing in the 4
columns in the DataGrid. By default all the records in the different
cells in the DataGrid will be left-aligned. Now I want only the
records
existing under the ID column to be right-aligned & the records
existing
under the Marks column to be center-aligned. The records under
UserID &
Subject columns should remain left-aligned.

How do I accomplish this?

Thanks,

Arpan