uniqueidentifie r

[SMG]

Hi all,
I created one table with following structure, and bound the same with a
DataGird.

But I am not able to see any column which is having 'uniqueidentifi er' as
datatype.

Name DataType
ID uniqueidentifie r
UID uniqueidentifie r
CatID uniqueidentifie r
CustName Varchar
CustAdd Varchar

A help will be appreciated.

Shailesh

[Oytun YILMAZ]

On Wed, 18 Aug 2004 18:03:10 +0530, SMG wrote:

Hi all,
I created one table with following structure, and bound the same with a
DataGird.

But I am not able to see any column which is having 'uniqueidentifi er' as
datatype.

Name DataType
ID uniqueidentifie r
UID uniqueidentifie r
CatID uniqueidentifie r
CustName Varchar
CustAdd Varchar

A help will be appreciated.

Shailesh

uniqueidentifie r is stored as System.Guid in a dataset you should call a
..Tostring method somewhere in your design.

- Oytun YILMAZ

[SMG]

No it doesn't work...

I created another table with just a single uniqueidentifie r field,
Name DataType
ID uniqueidentifie r
CustName Varchar
CustAdd Varchar

and in itemdatabound of datagrid i wrote following lines
private void DataGrid1_ItemD ataBound(object sender, System.Web.UI.W ebControls.Data GridItemEventAr gs e)
{
e.Item.Cells[0].Text = e.Item.Cells[0].Text.ToString( );
}

It still doesn't show the first column....
// is it the right place to write the code.. and what ever i have written is that OK? or something else also i have to write.

thanks Oytun for prompt reply...
Regards,
Shailesh


"Oytun YILMAZ" <oyilmaz@_REMOV E_veripark.com> wrote in message news:1f******** *************** *******@40tude. net...
On Wed, 18 Aug 2004 18:03:10 +0530, SMG wrote:

Hi all,
I created one table with following structure, and bound the same with a
DataGird.

But I am not able to see any column which is having 'uniqueidentifi er' as
datatype.

Name DataType
ID uniqueidentifie r
UID uniqueidentifie r
CatID uniqueidentifie r
CustName Varchar
CustAdd Varchar

A help will be appreciated.

Shailesh

uniqueidentifie r is stored as System.Guid in a dataset you should call a
.Tostring method somewhere in your design.

- Oytun YILMAZ

[Oytun YILMAZ]

On Wed, 18 Aug 2004 18:52:44 +0530, SMG wrote:

No it doesn't work...

I created another table with just a single uniqueidentifie r field,
Name DataType
ID uniqueidentifie r
CustName Varchar
CustAdd Varchar

and in itemdatabound of datagrid i wrote following lines
private void DataGrid1_ItemD ataBound(object sender, System.Web.UI.W ebControls.Data GridItemEventAr gs e)
{
e.Item.Cells[0].Text = e.Item.Cells[0].Text.ToString( );
}

It still doesn't show the first column....
// is it the right place to write the code.. and what ever i have written is that OK? or something else also i have to write.

thanks Oytun for prompt reply...
Regards,
Shailesh


"Oytun YILMAZ" <oyilmaz@_REMOV E_veripark.com> wrote in message news:1f******** *************** *******@40tude. net...
On Wed, 18 Aug 2004 18:03:10 +0530, SMG wrote:

> Hi all,
> I created one table with following structure, and bound the same with a
> DataGird.
>
> But I am not able to see any column which is having 'uniqueidentifi er' as
> datatype.
>
> Name DataType
> ID uniqueidentifie r
> UID uniqueidentifie r
> CatID uniqueidentifie r
> CustName Varchar
> CustAdd Varchar
>
> A help will be appreciated.
>
> Shailesh

uniqueidentifie r is stored as System.Guid in a dataset you should call a
.Tostring method somewhere in your design.

- Oytun YILMAZ

Hi,

I got it working like this:

Protected Function GetGUIDText(ByV al guid As Guid) As String
Return guid.ToString
End Function

<asp:DataGrid id="DataGrid1" runat="server" AutoGenerateCol umns="False">
<Columns>
<asp:TemplateCo lumn>
<ItemTemplate >
<asp:Label runat="server" Text='<%# GetGUIDText(Dat aBinder.Eval(Co ntainer,
"DataItem.mYcOL UMN")) %>'>
</asp:Label>
</ItemTemplate>
</asp:TemplateCol umn>
</Columns>
</asp:DataGrid>

- Oytun YILMAZ