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: http://docs.yahoo.com/info/terms/
