求一个连接MYSQL的实例，在web.config中怎么写，在页面中如何调用。。。

fredtaylor 2009-12-07 12:55:12

如题，链接的是MYSQL数据库，在web.config中如何写连接字符串？

另外，在页面中怎么调用并查询数据库？

菜鸟，求指点！！！

现在已经有一个链接字符串，不知道怎么用。



        MySqlConnection myConnection = new MySqlConnection("Database=xbxx;Data Source=localhost;User Id=root;Password=baobaowawa");

        MySqlCommand myCommand = new MySqlCommand(query, myConnection);



        myCommand.Connection = myConnection;

        myConnection.Open();

        MySqlDataReader myReader;

        myReader = myCommand.ExecuteReader();

...全文

999 11 打赏收藏转发到动态举报

写回复

用AI写文章

11 条回复

切换为时间正序

请发表友善的回复…

发表回复

fredtaylor 2009-12-07

打赏
举报

[Quote=引用 9 楼 wuyq11 的回复:]
Data Source=server; Database=mydb; User ID=username; Password=pwd; Command Logging=false"

using eInfoDesigns.dbProvider.MySqlClient;
MySqlConnection oMySqlConn = new MySqlConnection();
oMySqlConn.ConnectionString = "";
oMySqlConn.Open();
使用数据库操作类
数据库操作类

[/Quote]

这个始终提示用户名密码错误。、

我的web.config文件是这样写的：



<appSettings/>

    <connectionStrings>

        <add name="Connection" connectionString="Data Source=localhost; Database=xbxx;User ID=root;Password=baobaowawa;Port=3306" />

    </connectionStrings>

页面中是这样调用的：



MySqlConnection oMySqlConn = new MySqlConnection();

        oMySqlConn.ConnectionString = "";

        



        string query = "select * from cool_content";



        //MySqlConnection myConnection = new MySqlConnection("Database=xbxx;Data Source=localhost;User Id=root;Password=baobaowawa");

        MySqlCommand myCommand = new MySqlCommand(query, oMySqlConn);



        myCommand.Connection = oMySqlConn;

        //myConnection.Open();

        oMySqlConn.Open();

        MySqlDataReader myReader = myCommand.ExecuteReader();

悔说话的哑巴 2009-12-07

打赏
举报

Data Source=server; Database=mydb; User ID=username; Password=pwd; Command Logging=false"

using eInfoDesigns.dbProvider.MySqlClient;
MySqlConnection oMySqlConn = new MySqlConnection();
oMySqlConn.ConnectionString = "";
oMySqlConn.Open();
这个比较常用

wuyq11 2009-12-07

打赏
举报

panzhaojl 2009-12-07

打赏
举报

string sqlconn 最好改成
private static string sqlconn

panzhaojl 2009-12-07

打赏
举报

密码你自己记得改 sqlconn 就是获取的连接字

panzhaojl 2009-12-07

打赏
举报

配置文件：
<connectionStrings>
<add name="Connection" connectionString="server=localhost;database=xbxx;uid=sa;pwd=123456"/>
</connectionStrings>
代码：

string sqlconn = System.Configuration.ConfigurationManager.ConnectionStrings["Connection"].ConnectionString.ToString();

红街咖啡 2009-12-07

打赏
举报

web.config下设置:

<appSettings>



    <add key="Mysqlstudb" value="User Id=root;Host=localhost;Database=studb;Password=root;Port=3307"/>    



    <add key="FCKeditor:BasePath" value="~/FCKeditor/"/>



    <add key="FCKeditor:UserFilesPath" value="~/image"/>   



</appSettings>

查询调用存储过程:



using System;



using System.Data;



using System.Configuration;



using System.Collections;



using System.Web;



using System.Web.Security;



using System.Web.UI;



using System.Web.UI.WebControls;



using System.Web.UI.WebControls.WebParts;



using System.Web.UI.HtmlControls;



 



using MySql.Data.MySqlClient;  



 

    private MySqlCommand mycomm;



    private MySqlDataReader dr;



    private string strconn = ConfigurationManager.AppSettings["Mysqlstudb"];



    private MySqlConnection myco;



    protected void Page_Load(object sender, EventArgs e)



    {



        if (!IsPostBack)



        {



          //  string sql = "select kind_id,kind_name from kind where kind_type='notice'";//新闻,通知,公告类



            myco = new MySqlConnection(strconn);



            myco.Open();



 



           // mycomm = new MySqlCommand(sql, myco);



            mycomm = new MySqlCommand("kind_pro",myco);



            mycomm.CommandType = CommandType.StoredProcedure;



            mycomm.Parameters.Add("@kind_type", "notice");



            dr = mycomm.ExecuteReader();



            while (dr.Read())



            {



                kind_id.Items.Add(new ListItem(dr["kind_name"].ToString(), dr["kind_id"].ToString()));



 



            }



          //  kind_id.SelectedIndexChanged += new EventHandler(kind_id_SelectedIndexChanged);



            mycomm.Dispose();



            dr.Dispose();



            myco.Close();



            create_date.Text = System.DateTime.Now.Date.ToShortDateString();



            create_time.Text = System.DateTime.Now.ToString();



        }



        



    }



 



写入数据调用存储过程:



 



protected void News_ADD_bt_Click(object sender, EventArgs e)



    {



        myco = new MySqlConnection(strconn);



        myco.Open();



        mycomm = new MySqlCommand("notice_add_pro", myco);



        mycomm.CommandType = CommandType.StoredProcedure;



        mycomm.Parameters.Add("@idnam", idnam.Text);



        mycomm.Parameters.Add("@content", FCKeditor1.Value);



        mycomm.Parameters.Add("@create_date", create_date.Text);



        mycomm.Parameters.Add("@create_time", create_time.Text);



        mycomm.Parameters.Add("@from_where", from_where.Text);



        mycomm.Parameters.Add("@iduse", "mayeping");



        mycomm.Parameters.Add("@kind_id", kind_id.SelectedValue);



 



        mycomm.ExecuteNonQuery();



        mycomm.Dispose();



        myco.Close();



 



        idnam.Text = "";



        FCKeditor1.Value = "";



        create_date.Text = System.DateTime.Now.Date.ToShortDateString();



        create_time.Text = System.DateTime.Now.ToString();



 



        //idnam,content,create_date,create_time,from_where,iduse,kind_id



    }

fredtaylor 2009-12-07

打赏
举报

[Quote=引用 2 楼 tzs2304 的回复:]
XML code<connectionStrings><addname="Connection String" connectionString="server=localhost;database=xbxx;uid=sa;pwd=123456"
providerName="System.Data.SqlClient"/></connectionStrings>
[/Quote]
很感谢，那类要怎么写呢？

fredtaylor 2009-12-07

打赏
举报

[Quote=引用 1 楼 fredtaylor 的回复:]
没人吗？
[/Quote]

很感谢，那类要怎么写呢？

tzs2304 2009-12-07

打赏
举报



<connectionStrings>

  <add name="Connection String" connectionString="server=localhost;database=xbxx;uid=sa;pwd=123456"

    providerName="System.Data.SqlClient" />

</connectionStrings>

fredtaylor 2009-12-07