以下是一个示例代码,展示了如何在ASP.NET中进行账户密码和图片的查询、增加、删除和修改操作。
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
public partial class AccountManagement : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
// 页面加载时执行的操作
LoadAccounts();
}
}
protected void LoadAccounts()
{
// 从数据库中获取所有账户信息
SqlConnection conn = new SqlConnection("YourConnectionString");
SqlCommand cmd = new SqlCommand("SELECT * FROM Accounts", conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
// 添加账户信息到GridView中
GridView1.DataSource = reader;
GridView1.DataBind();
conn.Close();
}
protected void AddAccount_Click(object sender, EventArgs e)
{
// 获取用户输入的账户和密码
string username = UsernameTextBox.Text;
string password = PasswordTextBox.Text;
// 将账户和密码插入到数据库中
SqlConnection conn = new SqlConnection("YourConnectionString");
SqlCommand cmd = new SqlCommand("INSERT INTO Accounts (Username, Password) VALUES (@Username, @Password)", conn);
cmd.Parameters.AddWithValue("@Username", username);
cmd.Parameters.AddWithValue("@Password", password);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
// 清空输入框并重新加载账户信息
UsernameTextBox.Text = "";
PasswordTextBox.Text = "";
LoadAccounts();
}
protected void DeleteAccount_Click(object sender, EventArgs e)
{
// 获取要删除的账户ID
int accountId = Convert.ToInt32(DeleteAccountIdTextBox.Text);
// 从数据库中删除对应的账户
SqlConnection conn = new SqlConnection("YourConnectionString");
SqlCommand cmd = new SqlCommand("DELETE FROM Accounts WHERE Id = @Id", conn);
cmd.Parameters.AddWithValue("@Id", accountId);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
// 清空输入框并重新加载账户信息
DeleteAccountIdTextBox.Text = "";
LoadAccounts();
}
protected void UpdateAccount_Click(object sender, EventArgs e)
{
// 获取要更新的账户ID和新的密码
int accountId = Convert.ToInt32(UpdateAccountIdTextBox.Text);
string newPassword = NewPasswordTextBox.Text;
// 更新数据库中对应的账户密码
SqlConnection conn = new SqlConnection("YourConnectionString");
SqlCommand cmd = new SqlCommand("UPDATE Accounts SET Password = @Password WHERE Id = @Id", conn);
cmd.Parameters.AddWithValue("@Password", newPassword);
cmd.Parameters.AddWithValue("@Id", accountId);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
// 清空输入框并重新加载账户信息
UpdateAccountIdTextBox.Text = "";
NewPasswordTextBox.Text = "";
LoadAccounts();
}
}
请记得将上述代码中的`YourConnectionString`替换为您自己的数据库连接字符串。另外,还需要在页面上定义对应的文本框、按钮和GridView控件。