C# UWP 查看两个数据库行

string myConnectionString;

myConnectionString = "server=localhost;uid=root;pwd=root;database=medicloud;SslMode=None;charset=utf8";


MySqlConnection connection = new MySqlConnection(myConnectionString);

MySqlCommand cmd = new MySqlCommand();


cmd.CommandType = CommandType.Text;

string sqlStr = "Select arm from assign where userId=@name";

cmd.Parameters.AddWithValue("@name", txtValue.Text);


cmd.CommandText = sqlStr;

cmd.Connection = connection;


EncodingProvider ppp;

ppp = CodePagesEncodingProvider.Instance;

Encoding.RegisterProvider(ppp);


connection.Open();


MySqlDataReader reader = cmd.ExecuteReader();

reader.Read();

string databaseLine = (reader["arm"].ToString());

connection.Close();


#endregion

txtExercise.Text = databaseLine + " (Uncomplete)\n" + databaseLine;

我正在尝试查看数据库中的两行数据。但是,我不知道如何查看它。有人能帮我吗?我尝试输入“databaseLine”两次,但都查看同一行

http://img3.mukewang.com/616132e70001f0cf06120101.jpg

如您所见,Rachel有两种类型的锻炼。我想在txtExercise.Text上查看这两个练习。但是我只能查看第一个,我无法查看第二个。


烙印99
浏览 137回答 1
1回答
打开App,查看更多内容
随时随地看视频慕课网APP