Hi,

I have created an AssetTracking database in SQL Server 2000 and one of my
master tables generates an autonumber for a unique PC Make. For example my
table will consist of the following:

1 HP
2 Dell
3 Fujitsu

My main table which will holds the PC Information includes a PCMakeID field
to represent the PC Make.
In VB.NET, I have added a DBCombo to populate the PC Make details. When I
press the Save button on the form to save the details to the PC Information
table, I want to save the PCMakeID value into the table instead of the
actual text value.

Does anyone know how to go about achieving this task.

Regards

Dipendra

--
Message posted via http://www.dotnetmonster.com

Can't you just use: 'CInt(TextBox1.Text)' for example?

"Dipendra Darbar via DotNetMonster.com" wrote:

> Hi,
>
> I have created an AssetTracking database in SQL Server 2000 and one of my
> master tables generates an autonumber for a unique PC Make. For example my
> table will consist of the following:
>
> 1 HP
> 2 Dell
> 3 Fujitsu
>
> My main table which will holds the PC Information includes a PCMakeID field
> to represent the PC Make.
> In VB.NET, I have added a DBCombo to populate the PC Make details. When I
> press the Save button on the form to save the details to the PC Information
> table, I want to save the PCMakeID value into the table instead of the
> actual text value.
>
> Does anyone know how to go about achieving this task.
>
> Regards
>
> Dipendra
>
> --
> Message posted via http://www.dotnetmonster.com
>

"Dipendra Darbar via DotNetMonster.com" <(E-Mail Removed)> schrieb:
> I have created an AssetTracking database in SQL Server 2000 and one of my
> master tables generates an autonumber for a unique PC Make. For example my
> table will consist of the following:
>
> 1 HP
> 2 Dell
> 3 Fujitsu
>
> My main table which will holds the PC Information includes a PCMakeID
> field
> to represent the PC Make.
> In VB.NET, I have added a DBCombo to populate the PC Make details. When I
> press the Save button on the form to save the details to the PC
> Information
> table, I want to save the PCMakeID value into the table instead of the
> actual text value.

For a culture-sensitive conversion use 'CInt', for a converstion with
invariant culture semantics use 'Val'. Alternatively you can use
'Integer.Parse' and pass an appropriate 'CultureInfo' object to this method.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

Dipendra,

When you use an datatable to load your object (from your database or build
by hand) than you can use the displaymember for your text and the
valuemember for your id.

When you need it you use the selectedvalue.

I hope this helps,

Cor