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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> wrote: > > > > > > > > > Anna, > > > > > > > > > > Are your textboxes disabled or limited in > > > someway? > > > > > > > > > > Mark > > > > > > > > > > Anna Leon <[EMAIL PROTECTED]> wrote: > > > > > Hi, > > > > > > > > > > Thanks for the function, but it's not > working > > > > > either. > > > > > =/ > > > > > > > > > > -Anna > > > > > > > > > > > > > > > --- David Renz <[EMAIL PROTECTED]> > > 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] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 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 > the > > > > > Yahoo! Terms of Service. > > > > > > > > > > > > > > > > > > > > [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 the > > > > Yahoo! Terms of Service. > > > > > > > > > > > > > > > > [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 the > > > Yahoo! Terms of Service. > > > > > > > > > > > > [Non-text portions of this message have been > > > removed] > > > > > > > > > > > > > > > > Yahoo! Mail > > Stay connected, organized, and protected. Take the > > tour: > > http://tour.mail.yahoo.com/mailtour.html > > > > > > > > --------------------------------- > > 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 the > > Yahoo! Terms of Service. > > > > > > > > [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 the > Yahoo! Terms of Service. > > > > [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/
