Re: Aligning Particular Columns in a Data Grid

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Scott Mitchell [MVP] (mitchell_at_4guysfromrolla.com)
Date: 11/18/04 

Date: Thu, 18 Nov 2004 20:05:26 GMT

And if you use the debugger to step through, you see that
dtMain.Columns.Count > 1, but the DataGrid's Columns.Count property = 1?
  That is indeed odd.

Jennifer wrote:
> Scott,
>
> Thank you for replying. The columns are being automatically generated. I
> do try to set the alignment after the data binding. I'm going to post my
> almost-full code below (I'm just not going to show the code for each of the
> 61 columns - that would be too much.) Do you have any other suggestions?
> Perhaps the way I am setting up the grid in the first place is wrong?
>
> I appreciate any advice you can give me.
>
> Thanks,
> Jennifer
>
>
> Private Sub FillGrid(ByVal SortExp As String)
> Dim dvMain As DataView
> Dim X As Int64
> Dim dtMain As New DataTable()
> Dim DR As DataRow
> Dim Update_User As String
> If txtStartDate.Text <> "*" Then
> If txtEndDate.Text = "*" Then Exit Sub
> End If
> dvMain = GetDailySales(txtUnitID.Text, txtStartDate.Text,
> txtEndDate.Text)
> If SortExp <> "" Then
> dvMain.Sort = SortExp
> End If
> Dim Col1, Col2, Col3, Col4, Col5, Col6, Col7, Col8, Col9, Col10 As
> String
> Dim Col11, Col12, Col13, Col14, Col15, Col16, Col17, Col18, Col19,
> Col20 As String
> Dim Col21, Col22, Col23, Col24, Col25, Col26, Col27, Col28, Col29,
> Col30 As String
> Dim Col31, Col32, Col33, Col34, Col35, Col36, Col37, Col38, Col39,
> Col40 As String
> Dim Col41, Col42, Col43, Col44, Col45, Col46, Col47, Col48, Col49,
> Col50, Col51, Col52 As String
> Dim Col53, Col54, Col55, Col56, Col57, Col58, Col59, Col60, Col61,
> Col62, Col63, Col64 As String
>
>
> Col1 = "Unit"
> Col2 = "Date"
> Col3 = "Status"
> Col4 = "Deposit" & vbCrLf & "Evening" & vbCrLf & "$"
> Col55 = "Deposit" & vbCrLf & "Evening" & vbCrLf & "$" & vbCrLf &
> "Verified"
> Col5 = "Deposit" & vbCrLf & "Early_Bird" & vbCrLf & "$"
> '-----more column names set here------------
>
> dtMain.Columns.Add(Col1)
> dtMain.Columns.Add(Col2)
> dtMain.Columns.Add(Col3)
> dtMain.Columns.Add(Col4)
> If chkViewVerif.Checked = True Then dtMain.Columns.Add(Col55)
> '-----adding the rest of the columns to the data row here
>
> Dim BD As Date
> For X = 0 To dvMain.Count - 1
> DR = dtMain.NewRow
> DR(Col1) = dvMain(X)("Unit_ID")
> BD = dvMain(X)("Business_Date")
> DR(Col2) = BD.ToShortDateString
> DR(Col3) = dvMain(X)("Status")
> If IsDBNull(dvMain(X)("User_ID")) Then
> DR(Col50) = dvMain(X)("User_ID")
> Else
> Update_User = dvMain(X)("User_ID")
> DR(Col50) = Update_User.Substring(12)
> End If
> DR(Col4) = Format(dvMain(X)("Deposit_Eve_Amt"), "N")
> If chkViewVerif.Checked = True Then DR(Col55) =
> dvMain(X)("Deposit_Eve_Amt_Verified")
> '--- assigning the rest of the values here
> dtMain.Rows.Add(DR)
> Next
>
> dgDSR.DataSource = dtMain
> dgDSR.DataBind()
> '---trying to align a column here (and it doesn't work)
> dgDSR.Columns(2).ItemStyle.HorizontalAlign = HorizontalAlign.Center
>
> End Sub
>
>
> "Scott Mitchell [MVP]" wrote:
>
>
>>Jennifer, are you using AutoGenerateColumns=False? If so, you can
>>specify the alignment specifically, like so:
>>
>><asp:BoundColumn ... ItemStyle-HorizontalAlign="Center" ... />
>>
>>If you are having the column automatically generated, you can
>>programmatically set their alignment, it's just a matter of doing it at
>>the right time. Namely, you have to do it after the call to the
>>DataGrid's DataBind() method. So your code should look something like:
>>
>> DataGridID.DataSource = ...
>> DataGridID.DataBind()
>>
>> 'Code to set alignment of columns
>>
>>hth
>>
>>--
>>
>> Scott Mitchell
>> mitchell@4guysfromrolla.com
>> http://www.4GuysFromRolla.com
>>
>>* When you think ASP.NET, think 4GuysFromRolla.com!
>> 

-- 
     Scott Mitchell
     mitchell@4guysfromrolla.com
     http://www.4GuysFromRolla.com
		
* When you think ASP.NET, think 4GuysFromRolla.com!

Relevant Pages

  • Re: CStr() vs. .ToString()
    ... "CMM" wrote: ... Contrary to what Scott M says you're SUPPOSED to use them. ... preference to the .NET Framework methods such as ToString(), ... methods on a string that is "Nothing". ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Bijective 2 State Arithmatic coding question
    ... David A. Scott July 2004 ... string again, ... It actaully compresses the string that is in the byte file. ...
    (comp.compression)
  • Re: Leading "=" Lost in OpenArgs String
    ... I can verify your bug, and it exists in A2000 and A2003 also. ... Leading and trailing spaces are also stripped from the string if the first ... "Scott Inrig" wrote in message ... stripped off somehow by the time the form's Open event procedure is called. ...
    (microsoft.public.access.formscoding)
  • Re: Passing a Dataset to a webservice
    ... Scott M. wrote: ... "...Turn the DataSet into a string using GetXml, pass it to the web method as string, turn it back into DataSet in the web method..." ... "Maybe I'm not reading this right, but are you proposing he send it as a string rather than as a structured XML document? ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: Concatenation Limit?
    ... Jennifer, there is a limit. ... As best I recall the limit is greater for nt/xp that windows. ... I think the limit for a string is around 32k, ... using "the heap" for working data. ...
    (microsoft.public.scripting.vbscript)