[Solved] Insert Hindi / Marathi data (text / characters) in SQL Server using ASP.Net

You need to make the column type as NVARCHAR(100).

So that you can insert Hindi characters.

TABLE

CREATE TABLE [dbo].[HindiNames](
	[Name] [varchar](100) NULL,
	[HindiName] [nvarchar](100) NULL
) ON [PRIMARY]

GO

Please refer this example

<div>
    <table border="0" cellpadding="0" cellspacing="0">
        <tr>
            <td>
                Name
            </td>
            <td>
                <asp:TextBox ID="txtName" runat="server" />
            </td>
        </tr>
        <tr>
            <td>
                hindi Name
            </td>
            <td>
                <asp:TextBox ID="txtHindiName" runat="server" />
            </td>
        </tr>
    </table>
    <br />
    <asp:Button Text="Save" OnClick="Save" runat="server" />
</div>

Namespaces

using System.Configuration;
using System.Data.SqlClient;

 C#

protected void Save(object sender, EventArgs e)
{
    string constr = ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
    string sqlStatment = "INSERT INTO [HindiNames] VALUES(@Name,@HindiName)";
    using (SqlConnection con = new SqlConnection(constr))
    {
        using (SqlCommand cmd = new SqlCommand(sqlStatment, con))
        {
            con.Open();
            cmd.Parameters.AddWithValue("@Name", this.txtName.Text.Trim());
            cmd.Parameters.AddWithValue("@HindiName", this.txtHindiName.Text.Trim());
            cmd.ExecuteNonQuery();
            con.Close();
        }
    }
}

Table Data after inserting.

Name    HindiName

India    भारत

China    चीन

Screenshot