Help about submit Unicode text RSS

• • Reply
  

  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;
          }
      }
  

  
  
  

  • Moved by SGWellens on Aug 07, 2009 04:21 AM
  • Edited by micheal9000 on Aug 07, 2009 04:30 AM
• • Reply
  

  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