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]
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/
