ASP.NET

how to insert Russia text into database and how to get Russia text in asp.net using c sharp RSS

1 reply

Last post Dec 05, 2011 10:38 AM by gaikwad_anil1987

‹ Previous Thread|Next Thread ›

zubair258

Member

112 Points

129 Posts

how to insert Russia text into database and how to get Russia text in asp.net using c sharp

Dec 05, 2011 10:28 AM|LINK

here is my code

when i can insert Russia text its give me that text ???????????????????????????????????????????????????????????????????

so i want to insert Russia Text , English Text are working well but other not working why? please solve my Problem

thanks

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" />
                <%-- <asp:TextBoxWatermarkExtender ID="home_name_wm" runat="server" Enabled="True" TargetControlID="home_Title"
                    WatermarkText="Enter a Title name" />--%>
                <asp:RequiredFieldValidator ID="Required1" runat="server" ControlToValidate="home_Title"
                    ErrorMessage="Enter the Title name" Display="None" />
                <%-- <asp:ValidatorCalloutExtender ID="ValidatorCalloutExtender1" runat="server" Enabled="True"
                    TargetControlID="Required1" />--%>
            </td>
        </tr>
        <tr>
            <td colspan="4" style="text-align: left;">
                <h3>
                    :: Description ::</h3>
            </td>
        </tr>
        <tr>
            <td valign="top">
            </td>
            <td colspan="3">
                <cc1:Editor ID="Home_name" runat="server" Width="718px" AutoFocus="false" Content="Description"   Height="500px" />
                <%--<cc1:Editor ID="Home_name" runat="server" Width="718px" AutoFocus="false"   Height="500px" Content="Description" />--%>
                <%-- <asp:TextBox ID="Home_name" runat="server" CssClass="wm" TextMode="MultiLine" Height="302px"
                    Width="590px" />--%>
                <%-- <cc1:Editor ID="Home_name" Width="718px" runat="server" AutoFocus="false" Content="Description" />--%>
                <asp:RequiredFieldValidator ID="prd_editor_req" runat="server" ControlToValidate="Home_name"
                    ErrorMessage="Enter the description" Display="None" />
                <%--<asp:ValidatorCalloutExtender ID="prd_editor_req_valid" runat="server" Enabled="True"
                    TargetControlID="prd_editor_req" />--%>
            </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 + "','" + Server.HtmlDecode(Home_name.Content.Replace("'", "''")) + "'," + 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='" + Server.HtmlDecode(Home_name.Content.Replace("'", "''")) + "' 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

Marked as answer by zubair258 on Dec 07, 2011 04:26 AM

- Reply
gaikwad_anil...

Contributor

2805 Points

534 Posts

Re: how to insert Russia text into database and how to get Russia text in asp.net using c sharp

Dec 05, 2011 10:38 AM|LINK

actually you are getting the text like ??????????????????????????????????????????????????????????????????? in SQL because you don't have that font installed on your computer

install font related to russian language it will show that properly

Anil Gaikwad
www.thecodekey.com
Please mark as answer if useful

‹ Previous Thread|Next Thread ›

how to insert Russia text into database and how to get Russia text in asp.net using c sharp RSS

1 reply

zubair258

how to insert Russia text into database and how to get Russia text in asp.net using c sharp

gaikwad_anil...

Re: how to insert Russia text into database and how to get Russia text in asp.net using c sharp

This site is managed for Microsoft by Neudesic, LLC. | © 2013 Microsoft. All rights reserved.

Follow Us On:

Microsoft