Table
First you need to create a Table with UTF-8 Collation.
CREATE TABLE `languages` (
`Language` varchar(30) DEFAULT NULL,
`Content` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
Then you need to refer my article Using MySQL database in ASP.Net Tutorial with example
And download the MySqlConnection DLL and add to the project.
HTML
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
<Columns>
<asp:BoundField DataField="Language" HeaderText="Language" />
<asp:BoundField DataField="Content" HeaderText="Content" />
</Columns>
</asp:GridView>
<br />
<asp:Button Text="Save" runat="server" OnClick="Save" />
Namespaces
using System.Data;
using System.Configuration;
using MySql.Data.MySqlClient;
Code
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[2] { new DataColumn("Language"), new DataColumn("Content") });
dt.Rows.Add("English", "World is beautiful.");
dt.Rows.Add("Hindi", "दुनिया सुंदर है।");
dt.Rows.Add("Marathi", "जग सुंदर आहे.");
dt.Rows.Add("Gujarati", "વિશ્વ સુંદર છે.");
dt.Rows.Add("Urdu", "دنیا خوبصورت ہے.");
dt.Rows.Add("Persian", "جهانی زیبا است.");
dt.Rows.Add("Arabic", "العالم هو جميل.");
dt.Rows.Add("Tamil", "உலக அழகாக இருக்கிறது.");
dt.Rows.Add("Telugu", "ప్రపంచ అందమైన ఉంది.");
GridView1.DataSource = dt;
GridView1.DataBind();
}
protected void Save(object sender, EventArgs e)
{
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (MySqlConnection con = new MySqlConnection(constr))
{
foreach (GridViewRow row in GridView1.Rows)
{
using (MySqlCommand cmd = new MySqlCommand("INSERT INTO Languages VALUES(@Language, @Content)", con))
{
cmd.Parameters.AddWithValue("@Language", row.Cells[0].Text);
cmd.Parameters.AddWithValue("@Content", row.Cells[1].Text);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}
}
Screenshots