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