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