if (this.textBox1.Text == "")
{
MessageBox.Show("你没搞错吧?");
}
else
{
MySqlConnection myConnection = new MySqlConnection("server=localhost;user id=root;password=;database=account");
string query = "select * from account where Name = ?Name";
MySqlCommand myCommand = new MySqlCommand(query, myConnection);
myCommand.Parameters.Add("?Name",MySqlDbType.VarChar,32);
myCommand.Parameters["?Name"].Value =this.textBox1.Text;
myConnection.Open();
myCommand.ExecuteNonQuery();
MySqlDataReader myDataReader = myCommand.ExecuteReader();
string lblIdView = "";
if (myDataReader.Read() == true)
{
lblIdView += myDataReader["id"];
this.lblIdView.Text = lblIdView;
myConnection.Close();
MySqlConnection myConnection2 = new MySqlConnection("server=localhost;user id=root;password=;database=my");
string query2 = "select * from cq_user where id = ?id";
MySqlCommand myCommand2 = new MySqlCommand(query2, myConnection2);
myCommand2.Parameters.Add("?id", MySqlDbType.Int16);
myCommand2.Parameters["?id"].Value = myDataReader["id"];
myConnection2.Open();
myCommand2.ExecuteNonQuery();
MySqlDataReader myDataReader2 = myCommand.ExecuteReader();
string lblMainNameView = "";
string lblLevelView = "";
string lblMSView = "";
lblMainNameView += myDataReader2["name"];
this.lblMainNameView.Text = lblMainNameView;
lblLevelView += myDataReader2["level"];
this.lblLevelView.Text = lblLevelView;
lblMSView += myDataReader2["emoney"];
this.lblMSView.Text = lblMSView;
myDataReader2.Close();
myConnection2.Close();
}
else
{
MessageBox.Show("你没搞错吧?");
}
}
{
MessageBox.Show("你没搞错吧?");
}
else
{
MySqlConnection myConnection = new MySqlConnection("server=localhost;user id=root;password=;database=account");
string query = "select * from account where Name = ?Name";
MySqlCommand myCommand = new MySqlCommand(query, myConnection);
myCommand.Parameters.Add("?Name",MySqlDbType.VarChar,32);
myCommand.Parameters["?Name"].Value =this.textBox1.Text;
myConnection.Open();
myCommand.ExecuteNonQuery();
MySqlDataReader myDataReader = myCommand.ExecuteReader();
string lblIdView = "";
if (myDataReader.Read() == true)
{
lblIdView += myDataReader["id"];
this.lblIdView.Text = lblIdView;
myConnection.Close();
MySqlConnection myConnection2 = new MySqlConnection("server=localhost;user id=root;password=;database=my");
string query2 = "select * from cq_user where id = ?id";
MySqlCommand myCommand2 = new MySqlCommand(query2, myConnection2);
myCommand2.Parameters.Add("?id", MySqlDbType.Int16);
myCommand2.Parameters["?id"].Value = myDataReader["id"];
myConnection2.Open();
myCommand2.ExecuteNonQuery();
MySqlDataReader myDataReader2 = myCommand.ExecuteReader();
string lblMainNameView = "";
string lblLevelView = "";
string lblMSView = "";
lblMainNameView += myDataReader2["name"];
this.lblMainNameView.Text = lblMainNameView;
lblLevelView += myDataReader2["level"];
this.lblLevelView.Text = lblLevelView;
lblMSView += myDataReader2["emoney"];
this.lblMSView.Text = lblMSView;
myDataReader2.Close();
myConnection2.Close();
}
else
{
MessageBox.Show("你没搞错吧?");
}
}
解决方案 »
- 如何在任务栏上增加一个类似于开始按钮的按钮,可参考360软件小助手或QQ桌面小助手
- String.Empty与string.Empty
- 前台线程和后台线程 -------急
- 安装的问题 大家帮帮看看
- 请问怎么在WindowsApplication中怎么导入网页?
- 你用visual C# 调试过Hello World代码吗?是否通过了?
- panel的用法
- 我想报考高考程序员,几个问题能帮我解答一下吗?
- 请问在建控制台应用程序时出现的Automation服务器不能创建对象是什么意思啊??
- 用接口为什么能加快速度
- Remoting 将窗体序列化后,在客户show出来。
- 求教一个事务问题?SqlTransaction 已完成;它再也无法使用
这个异常怎么处理`?
两个数据库的联查`.