ASP.NET 2003 AND Oracle 10g

Hi there,

I am developing a simple data entry form using VB.NET. Backend database
is Oracle 10g. I am using disconnected data. I like to fill text boxes
on the page with column default values when the form first loaded.

I tried to read data_default from dba_tab_cols but it returns error for
illegal conversion because data_default column has long type. I tried:
Me.TextBox1.Text = ds.Tables("TableName").Columns.DefaultValue

I also tried to create a new dataset and pull the data_default from
dba_tab_cols and assign it to a integer variable because my table clomn
type is number:
For Each datarow In dataset.Tables("TableName").Rows
If datarow("COLUMN_NAME") = "ColumnName" Then
intVar = datarow.Item("DATA_DEFAULT")
End If
Next

No success yet. I know it is doable without creating a package or
procedure because in some other applications we used a third part grid
control and it took care of it seamlessly without writing a single line
of code, but for some limitations grid is not useable here.

Any suggestions.

AK

.

Relevant Pages

  • Re: Start time / stop time
    ... Use the AfterUpdate event of the text boxes to combine the value and assign ... > friendly with date and time appearing to be separate fields and the ... > On the data entry form, I am guessing I would sum the date and time ... Any suggestions or warnings ...
    (microsoft.public.access.forms)
  • Re: Writing to a CSV file
    ... > This is a data entry form, there will not be any data modification or ... > validation at this point of the process. ... this will fail if the text boxes ... >> data type, or adding a blank line, etc). ...
    (microsoft.public.dotnet.languages.csharp)
  • repost - Can I post a record Automatically? Help!
    ... The data entry form has 5 text boxes that fill 5 fields in my Transactions ... Ref - Numeric ... Supplier - Text ...
    (microsoft.public.access.forms)
  • RE: repost - Can I post a record Automatically? Help!
    ... I think the reason your code is not working is because the form is not Dirty ... The data entry form has 5 text boxes that fill 5 fields in my Transactions ... Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.forms)
  • Blank records when form closes
    ... I have a data entry form that enters data in a table, ... the form I have a subform that shows the data from the table for the section ... and data to the table (most of the data is picked in combo boxes on the ... and does not work for the open/close problem. ...
    (microsoft.public.access.gettingstarted)