This seems to work. What exactly does Trim() do? Will
it affect the other textboxes (where they are
populated since their fields aren't null)? It doesn't
look like it.
Is this a permanent solution? And is it the best one?
Thanks,
Anna
--- Mark E <[EMAIL PROTECTED]> wrote:
> If you have 200+ spaces, that may be taking up the
> value of the control.
>
> Try triming your values when you set them to the
> control and see if it helps:
>
> lname.Text = Trim(dr("LastName").ToString())
>
> If it's empty space, the Trim() function will remove
> it.
>
> Mark
>
> Anna Leon <[EMAIL PROTECTED]> wrote:
> Mark,
>
> The textboxes are limited to maxlength of 200.
>
> When I tried Peter's method:
> > > 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.
>
> The textboxes that aren't populated with anything
> (meaning the fields are null in the database), the I
> see only spaces (probably like 200) are getting put
> into the value atrribute.
>
> Thanks,
> Anna
>
>
> --- Mark E <[EMAIL PROTECTED]> wrote:
>
> > 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]
> >
> >
>
>
> __________________________________________________
> 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]
>
>
__________________________________________________
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:
http://docs.yahoo.com/info/terms/
