how to use Upper function in mysql using c#
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