Click here to Skip to main content
15,878,809 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Below is my c# code i want table column name
C#
try
                   {
                       using (MySqlConnection con = new MySqlConnection(txtOtherConStr.Text.Trim()))
                       {
                           MySqlConnectionStringBuilder builder = new MySqlConnectionStringBuilder(txtOtherConStr.Text.Trim());

                           string db = builder.Database;


                           using (MySqlCommand cmd=new MySqlCommand("SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = "+ db +" AND TABLE_NAME =@TABLE_NAME",con))
                           {

                               cmd.Parameters.Add("@TABLE_NAME", MySqlDbType.VarChar).Value = lbOtherTable.SelectedValue;

                               new MySqlDataAdapter(cmd).Fill(dt);
                           }
                       }
                   }
                   catch { }

This is my sql query but i am not get pls help me is some know solution
SQL
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = "+ db +" AND TABLE_NAME =@TABLE_NAME
Posted

1 solution

 
Share this answer
 
Comments
Arjunwalmiki 11-Apr-14 3:36am    
i have done some change my query is ("SHOW COLUMNS FROM "+ db +".TABLE_NAME = '@TABLE_NAME'",con)
can it is right?
Peter Leow 11-Apr-14 3:58am    
This should work:
"SHOW COLUMNS FROM "+ db +".@TABLE_NAME"
Arjunwalmiki 11-Apr-14 4:06am    
using (MySqlCommand cmd = new MySqlCommand("SHOW COLUMNS FROM " + db + ".'@TABLE_NAME'", con))
{
//cmd.Parameters.Add("@TABLE_SCHEMA", MySqlDbType.VarChar).Value = db.ToString();
cmd.Parameters.Add("@TABLE_NAME", MySqlDbType.VarChar).Value = lbOtherTable.SelectedValue;

new MySqlDataAdapter(cmd).Fill(dt);
}
pls can you let me know why my code is not working
Peter Leow 11-Apr-14 4:10am    
check my reply above your message.
Arjunwalmiki 11-Apr-14 4:49am    
i was try but query not excited

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900