Click here to Skip to main content
15,881,803 members
Home / Discussions / C#
   

C#

 
GeneralRe: Cryptanalysis Algorithm RC5 Pin
KaKoten25-Jun-14 16:40
KaKoten25-Jun-14 16:40 
GeneralRe: Cryptanalysis Algorithm RC5 Pin
KaKoten23-Jun-14 12:40
KaKoten23-Jun-14 12:40 
GeneralRe: Cryptanalysis Algorithm RC5 Pin
Dave Kreskowiak23-Jun-14 2:47
mveDave Kreskowiak23-Jun-14 2:47 
QuestionPossible to get the SQL server that executed the SqlCommand? Pin
SledgeHammer0122-Jun-14 12:56
SledgeHammer0122-Jun-14 12:56 
AnswerRe: Possible to get the SQL server that executed the SqlCommand? Pin
Mycroft Holmes23-Jun-14 1:21
professionalMycroft Holmes23-Jun-14 1:21 
QuestionDynamic connector between two draw objects in canvas Pin
KRISHNARAYALU22-Jun-14 10:02
KRISHNARAYALU22-Jun-14 10:02 
AnswerRe: Dynamic connector between two draw objects in canvas Pin
BobJanova23-Jun-14 1:27
BobJanova23-Jun-14 1:27 
Questionunable to connect to any of the specified mysql Pin
Jassim Rahma21-Jun-14 22:15
Jassim Rahma21-Jun-14 22:15 
Hi,

I am trying to connect from C# WinForm application to MySQL but getting the above error.

MySQL is on CentOS and I am connected through NaviCat without any problem with enabling SSH Tuning option in NaviCat.

here is my code in C#:

C#
sql_connection = new MySqlConnection(xmlClass.get_connectionstring("BizCards\\BizCards"));
sql_connection.Open();

sql_command = new MySqlCommand("sp_populate_countries", sql_connection);
sql_command.CommandType = CommandType.StoredProcedure;

// Create data adapter object 
sql_adapter = new MySqlDataAdapter();
sql_adapter.SelectCommand = sql_command;

// Create a dataset object and fill with data using data adapter's Fill method 
data_set = new DataSet();
sql_adapter.Fill(data_set, "countries");
DataViewManager dataview_manager = new DataViewManager(data_set);
DataView main_dataview = dataview_manager.CreateDataView(data_set.Tables["countries"]);

cboCountry.Properties.ValueMember = "country_code_alpha2";
cboCountry.Properties.DisplayMember = "country_name";
cboCountry.Properties.DataSource = main_dataview;

cboCountry.Properties.Columns.Add(new DevExpress.XtraEditors.Controls.LookUpColumnInfo("country_name", 50, "country_name"));

cboCountry.Properties.ShowHeader = false;

cboCountry.Properties.PopupSizeable = false;
cboCountry.Properties.ShowFooter = false;
cboCountry.Properties.PopupWidth = 50;



Technology News @ www.JassimRahma.com

AnswerRe: unable to connect to any of the specified mysql Pin
Pete O'Hanlon21-Jun-14 23:19
mvePete O'Hanlon21-Jun-14 23:19 
GeneralRe: unable to connect to any of the specified mysql Pin
Jassim Rahma21-Jun-14 23:41
Jassim Rahma21-Jun-14 23:41 
AnswerRe: unable to connect to any of the specified mysql Pin
Bernhard Hiller22-Jun-14 21:55
Bernhard Hiller22-Jun-14 21:55 
GeneralRe: unable to connect to any of the specified mysql Pin
Jassim Rahma22-Jun-14 22:00
Jassim Rahma22-Jun-14 22:00 
AnswerRe: unable to connect to any of the specified mysql Pin
Eddy Vluggen23-Jun-14 0:25
professionalEddy Vluggen23-Jun-14 0:25 
QuestionC# creating my own class that acts like a string Pin
hpjchobbes21-Jun-14 5:23
hpjchobbes21-Jun-14 5:23 
GeneralRe: C# creating my own class that acts like a string Pin
harold aptroot21-Jun-14 5:35
harold aptroot21-Jun-14 5:35 
GeneralRe: C# creating my own class that acts like a string Pin
hpjchobbes21-Jun-14 17:20
hpjchobbes21-Jun-14 17:20 
GeneralRe: C# creating my own class that acts like a string Pin
harold aptroot21-Jun-14 20:25
harold aptroot21-Jun-14 20:25 
GeneralRe: C# creating my own class that acts like a string Pin
OriginalGriff21-Jun-14 20:29
mveOriginalGriff21-Jun-14 20:29 
GeneralRe: C# creating my own class that acts like a string Pin
hpjchobbes22-Jun-14 7:24
hpjchobbes22-Jun-14 7:24 
GeneralRe: C# creating my own class that acts like a string Pin
harold aptroot22-Jun-14 7:29
harold aptroot22-Jun-14 7:29 
GeneralRe: C# creating my own class that acts like a string Pin
hpjchobbes22-Jun-14 9:52
hpjchobbes22-Jun-14 9:52 
AnswerRe: C# creating my own class that acts like a string Pin
BobJanova23-Jun-14 1:26
BobJanova23-Jun-14 1:26 
Questionplease recommend a book for beginner Pin
solo920-Jun-14 13:10
solo920-Jun-14 13:10 
AnswerRe: please recommend a book for beginner Pin
Peter Leow20-Jun-14 16:12
professionalPeter Leow20-Jun-14 16:12 
GeneralRe: please recommend a book for beginner Pin
solo920-Jun-14 16:23
solo920-Jun-14 16:23 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.