I tried that and it still didn't work. When I type,
nothing shows up.
--- Peter Brunone <[EMAIL PROTECTED]> wrote:
> 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! Mail Mobile
Take Yahoo! Mail with you! Check email on your mobile phone.
http://mobile.yahoo.com/learn/mail
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/
