Naeem Khan

Naeem Khan

  • 975
  • 802
  • 800k

how to use Upper function in mysql using c#

Nov 24 2009 5:40 AM
hello every one, i have big problem in mysql . i want to use Uper function when i m selected name of country... this is my store Procedure where i have used the upper function.. plz check it and let me know where is the mistak.... //this is code of MySql DELIMITER $$ DROP PROCEDURE IF EXISTS `library`.`ps_country_show` $$ CREATE DEFINER=`root`@`%` PROCEDURE `ps_country_show`() BEGIN select country_id, UPPER(country_name) from tbl_country; END $$ // this is code of C# private void show_country() { try { DataSet ds = new DataSet(); ds = gBL.show_country(); cb_country.DataSource = ds.Tables[0]; cb_country.DisplayMember = "country_name"; cb_country.ValueMember = "country_id"; } catch (Exception ex) { } i dont know where is the mistake please help me its too urgent thanks in advance

Answers (6)