how to use Upper function in mysql using c#

Question

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

Kirtan Patel · Accepted Answer

Friend,
Try
UCASE() instead of UPPER() Function.
SELECT UCASE(country_name) as CountryName FROM TableNameHere
if still not getting desire result then post your gBL.showCountry() function's code will try to resolve it :)
thanks :)

Kirtan Patel · Answer

Friend ,
Here is Result From My Laptop About Using UPPER() function and Its Works Fine
private void button1_Click( object sender, EventArgs e)
{
MySqlConnection con = new MySqlConnection ( "server=127.0.0.1;User Id=root;password=12345;database=test" );
con.Open();
MySqlCommand comm = new MySqlCommand ( "select UPPER(name),age from testtable" , con);
DataSet ds = new DataSet ();
MySqlDataAdapter da = new MySqlDataAdapter (comm);
da.Fill(ds, "vtable" );
con.Clone();
dataGridView1.DataSource = ds.Tables[0];
}

Kirtan Patel · Answer

Friend,
I can Provide you Sample of doing this task
because if i ask you to send a project files then i will not get MySqlDatabase so finally i provide you sample that is doing same king of task using mysql
wait for some time just coding it for you :)

Naeem Khan · Answer

still its not working sir....
i tried each and every thing but not working... please solve it sir..
thanks in Advance

Kirtan Patel · Answer

public DataSet show_country()
{
DataSet ds = new DataSet();
string msg = "";
MySqlParameter[] myParams = new MySqlParameter[0];
try
{
gDB.OpenConnection();
ds = gDB.ExecuteDataSet("ps_country_show", myParams);
gDB.CloseConnection();
}
catch  (Exception ex)
{
msg = ex.Message;
}
return ds;
}

Naeem Khan · Answer

thank u sir for reply me but still its not working i used UCASE instead of Upper but still its not working i m sending you gbl.Show_Country() function hope you will under stand . please try to resolve my problem.....
// code
public DataSet show_country()
{
DataSet ds = null;
string msg = "";
MySqlParameter[] myParams = new MySqlParameter[0];
try
{
gDB.OpenConnection();
ds = gDB.ExecuteDataSet("ps_country_show", myParams);
gDB.CloseConnection();
}
catch (Exception ex)
{
msg = ex.Message;
}
return ds;
}
reply me fast brother