Before each assignment, check for the existence of NULLS
in the column:
Example:
if NOT dr.IsNull("LastName") then
end if
Dallas
Quoting Anna Leon <[EMAIL PROTECTED]>:
> 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
>
>
>
>
>
>
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/
