110,534
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
using System.Net.NetworkInformation;
using System.Data.SqlClient;
namespace WpfApp1
{
/// <summary>
/// MainWindow.xaml 的交互逻辑
/// </summary>
public partial class MainWindow : Window
{
public MainWindow()
{
InitializeComponent();
}
//sa登录数据库验证用户名密码
private void Button_Click(object sender, RoutedEventArgs e)
{
SqlConnectionStringBuilder conb = new SqlConnectionStringBuilder();
conb.DataSource = "iipeach";
conb.InitialCatalog = "zrx_sq";
conb.ConnectionString = "User Id = sa; Password = peach";
SqlConnection conn = new SqlConnection(conb.ConnectionString);
conn.Open();
string str = "select * from users where username='" + user_TB.Text + "' and password='" + pwd_BT.Password+"'";
SqlCommand cmmd = new SqlCommand(str, conn);
SqlDataReader dr = cmmd.ExecuteReader();
if (user_TB.Text==""||pwd_BT.Password=="")
{
MessageBox.Show("请输入用户名和密码");
}
else
{
if (dr.Read())
{
this.Content = new Fwqcx();
conn.Close();
}
else
{
MessageBox.Show("用户名和密码错误");
conn.Close();
}
}
}
}
}
string strcon = "Data Source =.; Initial Catalog = zrx_sq; User ID = sa; Password = peach";
SqlConnection conn = new SqlConnection(strcon);
conn.Open();
string str = "select * from users where username='" + user_TB.Text + "' and password='" + pwd_BT.Password+"'";
SqlCommand cmmd = new SqlCommand(str, conn);
SqlDataReader dr = cmmd.ExecuteReader();
我换了一个数据库连接方式可以了
可是上面那个连接方式是不是哪里有问题
大佬能不能帮我指点一下数据库没有对象。说明你进错了数据库。
你那个SqlConnectionStringBuilder出来的链接字符串不对