C# asp.net i mysql baza

Odgovori Nova tema

1 odgovor
2.608 pregleda

C# asp.net i mysql baza 31.10.2008. u 15:31 · pre 219 meseci #1

Izvinjavam se u napred ako ova tema postoji.

pokusavam da se nakacim na mysql bazu:

Code:

protected void Page_Load(object sender, EventArgs e)
    {
        string dbConnStr = ConfigurationManager.ConnectionStrings["aspxConnectionString"].ConnectionString.ToString();
        string query = "SELECT * FROM user";
        SqlConnection dbConn = new SqlConnection(dbConnStr);
        SqlCommand comm = new SqlCommand(query, dbConn);

        dbConn.Open();
        comm.CommandText = query;
        SqlDataReader reader = comm.ExecuteReader();

        while (reader.Read())
        {
            Label1.Text = reader["username"].ToString();

        }
        reader.Close();
    }

i web.config

Code:

<add name="aspxConnectionString" connectionString="server=localhost;user id=root;database=aspx" providerName="MySql.Data.MySqlClient" />

dbConn.Open(); ovde dobijem upozorenje:

Login failed for user 'root'. The user is not associated with a trusted SQL Server connection.

kroz navicat sam podesio da root ima sva ovlascenja nad bazom.

u cemu je problem?

Re: C# asp.net i mysql baza 01.11.2008. u 00:02 · pre 219 meseci #2

ok resio problem:

Code:

using MySql.Data.MySqlClient;

protected void Page_Load(object sender, EventArgs e)
    {

        string dbConnStr = ConfigurationManager.ConnectionStrings["aspxConnectionString"].ConnectionString.ToString();
        string query = "SELECT * FROM user";
        MySqlConnection dbConn = new MySqlConnection(dbConnStr);
        MySqlCommand comm = new MySqlCommand(query, dbConn);

            dbConn.Open();

            comm.CommandText = query;
            MySqlDataReader reader = comm.ExecuteReader();
            while (reader.Read())
            {
                   Label1.Text = reader["username"].ToString();
            }
            reader.Close();




    }

web.config

Code:

<compilation debug="true">
      <assemblies>
    <add assembly="MySql.Data, Version=5.0.9.0, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/>
      </assemblies>
    </compilation>

Prijavite se da biste odgovorili u ovoj temi.Prijava Registracija

Forum kao aplikacija na telefonu

Srodne teme