how to insert Russia language text into database and how to get RSS

• • Reply
  

  zubair258

  Member

  112 Points

  129 Posts

  Russia Text insert into database and how to get

  Dec 05, 2011 06:33 AM|LINK

  dear please solve my problem
  
  how to insert Russia language text into database and how to get Russia text from database in asp.net using c sharp
  
  please solve my problem 

  
  thanks

  Zubair258
  • Moved by Mikesdotnetting on Dec 05, 2011 06:35 AM
  • Edited by zubair258 on Dec 06, 2011 12:24 PM
  • Edited by zubair258 on Dec 06, 2011 12:24 PM
• • Reply
  

  Mikesdotnett...

  All-Star

  154927 Points

  19867 Posts

  Moderator

  MVP

  Re: Russia Text insert into database and how to get

  Dec 05, 2011 06:36 AM|LINK

  Make sure that the column you plan to store the text in supports unicode (nvarchar, ntext, nchar etc) and then simply insert it and select it in the same way you would for normal (English) text

  Regards, Mike
  Beginning ASP.NET Web Pages with WebMatrix | My Site | Twitter
• • Reply
  

  zubair258

  Member

  112 Points

  129 Posts

  how to insert Russia language text into database and how to get

  Dec 05, 2011 06:47 AM|LINK

  dear please solve my problem
  
  how to insert Russia language text into database and how to get data from database asp.net using c sharp
  
  please solve my problem 

  
  thanks

  Zubair258
  • Moved by Mikesdotnetting on Dec 05, 2011 06:20 PM
• • Reply
  

  zubair258

  Member

  112 Points

  129 Posts

  Re: Russia Text insert into database and how to get

  Dec 05, 2011 06:54 AM|LINK

  dear not working i can changes this 

  my datatype is nvarchar(4000) but nor working , its give me that type of text ????????????????????????????????????????????????

  when i can insert russia text from the website

  please solve my problem

  Zubair258
• • Reply
  

  mayankpathak...

  Contributor

  3643 Points

  844 Posts

  Re: how to insert Russia language text into database and how to get

  Dec 05, 2011 06:54 AM|LINK

  zubair258

  how to insert Russia language text into database and how to get data from database asp.net using c sharp

  hey there

  whenever you need to insert any other language's content into database you will have to use nvarchar, ntext, or nchar type of datatypes in 

  database columns because these datatypes supports multilingual texts and have Unicode support also. so you need to enter your content in

  russian language and save it in database into nvarchar , ntext or nchar columns. and while displaying if you want to convert russian language into

  english then you can use google language translator or use resource file in asp.net for multilingual support. Check these links

  http://www.codeproject.com/KB/cs/multilingual.aspx

  http://www.codeproject.com/KB/cs/multilingual_pplication.aspx

  http://www.codeproject.com/KB/cs/Multilingual_application.aspx
  
  
  
  

  Regards, Mayank
  
• • Reply
  

  mezzanine74

  Contributor

  2480 Points

  730 Posts

  Re: how to insert Russia language text into database and how to get

  Dec 05, 2011 06:57 AM|LINK

  Hi,

  I am also a developer in Moscow and using Russian text in my application. Are you sure that you are not missing N'' convention?

  See following example. INSERT statement has 2 entry. First one is being used by N'' but second one without N''. As long as you use N'' for text types, russian characters will be recognized automatically and you dont need to anytthing. Your client controls will render russian characters without any problem.

  CREATE TABLE [dbo].[Table_Test]
  	(
  		Column1 [nchar](10) NULL
  	)
  	
  INSERT INTO [dbo].[Table_Test]
  ( Column1)
  VALUES
  	(N'Привет')
     ,('Привет')
     
  SELECT Column1
  FROM [dbo].[Table_Test]

  please mark as answer if it helps you
• • Reply
  

  zubair258

  Member

  112 Points

  129 Posts

  Re: how to insert Russia language text into database and how to get

  Dec 05, 2011 09:00 AM|LINK

  sorry dear

  i dont want like this , i can do this like you. but when i insert ruussian text from admin side website page its give me like that text when i can insert ??????????????????????????????????????????????????????????????????????????????????????

  so my data type also correct and when i can edit in database and i can write russain text its working but on webiste when i can insert its not working , give me that message ???????????????????????????????????????

  so please give me the code of c#  how can i insert russian text

  english text is working and insert normally .

  thanks

  Zubair258
• • Reply
  

  mezzanine74

  Contributor

  2480 Points

  730 Posts

  Re: how to insert Russia language text into database and how to get

  Dec 05, 2011 09:15 AM|LINK

  Hi,

  How is your INSERT statement look like? Which control are you using to INSERT data, SqlDataSource or etc?

  please mark as answer if it helps you
• • Reply
  

  zubair258

  Member

  112 Points

  129 Posts

  Re: how to insert Russia language text into database and how to get

  Dec 05, 2011 10:07 AM|LINK

  default.aspx 

  <asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="Server">
      <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server" />
      <h3>
          Home Page text Change</h3>
      <table>
          <tr>
              <td>
                  Title Name: *
              </td>
              <td>
                  <asp:TextBox ID="home_Title" runat="server" CssClass="wm" />
                 
              </td>
          </tr>
          <tr>
              <td colspan="4" style="text-align: left;">
                  <h3>
                      :: Description ::</h3>
              </td>
          </tr>
          <tr>
              <td valign="top">
              </td>
              <td colspan="3">
                 <asp:TextBox ID="Home_name" runat="server" CssClass="wm" TextMode="MultiLine" Height="302px"
                      Width="590px" />-
                  
              </td>
          </tr>
          <tr>
              <td colspan="2" class="style1">
                  <asp:Button ID="Add_Home" CssClass="prdbtn" runat="server" Text="Submit" OnClientClick="return checkEmpty();"
                      OnClick="Add_Home_Click1" />
              </td>
          </tr>
      </table>
  </asp:Content>

  back end code

  on default.aspx.cs page

  using System;
  using System.Collections.Generic;
  using System.Web;
  using System.Web.UI;
  using System.Web.UI.WebControls;
  using System.Security;
  using System.Security.Permissions;
  using System.IO;
  using System.Text;
  
  public partial class Adm_product_add_Home : System.Web.UI.Page
  {
      DBcommand DBAcquire = new DBcommand();
      protected void Page_Load(object sender, EventArgs e)
      {
          Label prd_info = new Label();
          if (!Page.IsPostBack)
          {
  
              string type = Request.QueryString["type"].ToString();
              if (type == "add")
              {
  
              }
              else
              {
                  DBAcquire.open_conn();
                  int id = DBAcquire.GetID("select catid from Home where Cat='" + Request.QueryString["catid"] + "'");
  
  
                  DBAcquire.new_comm("select Cat, description from Home where catid=" + id + "");
                  DBAcquire.DBReader();
                  if (DBAcquire.readDB.Read())
                  {
                      home_Title.Text = DBAcquire.readDB.GetValue(0).ToString();
                      Home_name.Text = DBAcquire.readDB.GetValue(1).ToString();
                    //  prd_info.Text = DBAcquire.readDB.GetValue(1).ToString();
                  }
  
                  DBAcquire.readDB.Close();
                  DBAcquire.comm.Cancel();
                  DBAcquire.close_conn();
                // Home_name.Content = prd_info.Text;
              }
          }
      }
  
      protected void Add_Home_Click1(object sender, EventArgs e)
      {
          String type;
          type = Request.QueryString["type"].ToString();
          if (type == "add")
          {
  
              DBAcquire.open_conn();
              string state;
              int pass = 0;
              state = "select max(pos) from Home";
              DBAcquire.new_comm(state);
              DBAcquire.DBReader();
  
              while (DBAcquire.readDB.Read())
              {
  
                  if (!DBAcquire.readDB.IsDBNull(0))
                  {
                      pass = Convert.ToInt32(DBAcquire.readDB.GetValue(0));
                  }
              }
              pass++;
  
              DBAcquire.readDB.Close();
              string str;
              str = string.Format("insert into Home (Cat, description, pos) values ('" + home_Title.Text + "','" + Home_name.Text + "'," + pass + ")");
              DBAcquire.new_comm(str);
              DBAcquire.comm.ExecuteNonQuery();
              DBAcquire.close_dbcommands();
              DBAcquire.close_conn();
          }
  
          else
          {
  
              DBAcquire.open_conn();
              int id = DBAcquire.GetID("select Catid from Home where Cat='" + Request.QueryString["Catid"] + "'");
              string qry;
              qry = string.Format("update Home set Cat ='" + home_Title.Text + "', description='" + Home_name.Text + "' where Catid=" + id + "");
              DBAcquire.new_comm(qry);
              Response.Write(qry);
              DBAcquire.executecommand();
              DBAcquire.comm.Cancel();
              DBAcquire.close_conn();
          }
  
          Response.Redirect("default.aspx");
      }
  }

  my class code is here DBCommand.cs page code

  using System;
  using System.Collections.Generic;
  using System.Web;
  using System.Data.Sql;
  using System.Configuration;
  using System.Data.SqlClient;
  using System.Collections;
  /// <summary>
  /// Summary description for DBcommand
  /// </summary>
  public class DBcommand
  {
      #region Global Variables
      SqlConnection conn;
      public SqlCommand comm, comm1;
      public SqlDataReader readDB, readDB1;
      #endregion
      public DBcommand()
      {
          //
          // TODO: Add constructor logic here
          //
          conn = new SqlConnection();
  
  
      }
      public void open_conn()
      {
          if (conn.State == System.Data.ConnectionState.Closed)
          {
  
              conn.ConnectionString = @"Data Source=ZUBAIRKHALIL-PC\SQLEXPRESS;Initial Catalog=germony;Integrated Security=True;MultipleActiveResultSets=True";
              conn.Open();
  
          }
      }
      public void close_conn()
      {
          conn.Close();
          conn.Dispose();
      }
      public void new_comm(String query)
      {
          comm = new SqlCommand(query.ToString().Replace("false", "0").Replace("true", "1").Replace("False", "0").Replace("True", "1").Replace("Ucase", "UPPER").Replace("UCase", "UPPER"), conn);
      }
      public void new_comm1(String query)
      {
          comm1 = new SqlCommand(query.ToString().Replace("false", "0").Replace("true", "1").Replace("False", "0").Replace("True", "1").Replace("Ucase", "UPPER").Replace("UCase", "UPPER"), conn);
          if (readDB1 != null)
          {
              readDB1.Close();
          }
      }
      public void DBReader()
      {
          if (readDB != null)
          {
              readDB.Close();
          }
          readDB = comm.ExecuteReader();
      }
      public void DBReader1()
      {
          readDB1 = comm1.ExecuteReader();
      }
      public void close_dbcommands()
      {
          readDB.Close();
          comm.Cancel();
      }
      public void executecommand()
      {
          comm.ExecuteNonQuery();
      }
      public void executefast()
      {
          comm.ExecuteScalar();
      }
      public System.Data.DataView get_dataset(String query)
      {
          System.Data.DataSet ds = new System.Data.DataSet();
          System.Data.SqlClient.SqlDataAdapter data = new System.Data.SqlClient.SqlDataAdapter(query.ToString().Replace("false", "0").Replace("true", "1").Replace("False", "0").Replace("True", "1").Replace("Ucase", "UPPER").Replace("UCase", "UPPER"), conn);
          data.Fill(ds, "Country_name");
          return ds.Tables[0].DefaultView;
      }
      public System.Data.DataTable GetData(string qry)
      {
          if (conn.State != System.Data.ConnectionState.Open)
              open_conn();
          System.Data.DataTable dt = new System.Data.DataTable();
          SqlDataAdapter cmd = new SqlDataAdapter(qry.ToString().Replace("false", "0").Replace("true", "1").Replace("False", "0").Replace("True", "1").Replace("Ucase", "UPPER").Replace("UCase", "UPPER"), conn);
  
          cmd.Fill(dt);
          return dt;
      }
      public string Encoder(String pass)
      {
          try
          {
              byte[] encData_byte = new byte[pass.Length];
              encData_byte = System.Text.Encoding.UTF8.GetBytes(pass);
              string encodedData = Convert.ToBase64String(encData_byte);
              return encodedData;
          }
          catch (Exception ex)
          {
              throw new Exception("Error in base64Encode" + ex.Message);
          }
      }
      public string decoder(String pass)
      {
          System.Text.UTF8Encoding encoder = new System.Text.UTF8Encoding();
          System.Text.Decoder utf8Decode = encoder.GetDecoder();
          byte[] todecode_byte = Convert.FromBase64String(pass);
          int charCount = utf8Decode.GetCharCount(todecode_byte, 0, todecode_byte.Length);
          char[] decoded_char = new char[charCount];
          utf8Decode.GetChars(todecode_byte, 0, todecode_byte.Length, decoded_char, 0);
          string result = new String(decoded_char);
          return result;
      }
      public string folder_name_encode(String url)
      {
          url = url.ToString().Replace(" ", "_").Replace("/", "[0]").Replace("<", "[1]").Replace(">", "[2]").Replace(":", "[3]").Replace("*", "[4]").Replace("?", "[5]").Replace("|", "[6]").Replace("\"", "").Replace("\\\\", "[8]");
          return url;
      }
      public string url_split(String url)
      {
          String[] uri = url.ToLower().Replace("code", "#").Split('#');
          return uri[0];
      }
      public Int32 GetID(string qry)
      {
          Int32 id = 0;
          SqlDataAdapter da = new SqlDataAdapter(qry, conn);
          System.Data.DataTable dt = new System.Data.DataTable();
          da.Fill(dt);
          id = (dt.Rows.Count > 0) ? Convert.ToInt32(dt.Rows[0][0]) : 0;
          return id;
  
      }
      public void executenonquery(string query)
      {
  
          if (conn.State != System.Data.ConnectionState.Open)
              open_conn();
          SqlCommand cmd = new SqlCommand(query, conn);
          cmd.ExecuteNonQuery();
          conn.Close();
      }
  }

  check this three file i can insert when i click on ADD button then go to the default.aspx page , i can send query string to this page

  like this

  protected void add_Home_Click(object sender, EventArgs e)
      {
          string strqry;
          strqry = "select catid from Home where cat='" + Home.SelectedItem + "'";
  
          try
          {
  
              DBAcquire.open_conn();
              DBAcquire.new_comm(strqry);
              DBAcquire.DBReader();
              int add = 0;
              while (DBAcquire.readDB.Read())
              {
                  add = Convert.ToInt32(DBAcquire.readDB.GetValue(0).ToString());
              }
              Response.Redirect("default.aspx?type=add&catid=" + add + "");
              DBAcquire.close_dbcommands();
              DBAcquire.close_conn();
  
          }
          catch (Exception ex)
          {
              Response.Write(ex.ToString());
          }
  
      }

  database table code here 

  CREATE TABLE [dbo].[Home](
  	[Catid] [int] IDENTITY(1,1) NOT NULL,
  	[Cat] [nvarchar](4000) NULL,
  	[Pos] [int] NULL,
  	[Description] [nvarchar](4000) NULL,
   CONSTRAINT [PK_Home] PRIMARY KEY CLUSTERED 
  (
  	[Catid] ASC
  )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
  ) ON [PRIMARY]

  Zubair258
  • Edited by zubair258 on Dec 05, 2011 10:09 AM
• • Reply
  

  mezzanine74

  Contributor

  2480 Points

  730 Posts

  Re: how to insert Russia language text into database and how to get

  Dec 05, 2011 11:09 AM|LINK

  <div class="WordSection1">

  Hi,

   

  Please use following syntax in your INSERT and UPDATE commands. Try to add N for text parameters

   

  str = string.Format("insert into Home (Cat, description, pos) values (N'" + home_Title.Text + "',N'" + Home_name.Text + "'," + pass + ")");

   

  qry = string.Format("update Home set Cat = N'" + home_Title.Text + "', description= N'" + Home_name.Text + "' where Catid=" + id + "");

   

   

   

  </div>
  please mark as answer if it helps you
  • Edited by zubair258 on Dec 07, 2011 04:26 AM
  • Edited by zubair258 on Dec 09, 2011 05:39 AM
  • Marked as answer by zubair258 on Dec 09, 2011 05:39 AM