C# (CSharp) MySqlConnection.CreateConn示例

示例#1

文件： Default.aspx.cs 项目： mlw6607/SWEN-344

    // Insert Simple Input
    protected void Button1_Click(object sender, EventArgs e)
    {
        MySqlConnection mySql = new MySqlConnection();
        mySql.CreateConn();
        mySql.Command = mySql.Connection.CreateCommand();
        mySql.Command.CommandText = "insert into try1 (Fname, Lname, age) values ('Bill','Smith',56);";

        mySql.Command.ExecuteNonQuery();

        mySql.Command.Dispose();
        mySql.Connection.Close();
        mySql.CloseConn();
    }

示例#2

    // Insert Simple Input
    protected void Button1_Click(object sender, EventArgs e)
    {
        MySqlConnection mySql = new MySqlConnection();

        mySql.CreateConn();
        mySql.Command             = mySql.Connection.CreateCommand();
        mySql.Command.CommandText = "insert into try1 (Fname, Lname, age) values ('Bill','Smith',56);";

        mySql.Command.ExecuteNonQuery();

        mySql.Command.Dispose();
        mySql.Connection.Close();
        mySql.CloseConn();
    }

示例#3

文件： Default.aspx.cs 项目： mlw6607/SWEN-344

    // Insert more complicated Input
    protected void Button2_Click(object sender, EventArgs e)
    {
        MySqlConnection mySql = new MySqlConnection();
        mySql.CreateConn();
        mySql.Command = mySql.Connection.CreateCommand();

        String sqlInsert = "insert into try1 (Fname, Lname, age) values ('" + fName.Text + "','" + lName.Text + "'," + age.Text + ");";
        Response.Write(sqlInsert);

        mySql.Command.CommandText = sqlInsert;
        mySql.Command.ExecuteNonQuery();
        mySql.Command.Dispose();
        mySql.Connection.Close();
        mySql.CloseConn();
    }

示例#4

    // Show all results
    protected void Button3_Click(object sender, EventArgs e)
    {
        MySqlConnection mySql = new MySqlConnection();

        mySql.CreateConn();
        mySql.Command = mySql.Connection.CreateCommand();

        String sqlSearch = "select * from try1 order by ID;";

        Response.Write(sqlSearch);

        mySql.Command.CommandText = sqlSearch;
        GridView1.DataSource      = mySql.Command.ExecuteReader();
        GridView1.DataBind();
        mySql.Connection.Close();
    }

示例#5

文件： Default.aspx.cs 项目： mlw6607/SWEN-344

    // Show all results
    protected void Button3_Click(object sender, EventArgs e)
    {
        MySqlConnection mySql = new MySqlConnection();
        mySql.CreateConn();
        mySql.Command = mySql.Connection.CreateCommand();

        String sqlSearch = "select * from try1 order by ID;";
        Response.Write(sqlSearch);

        mySql.Command.CommandText = sqlSearch;
        GridView1.DataSource = mySql.Command.ExecuteReader();
        GridView1.DataBind();
        mySql.Connection.Close();


    }

示例#6

    // Insert more complicated Input
    protected void Button2_Click(object sender, EventArgs e)
    {
        MySqlConnection mySql = new MySqlConnection();

        mySql.CreateConn();
        mySql.Command = mySql.Connection.CreateCommand();

        String sqlInsert = "insert into try1 (Fname, Lname, age) values ('" + fName.Text + "','" + lName.Text + "'," + age.Text + ");";

        Response.Write(sqlInsert);

        mySql.Command.CommandText = sqlInsert;
        mySql.Command.ExecuteNonQuery();
        mySql.Command.Dispose();
        mySql.Connection.Close();
        mySql.CloseConn();
    }

示例#7

    // Make sure the select statement is sanitized
    protected void Button5_Click(object sender, EventArgs e)
    {
        DataSet         userDataset = new DataSet();
        MySqlConnection mySql       = new MySqlConnection();

        mySql.CreateConn();
        mySql.Command = mySql.Connection.CreateCommand();

        SqlDataAdapter myCommand = new SqlDataAdapter("select * from try1 where ID=@id", mySqlConnectionString);

        myCommand.SelectCommand.Parameters.Add("@id", SqlDbType.VarChar, 50);
        myCommand.SelectCommand.Parameters["@id"].Value = txtSanitize.Text;
        myCommand.Fill(userDataset);



        GridView1.DataSource = userDataset;
        GridView1.DataBind();
        mySql.Connection.Close();
    }

示例#8

    // Get user input
    protected void Button4_Click(object sender, EventArgs e)
    {
        MySqlConnection mySql = new MySqlConnection();

        mySql.CreateConn();
        mySql.Command = mySql.Connection.CreateCommand();

        String sqlSearch = "select * from try1 where ID= " + txtID.Text + ";";

        Response.Write(sqlSearch);

        mySql.Command.CommandText = sqlSearch;
        GridView1.DataSource      = mySql.Command.ExecuteReader();
        GridView1.DataBind();
        mySql.Connection.Close();



        // 1; delete from try1 where ID > 4
        // 1 or ID >2;
    }

示例#9

文件： Default.aspx.cs 项目： mlw6607/SWEN-344

    // Get user input
    protected void Button4_Click(object sender, EventArgs e)
    {

        MySqlConnection mySql = new MySqlConnection();
        mySql.CreateConn();
        mySql.Command = mySql.Connection.CreateCommand();

        String sqlSearch = "select * from try1 where ID= " + txtID.Text + ";";
        Response.Write(sqlSearch);

        mySql.Command.CommandText = sqlSearch;
        GridView1.DataSource = mySql.Command.ExecuteReader();
        GridView1.DataBind();
        mySql.Connection.Close();



        // 1; delete from try1 where ID > 4
        // 1 or ID >2;

    }

示例#10

文件： Default.aspx.cs 项目： mlw6607/SWEN-344

    // Make sure the select statement is sanitized
    protected void Button5_Click(object sender, EventArgs e)
    {
      DataSet userDataset = new DataSet();
      MySqlConnection mySql = new MySqlConnection();
      mySql.CreateConn();
      mySql.Command = mySql.Connection.CreateCommand();

      SqlDataAdapter myCommand = new SqlDataAdapter("select * from try1 where ID=@id", mySqlConnectionString);
      myCommand.SelectCommand.Parameters.Add("@id", SqlDbType.VarChar, 50);
      myCommand.SelectCommand.Parameters["@id"].Value = txtSanitize.Text;
      myCommand.Fill(userDataset);



      GridView1.DataSource = userDataset;
      GridView1.DataBind();
      mySql.Connection.Close();

    }