Anna,
Are your textboxes disabled or limited in someway?
Mark
Anna Leon <[EMAIL PROTECTED]> wrote:
Hi,
Thanks for the function, but it's not working either.
=/
-Anna
--- David Renz <[EMAIL PROTECTED]> wrote:
> anna,
>
>
> if it is the null values ... i have a simple
> function that deals with
> null values.
>
> Public Function EnsureStringDefault(ByVal sValue) As
> String
> If sValue Is DBNull.Value Then
> Return ""
> Else
> Return sValue
> End If
> End Function
>
> use it like so:
> lname.Text = EnsureStringDefault(dr("LastName"))
>
> same for numbers
>
> Public Function EnsureNumericDefault(ByVal iValue)
> As Integer
> If iValue Is DBNull.Value Then
> Return 0
> Else
> Return iValue
> End If
> End Function
>
> they work for me on several sites, though i am not
> facing the same
> problem you explained.
>
>
>
>
>
> >>> [EMAIL PROTECTED] 05/13/2005 8:22:46 AM >>>
>
> I would suggest
>
> lname.Text = dr("LastName").ToString()
> fname.Text = dr("FirstName").ToString()
>
> and so on. If you still have problems, post a link
> (if you can) or do
> a View Source on your page to see what's getting put
> into the value
> attribute of the textboxes. You can even copy the
> output and paste it
> into the form at
>
http://aspalliance.com/peterbrunone/analyzethis/analyzethis.asp
> to see
> if there are any funny characters in there.
>
> Cheers,
>
> Peter
>
> From: Anna Leon [EMAIL PROTECTED]
>
> Private Sub Page_Load(ByVal sender As System.Object,
> ByVal e As System.EventArgs)
>
> Dim ds As DataSet
> Dim dr As DataRow
> Dim ConnectionStr As String =
> ConfigurationSettings.AppSettings("ConnString")
> Dim adpt As SqlDataAdapter
> Dim conn As SqlConnection
> Dim cmd As SqlCommand
> Dim Id As Integer
>
> If Not IsPostBack Then
> If Request.QuerySTring("CardVerificationUID") Is
> Nothing Then
> Status.Text = "New record"
> uid.Text = "New"
>
> ElseIf Request.QueryString("CardVerificationUID") =
> "New" Then
> Status.TExt = "New record"
> uid.Text = "New"
>
> Else
> Try
> Status.Text = "Record retrieved"
> Id =
> CInt(Request.QueryString("CardVerificationUID"))
> ds = New DataSet()
> conn = New SqlConnection(ConnectionStr)
> cmd = New SqlCommand("GetCardVerification",
> conn)
> cmd.CommandType = CommandType.StoredProcedure
> cmd.Parameters.Add("@CardVerificationUID",
> SqlDbType.Int).Value = Id
> adpt = New SqlDataAdapter(cmd)
> adpt.Fill(ds, "CardVerification")
> if ds.Tables("CardVerification").Rows.Count =
> 0 Then
> Status.Text = "Record not found."
>
> Else
> dr =
> ds.Tables("CardVerification").Rows(0)
> uid.Text = dr("UID")
> title.SelectedItem.Text = dr("Title")
> lname.Text = dr("LastName")
> fname.Text = dr("FirstName")
> middleinitial.Text =
> dr("MiddleInitial")
> email.Text = dr("Email")
> phone.Text = dr("Phone")
> phoneext.Text = dr("PhoneExt")
> .
> .
> .
>
> Thanks,
> Anna
>
> --- Peter Brunone wrote:
> > Hi Anna,
> >
> > If you can show me the code you're using to pull
> > the data, I can show you where it goes. Usually I
> > just do it to the field when it comes out of the
> > data structure (the first time you assign it
> > somewhere).
> >
> > Cheers,
> >
> > Peter
> >
> > From: Anna Leon [EMAIL PROTECTED]
> >
> > Hi Peter,
> >
> > Can you provide an example? Where would I set the
> > value to the field.ToString() because in the code,
> > there's 2 sections where one retrieves the record
> > and
> > populating the data into the textboxes, and
> second,
> > updating the record in the database with whatever
> > changes made in the textboxes (except the empty
> ones
> > don't do anything).
> >
> > Thanks,
> > Anna
> >
> > --- Peter Brunone wrote:
> > > Hi Anna,
> > >
> > > If you are populating these textboxes, try
> setting
> > > the value
> > > equal to the field.ToString() instead of just
> the
> > > field.
> > >
> > > Cheers,
> > >
> > > Peter
> > >
> > > -----Original Message-----
> > > From: [email protected] On
> > > Behalf Of sas0riza
> > >
> > > Hello,
> > >
> > > I have 2 asp.net pages where the first has a
> > > datagrid and the second
> > > page allows you edit the record depending which
> > one
> > > you clicked from
> > > the datagrid.
> > >
> > > Not all records have all fields filled in. The
> > > record is retrieved
> > > and the data is populated into a form
> (textboxes)
> > > for editing on the
> > > second page. Some textboxes come back empty
> since
> > > it's NULL, which
> > > is okay.
> > >
> > > BUT, when I try to type (edit mode) something
> into
> > > the empty
> > > textbox, nothing shows up no matter what I type.
> > >
> > > I think the null value is the cause.
> > >
> > > So, how do I fix this?
> > >
> > > Someone told me that I should make sure that I
> > don't
> > > return a null
> > > value from the database.
> > >
> > > Any help is greatly appreciated.
> > >
> > > Thanks,
> > > Anna
>
>
> [Non-text portions of this message have been
> removed]
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been
> removed]
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
