Could you please clarify more?
Here's my DDL:
<asp:DropDownList id="Title" runat="server">
<asp:ListItem
Value="Mr.">Mr.</asp:ListItem>
<asp:ListItem
Value="Mrs.">Mrs.</asp:ListItem>
<asp:ListItem
Value="Miss.">Miss.</asp:ListItem>
<asp:ListItem
Value="Ms.">Ms.</asp:ListItem>
</asp:DropDownList>
===================================================
Here's the code to insert it into the database:
Sub nxtButton_Click(sender As Object, e As EventArgs)
If Page.IsValid then
Dim s1 as String =
Title.SelectedItem.Text
Dim s2 as String =
StrConv(lastname.Text, VBStrConv.ProperCase)
Dim s3 as String =
StrConv(firstname.Text, VBStrConv.ProperCase)
Dim s4 as String =
MiddleInitial.Text.ToUpper()
InsertToCardVerification(s1, s2, s3,
s4)
==================================================
I have a datagrid which displays all the records and
if I click on a last name (in which I would like to
edit), that data gets populated into a form on a
second page.
Here's the code which retrieves the record and updates
it:
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("UID") Is Nothing Then
Status.Text = "New record"
uid.Text = "New"
ElseIf Request.QueryString("UID") = "New" Then
Status.TExt = "New record"
uid.Text = "New"
Else
Try
Status.Text = "Record retrieved"
Id = CInt(Request.QueryString("UID"))
ds = New DataSet()
conn = New SqlConnection(ConnectionStr)
cmd = New SqlCommand("GetCardVerification",
conn)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@UID",
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 =
Trim(dr("Title").ToString())
lname.Text =
Trim(dr("LastName").ToString())
fname.Text =
Trim(dr("FirstName").ToString())
middleinitial.Text =
Trim(dr("MiddleInitial").ToString())
email.Text =
Trim(dr("Email").ToString())
phone.Text =
Trim(dr("Phone").ToString())
phoneext.Text =
Trim(dr("PhoneExt").ToString())
.
.
.
End If
Catch ex as InvalidCastException
Status.Text = "Invalid record ID value."
Catch ex As SqlException
Status.Text = "Database error: " & ex.message
If cmd.Connection.State <>
ConnectionState.Closed Then
cmd.Connection.Close()
End If
Catch ex As Exception
Status.Text = "General error: " & ex.message
If cmd.Connection.State <>
ConnectionState.Closed Then
cmd.Connection.Close()
End If
End Try
End If
End If
End Sub
Sub LinkButton1_Click(sender As Object, e As
EventArgs)
Dim ConnectionStr As String =
ConfigurationSettings.AppSettings("ConnString")
Dim cmd As SqlCommand
Dim conn As SqlConnection
Dim id As Integer
Try
Status.Text = "Record saved"
If uid.Text = "New" Then
id = -1
Else
id = CInt(uid.Text)
End If
conn = New SqlConnection(ConnectionStr)
cmd = New SqlCommand("UpdateCardVerification",
conn)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@UID", SqlDbType.Int).Value =
Id
cmd.Parameters("@UID").Direction =
ParameterDirection.InputOutput
cmd.Parameters.Add("@Title", SqlDbType.VarChar,
10).Value = title.SelectedItem.Text
cmd.Parameters.Add("@LastName", SqlDbType.VarChar,
100).Value = lname.Text
cmd.Parameters.Add("@FirstName", SqlDbType.VarChar,
100).Value = fname.Text
cmd.Parameters.Add("@MiddleInitial",
SqlDbType.char, 1).Value = middleinitial.Text
cmd.Parameters.Add("@Email", SqlDbType.VarChar,
200).Value = email.Text
cmd.Parameters.Add("@Phone", SqlDbType.VarChar,
12).Value = phone.Text
cmd.Parameters.Add("@PhoneExt", SqlDbType.VarChar,
10).Value = phoneext.Text
.
.
.
cmd.Connection.Open()
cmd.ExecuteNonQuery()
cmd.Connection.Close()
uid.Text = cmd.Parameters("@UID").Value.ToString
Catch ex as InvalidCastException
Status.Text = "Invalid record ID value."
Catch ex As SqlException
Status.Text = "Database error: " & ex.message
If cmd.Connection.State <> ConnectionState.Closed
Then
cmd.Connection.Close()
End If
Catch ex As Exception
Status.Text = "General error: " & ex.message
If cmd.Connection.State <> ConnectionState.Closed
Then
cmd.Connection.Close()
End If
End Try
End Sub
================================================
So to select the correct item, I would have to change
myDDL.SelectedItem.Text
to
myDDL.SelectedValue ?
I tried and it didn't seem to work. Also, do I need to
set the AutoPostBack property to True?
I really did not find much on the proper way to select
from DDL as mentioned.
Please advise!
Thanks,
Anna
--- Mark E <[EMAIL PROTECTED]> wrote:
> Yes. I don't think there's much use for changing
> the text of an item.
>
> I'm not sure why you keep seeing it.
>
> Mark
>
> Anna Leon <[EMAIL PROTECTED]> wrote:
> So this applies in every case with dropdownlists?
> Whether you're filling out a form or populating a
> form
> with information from a database?
>
> Why do I keep seeing this format then
>
> myDDL.SelectedItem.Text ?
>
> Also I'm not populating the DDL from a database. I'm
> simply using the ITEM property.
>
> Thanks,
> Anna
>
>
> --- Peter Brunone
> wrote:
>
> > > And I've always used
> > > myDDL.SelectedItem.Text
> >
> > If your intent was to select the correct item,
> > then you've always been wrong :) This code will
> > alter the content of the currently selected item
> > rather than selecting the correct item. See below
> > for the proper way to select a new item.
> > If, on the other hand, you really do want to
> > change the text of the selected item, then ignore
> > this message and carry on.
> >
> > Cheers,
> >
> > Peter
> >
> > From: Anna Leon [EMAIL PROTECTED]
> >
> > Yes what you said below is true.
> >
> > This is what I'm using:
> >
> > where MR is always the first item in the
> collection.
> >
> > And I've always used
> > myDDL.SelectedItem.Text
> >
> > Thanks,
> > Anna
> >
> > --- Peter Brunone wrote:
> >
> > >
> > > Actually, from the explanation below, it looks
> > > like her code is simply changing the value/text
> of
> > > the first item in the DDL (instead of changing
> the
> > > selected item).
> > >
> > > Anna, what code are you using to select the
> > > correct item in your list? I would guess that
> > > you're doing something like this:
> > >
> > > myDDL.SelectedItem.Value = "MS"
> > > myDDL.SelectedItem.Text = "MS"
> > >
> > > when you should be doing something like this:
> > >
> > > myDDL.SelectedValue = "MS" ' ASP.NET 1.1
> > > or
> > > myDDL.SelectedIndex =
> > >
> myDDL.Items.IndexOf(myDDL.Items.FindByValue("MS"))
> > >
> > >
> > >
> > > From: Mark E [EMAIL PROTECTED]
> > >
> > > Anna,
> > >
> > > It looks as tho your code that populates the
> DDL's
> > > is returning the value plus all 4 prefix
> > selections.
> > > That would explain why the item is always first
> > but
> > > there is a duplicate within the DDL.
> > >
> > > I recall dealing with this previously and I had
> my
> > > stored procedure use a union. I first grabbed
> the
> > > prefix for the customer, then used a union to
> > return
> > > all *other* prefixes that did not match the one
> > for
> > > this customer. Like this:
> > >
> > > -- get the prefix for this customer
> > > select Prefix
> > > from tblPrefix, tblCustomer
> > > where tblCustomer.Prefix = tblPrefix.Prefix
> > >
> > > union
> > >
> > > -- get all other prefixes
> > > select Prefix
> > > from tblPrefix, tblCustomer
> > > where tblCustomer.Prefix <> tblPrefix.Prefix
> > >
> > > If you can't get it, post your SQL that
> retrieves
> > > your prefixes so that we can see it.
> > >
> > > Mark
> > >
> > > Anna Leon wrote:
> > > Everything looks okay I believe.
> > >
> > > Here's what I have noticed:
> > >
> > > - The FIRST item in the dropdownlist gets
> changed
> > > (repeated twice) if you select something other
> > than
> > > the first item.
> > >
> > > e.g. On the form, if you select:
> > >
> > > "MS." then on the edit page, the dropdownlist is
> > > displayed with the following: MS/MRS/MISS/MS
> > >
> > > "MRS." then on the edit page, the dropdownlist
> is
> > > displayed with the following: MRS/MRS/MISS/MS
> > >
> > > "MR." then on the edit page, the dropdownlist is
> > > displayed with the following: MR/MRS/MISS/MS
> > > (* THIS IS THE ONLY ONE THAT HAS NO PROBLEMS)
> > >
> > > "MISS." then on the edit page, the dropdownlist
> is
> > > displayed with the following: MISS/MRS/MISS/MS
> > >
> > > Why is that? What am I doing wrong?
> > >
> > > Thanks,
> > > Anna
> > >
> > > --- Mark E wrote:
> > >
> > > > Anna,
> > > >
> > > > I would start with the data on page 2. Check
> all
> > > > the values before they go to the database. If
> > that
> > > > seems OK, check your stored procedure
> > > "PutCustomer".
> > > > Run it manually to ensure that the correct
> > record
> > > > (and only this record) is getting updated.
> > > >
> > > > Mark
> > > >
> > > > Anna Leon wrote:
> > > > I am actually following this article:
> > > >
> > > >
> > >
> >
>
http://www.aspnetpro.com/NewsletterArticle/2003/02/asp200302fw_l/asp200302fw_l.asp
> > > >
> > > > And the only exception is that with mines,
> some
> > > > fields
> > > > are null thus the textboxes for editing would
> > not
> > > > get
> > > > populated with anything. Although, it's been
> > said
> > > > that
> > > > there are spaces in there instead.
> > > >
> > > > Yoru're saying Trim() plus .ToString() should
> > > solve
> > > > the problem, which it does.
> > > >
> > > > The query to update the record is on the above
> > > page.
> > > >
> > > > Thanks,
> > > > Anna
> > > >
> > > > --- Mark E wrote:
> > > >
> > > > > I doubt the Trim function had anything to do
> > > with
> > > > > it. Maybe the query that updated the record?
> > We
> > > > > would have to see the code to tell what
> caused
> > > it.
> > > > >
> > > > > Mark
> > > > >
> > > > > Anna Leon wrote:
> > > > > Something else happened...
> > > > >
> > > > > I applied Trim() to all the textboxes. When
> I
> > > edit
> > > > a
> > > > > record on the second page (on a form w/
> > > textboxes
> > > > > and
> > > > > dropdownlists), I changed the title from Mr.
> > to
> > > > Mrs.
> > > > > as a test, after I saved, I noticed the
> > > > dropdownlist
> > > > > items changed. Mr is no longer a choice and
> I
> > > have
> > > > > Mrs. twice. What happened there? This also
> > > > affected
> > > > > several other records (and I didn't even
> touch
> > > > > them).
> > > > >
> > > > > Thanks,
> > > > > Anna
> > > > >
> > > > > --- Mark E wrote:
> > > > >
> > > > > > Anna,
> > > > > >
> > > > > > The Trim() function trims (or removes) all
> > > > leading
> > > > > > and trailing spaces from a string. In your
> > > > case,
> > > > > > that's all you had so it removed
> everything.
> > I
> > > > > > would recommend using on all your
> textboxes
> > > > there
> > > > > > the user input is an open text field.
> > > > > >
> > > > > > Mark
> > > > > >
> > > > > > Anna Leon wrote:
> > > > > > 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 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 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 wrote:
> > > > > > >
> > > > > > > > Anna,
> > > > > > > >
> > > > > > > > Are your textboxes disabled or limited
> > in
> > > > > > someway?
> > > > > > > >
> > > > > > > > Mark
> > > > > > > >
> > > > > > > > Anna Leon wrote:
> > > > > > > > Hi,
> > > > > > > >
> > > > > > > > Thanks for the function, but it's not
> > > > working
> > > > > > > > either.
> > > > > > > > =/
> > > > > > > >
> > > > > > > > -Anna
> > > > > > > >
> > > > > > > >
> > > > > > > > --- David Renz
> > > > > 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]
> > >
> > >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! Small Business - Try our new Resources site
> > http://smallbusiness.yahoo.com/resources/
> >
> > 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
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been
> removed]
>
>
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new Resources site
http://smallbusiness.yahoo.com/resources/
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/
