windows平台下MySQL的C#基本操作
Windows下使用MySQL时候注意事项:
1:下载MYSQL,安装配置的时候使用 GB2312编码 , 以免中文乱码!
2:下载相应的驱动MySQLDriver 并且安装
3:编写代码的时候设置引用MySQLDriverCS.dll !
//***************************************************************************************
在MYSQL查看数据:--->
<form id="form1" runat="server">
<div> </div>
<asp:TextBox ID="tbName" runat="server"></asp:TextBox>
<asp:TextBox ID="tbAddress" runat="server"></asp:TextBox>
<asp:TextBox ID="tbTelephone" runat="server"></asp:TextBox>
<asp:Button ID="btnSubmit" runat="server" OnClick="btnSubmit_Click" Text="insert data" /><br />
<div>
<asp:GridView ID="gwShow" runat="server">
</asp:GridView>
</div>
</form>
//**************
using MySQLDriverCS;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
BindData();
}
private void BindData()
{
MySQLConnection conn = null;
conn = new MySQLConnection(new MySQLConnectionString("localhost", "MyTest", "root", "jasenkin").AsString);
//本地数据库 数据库名字 用户名root 密码
conn.Open();
MySQLCommand commn = new MySQLCommand("set names gb2312", conn);
commn.ExecuteNonQuery(); //设置set names gb2312 解决乱码
string sql = "select * from user";
MySQLDataAdapter mda = new MySQLDataAdapter(sql, conn);
DataSet ds = new DataSet();
mda.Fill(ds, "tb");
this.gwShow.DataSource = ds.Tables["tb"];
gwShow.DataBind();
conn.Close();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
MySQLConnection conn = null;
conn = new MySQLConnection(new MySQLConnectionString("localhost", "MyTest", "root", "jasenkin").AsString);
conn.Open();
MySQLCommand commn = new MySQLCommand("set names gb2312", conn);
commn.ExecuteNonQuery();
MySQLCommand comm = new MySQLCommand(string.Format("insert into user (name,address,telephone) values ({0},{1},{2})", tbName.Text.Trim(), tbAddress.Text.Trim(), tbTelephone.Text.Trim()), conn);
comm.ExecuteNonQuery();
conn.Close();
BindData();
}
}
补充:软件开发 , C# ,