C# mysql 创建数据库

关注:145  答案:2  mip版

解决时间 2021-01-16 18:56

提问者旧梦已过期

2021-01-16 09:46

C# mysql 创建数据库

最佳答案

二级知识专家他拾裏鰅妳

2021-01-16 10:14

不知道楼主是不是要用c#创建一个数据库，

用C#来创建的话可以用脚本，如果是的话，那就是下面这些代码

private void createdata(string sql, string servername, string database,string user, string pwd)

{

string connStr = string.Format("data source=" + servername + ";database="+database+";uid=" + user + ";pwd=" + pwd + "");

SqlConnection conn = new SqlConnection(connStr);

SqlCommand cmd = new SqlCommand(sql, conn);

conn.Open();

cmd.ExecuteNonQuery();

conn.Close();

}

private void button1_Click(object sender, EventArgs e)

{

if (this.textBox2.Text == "")

{

MessageBox.Show("请输入用户名");

this.textBox2.Focus();

}

else

{

this.openFileDialog1.Filter = "txt files (*.txt)|*.txt|All files (*.*)|*.*";

this.openFileDialog1.ShowDialog();

if (this.openFileDialog1.FileName.ToString() == "")

{

MessageBox.Show("未选择脚本文件");

}

else

{

StringBuilder sqlblr = new StringBuilder();

sqlblr.Append(File.ReadAllText(this.openFileDialog1.FileName.ToString(), System.Text.Encoding.GetEncoding("GB2312")));

}

try

{

createdata(sqlblr.ToString(), this.comboBox1.SelectedItem.ToString(), "master",this.textBox2.Text, this.textBox1.Text);

this.openFileDialog1.Reset();

MessageBox.Show("创建数据库成功");

}

catch (Exception E)

{

MessageBox.Show(E.Message);

}

}

}

}

}

全部回答

1楼归人

2021-01-16 10:36

第三方组件：mysql.data.dll

说明：去官方网站下载mysql.data.dll，然后在项目中添加该组件的引用，在代码页里输入using mysql.data.mysqlclient，我们就可以顺利的使用该类库的函数建立连接了。

以下是几个常用函数：

#region 建立mysql数据库连接

/// /// 建立数据库连接.

///

/// 返回mysqlconnection对象

public mysqlconnection getmysqlcon()

{

string m_str_sqlcon = "server=localhost;user id=root;password=root;database=abc"; //根据自己的设置

mysqlconnection mycon = new mysqlconnection(m_str_sqlcon);

return mycon;

}

#endregion

#region 执行mysqlcommand命令

/// /// 执行mysqlcommand

///

/// sql语句

public void getmysqlcom(string m_str_sqlstr)

{

mysqlconnection mysqlcon = this.getmysqlcon();

mysqlcon.open();

mysqlcommand mysqlcom = new mysqlcommand(m_str_sqlstr, mysqlcon);

mysqlcom.executenonquery();

mysqlcom.dispose();

mysqlcon.close();

mysqlcon.dispose();

}

#endregion

#region 创建mysqldatareader对象

/// /// 创建一个mysqldatareader对象

///

/// sql语句

/// 返回mysqldatareader对象

public mysqldatareader getmysqlread(string m_str_sqlstr)

{

mysqlconnection mysqlcon = this.getmysqlcon();

mysqlcommand mysqlcom = new mysqlcommand(m_str_sqlstr, mysqlcon);

mysqlcon.open();

mysqldatareader mysqlread = mysqlcom.executereader(commandbehavior.closeconnection);

return mysqlread;

}

#endregion

我要举报

如以上问答内容为低俗/色情/暴力/不良/侵权的信息，可以点下面链接进行举报，我们会做出相应处理，感谢你的支持！

→点此我要举报以上信息！←

推荐资讯

大家都在看

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using MySQLDriverCS;

namespace ConsoleApplication2

{

class Program

{

static void Main(string[] args)

{

//MySQLConnection sc = null;

MySQLConnection sc = new MySQLConnection(new MySQLConnectionString( "b", "root", "sa").AsString);

try

{

sc.Open();

//MySQLCommand cmd = new MySQLCommand("insert into students values('aaaaa1',10,'bbbb',100)",sc);

//MySQLCommand cmd = new MySQLCommand("delete from students where name='aaaaa1'", sc);

MySQLCommand cmd = new MySQLCommand("update students set age=200 where name='adsf'",sc);

int i = cmd.ExecuteNonQuery();

if(i>0)

Console.WriteLine("添加数据成功");

}

catch (System.Exception ex)

{

Console.WriteLine("打开数据库错误：{0}", ex.Message);

}

finally

{

sc.Close();

Console.WriteLine("关闭数据库成功");

}

System.Console.ReadLine();

}

}

}