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 <[EMAIL PROTECTED]> 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
> >
> >
> >
> >
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam
> protection around
> http://mail.yahoo.com
>
> 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:
http://docs.yahoo.com/info/terms/
