mysqldatareader什么意思_在线等急问。 MySqlDataReader.read()只能读出一行内容

usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Windows.Forms;us...

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using MySql.Data.MySqlClient;

namespace WindowsFormsApplication2

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}

private void button1_Click(object sender, EventArgs e)

{

MySqlConnection conn = new MySqlConnection("server=127.0.0.1;user id=root; password=admin; database=farm; pooling=false;charset=utf8");

string userID = userID_tb.Text;

string password = password_tb.Text;

conn.Open();

String sql = "SELECT * FROM user WHERE userid='" + userID + "'";

MySqlCommand cmd = new MySqlCommand(sql, conn);

MySqlDataReader rdr = cmd.ExecuteReader();

while (rdr.Read())

{

Console.WriteLine(rdr[0] + " -- " + rdr[1] + " -- " + rdr[2]);

}

}

}

}

我用的是mysql。data进行的c#与数据库的连结，但是现在MySqlDataReader.read()只能读出一行内容，代码在上面了，winform就两个textbox和一个Button，高手来救救我吧，如果问题解决了再追加得分

我倒，，不知道怎么回事，又好了。要是谁能在接下来的2~3个小时里让我断断续续咨询一些小问题的话就把分给谁把

展开