Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using MySql.Data.MySqlClient;
- namespace kadai03
- {
- public partial class _Default : System.Web.UI.Page
- {
- private bool Login(string userID, string password)
- {
- string connectInfo = string.Format("server={0};user id={1};password={2};database={3};",
- "localhost", "root", "", "wp22");
- using (var connection = new MySqlConnection(connectInfo))
- {
- connection.Open();
- var command = new MySqlCommand("Select Count(*) From user Where id = ?ID And pass = ?PASS;", connection);
- command.Parameters.AddWithValue("?ID", userID);
- command.Parameters.AddWithValue("?PASS", password);
- if (Convert.ToInt32(command.ExecuteScalar()) != 0) return true;
- }
- return false;
- }
- protected void Page_Load(object sender, EventArgs e) { }
- protected void ButtonLogin_Click(object sender, EventArgs e)
- {
- bool isCorrectUser = Login(TextBoxID.Text, TextBoxPassword.Text);
- if (isCorrectUser) LabelResult.Text = "ログインに成功しました。";
- else LabelResult.Text = "ログインに失敗しました。";
- }
- }
- }
Add Comment
Please, Sign In to add comment