Anybody helps me, please ! I use a textbox and a button. when I click on button, data from text box will be inserted into database oracle. But I don't know, if data is unicode, when I select data and display on page, it is wrong code ! (on page and in database).
But If I directly write unicode text (use oracle developer or pl sql), all unicode text are good. =>Error is caused when submit from textbox to database. Anybody help me fix this error please !
micheal9000
Member
94 Points
40 Posts
Help about submit Unicode text
Aug 07, 2009 04:13 AM|LINK
Anybody helps me, please ! I use a textbox and a button. when I click on button, data from text box will be inserted into database oracle. But I don't know, if data is unicode, when I select data and display on page, it is wrong code ! (on page and in database). But If I directly write unicode text (use oracle developer or pl sql), all unicode text are good. =>Error is caused when submit from textbox to database. Anybody help me fix this error please !
protected void Button1_Click(object sender, EventArgs e) { try { sqldb.InsertCommand = "insert into POSTS(POSTCONTENT, USERNAME, POSTTITLE) values('"+tbcontentpost.Text+"','"+(string)Session["username"]+"','"+tbtitlepost.Text+"')"; sqldb.Insert(); tbcontentpost.Text = ""; tbtitlepost.Text = ""; Page_Load(sender, e); } catch (Exception er) { content.InnerHtml = er.StackTrace; } }protected void Button3_Click(object sender, EventArgs e) { try { sqldb.SelectCommand = "select postcontent, posttitle from posts;"; DataView dv = (DataView)sqldb.Select(DataSourceSelectArguments.Empty); for (int i = 0; i < dv.Table.Rows.Count; i++) { Response.write((string)dv.Table.Rows[i]["postcontent"]+"<br/>"); Response.write((string)dv.Table.Rows[i]["posttitle"]+"<br/>"); } } catch (Exception er) { content.InnerHtml = er.StackTrace; } }sagnikmukh
Participant
1850 Points
354 Posts
Re: Help about submit Unicode text
Aug 07, 2009 06:31 AM|LINK
i found something like
http://www.daniweb.com/forums/thread86500.html#
http://helpindotnet.wordpress.com/2008/05/06/unicode-characters/
http://www.microsoft.com/globaldev/DrIntl/columns/001/default.mspx#E6B