我用Label作为前台页面,后台输入时,使用TextBox,输入到SQL SERVER 2000数据库nvarchar型字段中,发现,输入时没有问题,可是当使用DataReader读取到Label时,所有的格式都丢了,这个问题大家都是怎么解决的?我看了一下,数据库里面格式正常; 还有,假如要做一个处理程序,Label显示是在PageLoad里面做的,单独做一个public string strformat(string str)能被正常加载吗? 再有,就是能加载,比如空格、回车符之类的判断怎么写?数据库里面可没有这些符号。
If Not Page.IsPostBack Then
Dim mode As String = Request.QueryString("mode") If mode = "edit" Then
'delete.Visible = True
delete.Attributes.Add("onclick", "javascript:return confirm('Are you sure to delete this record?');")
Dim con As OleDbConnection
Dim str As String
Dim dad As OleDbDataAdapter
Dim dadstr As String
Dim dset As New DataSet()
Dim dtable As DataTable str = Session("constr")
con = New OleDbConnection(str)
dadstr = "select * from employee where employeeid=" & Request.QueryString("employeeid") dad = New OleDbDataAdapter(dadstr, con)
dad.Fill(dset, "employee")
dtable = dset.Tables("employee")
If Not IsDBNull(dtable.Rows(0).Item("Employee_number")) Then
Employee_number.Text = dtable.Rows(0).Item("Employee_number")
End If
If Not IsDBNull(dtable.Rows(0).Item("Givennames")) Then
Givennames.Text = dtable.Rows(0).Item("Givennames")
End If
If Not IsDBNull(dtable.Rows(0).Item("Surname")) Then
Surname.Text = dtable.Rows(0).Item("Surname")
End If
bind_ddlb(Gender, "code_gender", "name", "code")
location(Gender, "")
If Not IsDBNull(dtable.Rows(0).Item("Gender")) Then
location(Gender, dtable.Rows(0).Item("Gender"))
End If
If Not IsDBNull(dtable.Rows(0).Item("Dob")) Then
dob.Text = Format(CDate(dtable.Rows(0).Item("Dob")), "d/MMM/yyyy")
End If
If Not IsDBNull(dtable.Rows(0).Item("Position_name")) Then
Position_name.Text = dtable.Rows(0).Item("Position_name")
End If
If Not IsDBNull(dtable.Rows(0).Item("Employment_type")) Then
Employment_type.Text = dtable.Rows(0).Item("Employment_type")
End If
If Not IsDBNull(dtable.Rows(0).Item("Current_FTE")) Then
Current_FTE.Text = dtable.Rows(0).Item("Current_FTE")
End If
If Not IsDBNull(dtable.Rows(0).Item("Home_address")) Then
Home_address.Text = dtable.Rows(0).Item("Home_address")
End If
If Not IsDBNull(dtable.Rows(0).Item("Home_number")) Then
Home_number.Text = dtable.Rows(0).Item("Home_number")
End If
If Not IsDBNull(dtable.Rows(0).Item("Work_number")) Then
Work_number.Text = dtable.Rows(0).Item("Work_number")
End If
If Not IsDBNull(dtable.Rows(0).Item("Fax")) Then
Fax.Text = dtable.Rows(0).Item("Fax")
End If
If Not IsDBNull(dtable.Rows(0).Item("Mobile")) Then
Mobile.Text = dtable.Rows(0).Item("Mobile")
End If
If Not IsDBNull(dtable.Rows(0).Item("Page1")) Then
Page1.Text = dtable.Rows(0).Item("Page1")
End If
Else
bind_ddlb(Gender, "code_gender", "name", "code")
location(Gender, "")
End If
End If
End Sub
===========
什么格式以上是给你一个例子看看 如何处理空值
if not isnull(fString) then
fString = replace(fString, ">", ">")
fString = replace(fString, "<", "<")
fString = Replace(fString, CHR(32), " ")
fString = Replace(fString, CHR(9), " ")
fString = Replace(fString, CHR(34), """)
fString = Replace(fString, CHR(39), "'")
fString = Replace(fString, CHR(13), "")
fString = Replace(fString, CHR(10) & CHR(10), "<P></P>")
fString = Replace(fString, CHR(10), "<br>") DvbbsHtmlAn = fString
end if
end function
然后把数据库中内容读到string或者stringbuilder中注意 forideal(我心飞翔) 的方法最后Server.htmldecode输出 content.innerhtml = string ;
or content.innerhtml = stringguilder.tostring() ;
fString = replace(fString, "<", "<")
fString = Replace(fString, CHR(32), " ")
fString = Replace(fString, CHR(9), " ")
fString = Replace(fString, CHR(34), """)
fString = Replace(fString, CHR(39), "'")
fString = Replace(fString, CHR(13), "")
fString = Replace(fString, CHR(10) & CHR(10), "<P></P>")
fString = Replace(fString, CHR(10), "<br>")但小心破坏当前页面的Html代码