public void InsertData(string objecname, string controlname, string controltype, string word_def, string word_eng, string word_loc, string word_korea) { string pathfile = Application.StartupPath + @"\option.ini"; string servername_ = Read(pathfile, "DataBase", "Server"); string database_ = Read(pathfile, "DataBase", "DataBase"); string user_ = Read(pathfile, "DataBase", "User"); conn = new ConnectSQL(servername_, database_, user_); string sql = "insert into tb_language values('" + objecname + "','" + controlname + "','" + controltype + "',N'" + word_def + "',N'" + word_eng + "',N'" + word_loc + "',N'" + word_korea + "')"; conn.ExecuteNonQuery(sql); }
public void TranslateControl(Control tmp, Control tmp1, string language) { string pathfile = Application.StartupPath + @"\option.ini"; string servername_ = Read(pathfile, "DataBase", "Server"); string database_ = Read(pathfile, "DataBase", "DataBase"); string user_ = Read(pathfile, "DataBase", "User"); conn = new ConnectSQL(servername_, database_, user_); if (tmp1 is DataGridView) { DataGridView tmp2 = (DataGridView)tmp1; for (int i = 0; i < tmp2.Columns.Count; i++) { try { string headername = tmp2.Columns[i].Name; string sql = "select " + language + " as language from tb_language where obj_name='" + tmp.Name + "' and control_name='" + headername + "'"; DataTable dt = conn.GetDataTable(sql); tmp2.Columns[i].HeaderText = dt.Rows[0]["language"].ToString(); } catch (Exception ex) { string s = ex.ToString(); } } } else { if (tmp1 is MenuStrip) { MenuStrip tmp2 = (MenuStrip)tmp1; foreach (ToolStripMenuItem tmp3 in tmp2.Items) { string sql = "select " + language + " as language from tb_language where obj_name='" + tmp.Name + "' and control_name='" + tmp3.Name + "'"; DataTable dt = conn.GetDataTable(sql); for (int i = 0; i < dt.Rows.Count; i++) { tmp3.Text = dt.Rows[0]["language"].ToString(); } } } else { string sql = "select " + language + " as language from tb_language where obj_name='" + tmp.Name + "' and control_name='" + tmp1.Name + "'"; DataTable dt = conn.GetDataTable(sql); for (int i = 0; i < dt.Rows.Count; i++) { tmp1.Text = dt.Rows[0]["language"].ToString(); } } } }