当前位置: 首页>>代码示例>>C#>>正文


C# MySqlDataReader.ReadAsync方法代码示例

本文整理汇总了C#中MySql.Data.MySqlClient.MySqlDataReader.ReadAsync方法的典型用法代码示例。如果您正苦于以下问题:C# MySqlDataReader.ReadAsync方法的具体用法?C# MySqlDataReader.ReadAsync怎么用?C# MySqlDataReader.ReadAsync使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在MySql.Data.MySqlClient.MySqlDataReader的用法示例。


在下文中一共展示了MySqlDataReader.ReadAsync方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。

示例1: attemptLogin

        private async void attemptLogin()
        {
            try
            {
                string enteredEmail = this.Login_Email.Text + "@icrealtime.com";
                string enteredPassword = this.Login_Password.Password;
                string receivedPassword = string.Empty;
                string receivedLevel = string.Empty;

                // DB Connection
                dbConn = new MySqlConnection("Server=" + ICResponse.Properties.Settings.Default.DBServer + ";Database=" + ICResponse.Properties.Settings.Default.DBName + ";Uid=" + ICResponse.Properties.Settings.Default.DBUser + ";Pwd=" + ICResponse.Properties.Settings.Default.DBPass + ";");
                await dbConn.OpenAsync();
                // DB Command Preparation
                cmd = new MySqlCommand(ICResponse.Properties.Settings.Default.SelectAgentByEmail, dbConn);
                cmd.Parameters.AddWithValue("@email", enteredEmail);
                cmd.Prepare();
                // DB Reader Execution
                dbReader = (MySqlDataReader) await cmd.ExecuteReaderAsync();
                // Loop through results
                while (await dbReader.ReadAsync())
                {
                    receivedPassword = Convert.ToString(dbReader["password"]);
                    receivedLevel = Convert.ToString(dbReader["level"]);
                }

                if (enteredPassword != receivedPassword)
                {
                    ModernDialog msgbox = new ModernDialog();
                    msgbox.Title = "Not found";
                    msgbox.Content = "Incorrect Username or Password.";
                    msgbox.Buttons = new[] { msgbox.OkButton };
                    msgbox.ShowDialog();
                    dbReader.Close();
                }
                else
                {
                    ICResponse.Properties.Settings.Default.LoginUsername = Convert.ToString(dbReader["email"]);
                    ICResponse.Properties.Settings.Default.AgentID = Convert.ToInt32(dbReader["agentID"]);
                    ICResponse.Properties.Settings.Default.AgentFirstName = Convert.ToString(dbReader["first"]);
                    ICResponse.Properties.Settings.Default.AgentLastName = Convert.ToString(dbReader["last"]);
                    ICResponse.Properties.Settings.Default.LoginPassword = receivedPassword;
                    ICResponse.Properties.Settings.Default.LoginLevel = receivedLevel;
                    ICResponse.Properties.Settings.Default.LoginNick = ICResponse.Properties.Settings.Default.LoginUsername.Replace("@icrealtime.com", "");
                    ICResponse.Properties.Settings.Default.Save();
                    dbReader.Close();

                    var mainWindow = new MainWindow();
                    var loginWindow = Window.GetWindow(this);
                    mainWindow.Show();
                    if (loginWindow != null) loginWindow.Close();
                }

            }
            catch (MySqlException err)
            {
                System.Diagnostics.Debug.WriteLine(err);
            }
            finally
            {
                if (dbConn != null)
                {
                    dbConn.Close(); //close the connection
                }
            }
        }
开发者ID:Toffer305,项目名称:icresponse2,代码行数:65,代码来源:LogIn.xaml.cs


注:本文中的MySql.Data.MySqlClient.MySqlDataReader.ReadAsync方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。