I want to save and retrieve data to sql in hindi language from asp.net webpage RSS

• • Reply
  sanam13

  Member

  19 Points

  84 Posts

  I want to save and retrieve data to sql in hindi language from asp.net webpage

  Jun 08, 2020 09:11 AM|sanam13|LINK

  Hlo Professionals!

  Here is my code

  Html Code

  <%@ Page Title="" Language="C#" MasterPageFile="~/Site1.Master" AutoEventWireup="true" CodeBehind="Test lang.aspx.cs" Inherits="WebApplication14.Test_lang" %>
  <asp:Content ID="Content1" ContentPlaceHolderID="title" runat="server">
  </asp:Content>
  <asp:Content ID="Content2" ContentPlaceHolderID="head" runat="server">

  
  </asp:Content>
  <asp:Content ID="Content3" ContentPlaceHolderID="body" runat="server">

  
  <div style="margin-top:30px; margin-left:20px">

  
  
  
  <h1><strong style="color:black">Test Language</strong></h1>
  <hr />

  <table>
  
  

  <tr>
  <td><span style="color:black">First Name</span><br />
  <asp:TextBox ID ="tb_name" runat="server" Width="200px" /><br />
  
  
  </td>

  <td><span style="margin-left:25px; color:black">Last Name<br /></span>
  <span style="margin-left:25px"><asp:TextBox ID="tb_last" runat="server" Width="200px" /></span> <br />
  
  </td>
  
  </tr>

  <tr>
  
  <td><br />
  <asp:Button ID="BT_submit" runat="server" Text="Submit" style="border-radius:5px" Height="35px" Width="80px" OnClick="BT_submit_Click" BackColor="#3366CC" BorderColor="#3366CC" ForeColor="White" /></td>
  </tr>
  </table>
  </div>
  <div>
  <asp:GridView runat="server" AutoGenerateColumns="false" ID="Gv1" Width="100%" >
  <Columns>
  <asp:BoundField DataField ="first_name" HeaderText ="First Name" />
  <asp:BoundField DataField ="last_Name" HeaderText ="Last Name" />

  </Columns>
  
  <EditRowStyle BackColor="#2461BF" />
  
  <FooterStyle BackColor="#507CD1" ForeColor="White" Font-Bold="True" />
  <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
  <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
  <RowStyle BackColor="#EFF3FB" />
  <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
  <SortedAscendingCellStyle BackColor="#F5F7FB" />
  <SortedAscendingHeaderStyle BackColor="#6D95E1" />
  <SortedDescendingCellStyle BackColor="#E9EBEF" />
  <SortedDescendingHeaderStyle BackColor="#4870BE" />
  </asp:GridView>
  
  
  
  </div>

  
  
  </asp:Content>

  C# Code

  using System;
  using System.Collections.Generic;
  using System.Linq;
  using System.Web;
  using System.Web.UI;
  using System.Web.UI.WebControls;
  using System.Data;
  using System.Data.SqlClient;

  namespace WebApplication14
  {
  public partial class Test_lang : System.Web.UI.Page
  {
  SqlCommand cmd = new SqlCommand();
  SqlConnection con = new SqlConnection();
  string connection = System.Configuration.ConfigurationManager.AppSettings["con"].ToString();

  public void EstablishConnection(string storeprocedure)
  {
  con.ConnectionString = connection;
  cmd.Connection = con;
  cmd.Connection.Open();
  cmd.CommandType = CommandType.StoredProcedure;
  cmd.CommandText = storeprocedure;
  }

  public void CloseConnection()
  {
  cmd.Connection.Close();
  cmd.Connection.Dispose();
  con.Close();
  }

  public void FillGridview()
  {
  SqlDataAdapter adp = new SqlDataAdapter("select * from test_hp", connection);
  adp.SelectCommand.CommandType = CommandType.Text;
  DataTable DT = new DataTable();
  adp.Fill(DT);

  Gv1.DataSource = DT;
  Gv1.DataBind();

  
  }

  protected void Page_Load(object sender, EventArgs e)
  {
  if (!Page.IsPostBack)

  
  {
  
  }

  }

  
  protected void BT_submit_Click(object sender, EventArgs e)
  {
  EstablishConnection("sp_insert_test_hp");
  cmd.Parameters.Add("@first_name", SqlDbType.VarChar, 100).Value = tb_name.Text;
  cmd.Parameters.Add("@last_name", SqlDbType.VarChar, 100).Value = tb_last.Text;
  cmd.Parameters.Add("@Remarks", SqlDbType.VarChar, 100).Value = "1";
  cmd.Parameters.Add("@date_time", SqlDbType.VarChar, 100).Value = System.DateTime.Now.ToString();
  cmd.Parameters.Add("@Status", SqlDbType.VarChar, 100).Value = "1";
  cmd.Parameters.Add("@By_whom", SqlDbType.VarChar, 100).Value = Session["username"].ToString();

  try { cmd.ExecuteNonQuery(); }

  
  catch (Exception ex1) { Response.Write("<script language=javascript>alert('" + ex1.Message.ToString() + ".')</script>"); }
  CloseConnection();

  FillGridview();
  }

  
  }
  }

• • Reply
  samwu

  Contributor

  3370 Points

  1409 Posts

  Re: I want to save and retrieve data to sql in hindi language from asp.net webpage

  Jun 08, 2020 10:04 AM|samwu|LINK

  Hi sanam13,

  sanam13

  I want to save and retrieve data to sql in hindi language from asp.net webpage

  Do you want to convert other languages to hindi? if so, you can try this demo:

  <table>
          <tr>
              <td>Type in Hindi : </td>
              <td>
                  <asp:TextBox ID="txtHindiContent" runat="server" ClientIDMode="Static" TextMode="MultiLine" Height="100" Width="250"></asp:TextBox>
              </td>
          </tr>
          <tr>
              <td>
                  </td>
              <td><asp:Button ID="btnSave" runat="server" Text="Save" OnClick="btnSave_Click" /></td>
          </tr>
          <tr>
              <td colspan="2" align="center">
                  <asp:Label ID="lblMessage" runat="server" />
              </td>
          </tr>
      </table>
      <div>
   
          <asp:GridView ID="gvContent" runat="server" AutoGenerateColumns="false">
              <Columns>
                  <asp:BoundField HeaderText="Sl No" DataField="SLID" />
                  <asp:BoundField HeaderText="Content" DataField="HindiContent" />
              </Columns>
          </asp:GridView>
      </div>
  
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
      <script type="text/javascript" src="https://www.google.com/jsapi?key=YourKeyHere">
      </script>
      <script language="javascript" type="text/javascript">
          google.load("elements", "1", {
              packages: "transliteration"
          });
   
          function onLoad() {
              var options = {
                  sourceLanguage: google.elements.transliteration.LanguageCode.ENGLISH,
                  destinationLanguage: google.elements.transliteration.LanguageCode.HINDI, // available option English, Bengali, Marathi, Malayalam etc.
                  shortcutKey: 'ctrl+g',
                  transliterationEnabled: true
              };
   
              var control = new google.elements.transliteration.TransliterationControl(options);
              control.makeTransliteratable(['txtHindiContent']);
          }
          google.setOnLoadCallback(onLoad);
   
      </script>
  protected void Page_Load(object sender, EventArgs e)
          {
              if (!IsPostBack)
              {
                  PopulateContent();
              }
          }
  
      private void PopulateContent()
          {
              using (MyDatabaseEntities dc = new MyDatabaseEntities())
              {
                  gvContent.DataSource = dc.ContentTables.ToList();
                  gvContent.DataBind();
              }
          }
  
  protected void btnSave_Click(object sender, EventArgs e)
          {
              if (!string.IsNullOrEmpty(txtHindiContent.Text.Trim()))
              {
                  using (MyDatabaseEntities dc = new MyDatabaseEntities())
                  {
                      dc.ContentTables.Add(new ContentTable
                      {
                           SLID = 0,
                           HindiContent= txtHindiContent.Text.Trim()
                      });
                      dc.SaveChanges();
                      lblMessage.Text = "Successfully saved!";
                  }
                  PopulateContent();
              }
          }

  More information about how to set the language you can refer to this video:

  https://www.youtube.com/watch?v=TV9U7Adoj_o

  Best regards,

  Sam

  IIS.NET forums are moving to a new home on Microsoft Q&A, we encourage you to go to Microsoft Q&A for .NET for posting new questions and get involved today. Learn more >