返回首页

您好
我想用C#代码文件mysql数据库的连接。
会有什么样的连接字符串,我需要什么设置后安装MySQL:8198859 |会员

回答

评论会员:游客 时间:2012/02/04
imgsrc=src="http://feeds.wordpress.com/1.0/comments/jasondove.wordpress.com/24/"{A}连接字符串,你总是可以参考{A2的}]
DonnieHunniecutt
评论会员:游客 时间:2012/02/04
你这样做你将MicrosoftSQL数据库相同,但使用MySqlConnection,命令,和读者。这里有一个流行的代码示例codepre<prelang=spanclass="code-string""/spanspanclass="code-string"c#"/spanstringMyConString=spanclass="code-string""/spanspanclass="code-string"SERVER=localhost;"/span+spanclass="code-string""/spanspanclass="code-string"DATABASE=mydatabase;"/span+spanclass="code-string""/spanspanclass="code-string"UID=testuser;"/span+spanclass="code-string""/spanspanclass="code-string"PASSWORD=testpassword;"/span;MySqlConnectionconnection=newMySqlConnection(MyConString);MySqlCommandcommand=connection.CreateCommand();MySqlDataReaderReader;command.CommandText=spanclass="code-string""/spanspanclass="code-string"select*frommycustomers"/span;connection.spanclass="code-keyword"Open/span();Reader=command.ExecuteReader();spanclass="code-keyword"while/span(Reader.spanclass="code-keyword"Read/span()){stringthisrow=spanclass="code-string""/spanspanclass="code-string""/span;spanclass="code-keyword"for/span(spanclass="code-keyword"int/spani=0;i<reader.fieldcount;i++)>thisrow+=Reader.GetValue(i).ToString()+spanclass="code-string""/spanspanclass="code-string","/span;listBox1.Items.spanclass="code-keyword"Add/span(thisrow);}connection.spanclass="code-keyword"Close/span();/pre/code
{A3的}]为MySQL在各种连接字符串选项一看