using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace register
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void login_Click(object sender, EventArgs e)
{
string constr = "data source= Z0IFVEMLZUDERWD//数据源;initial catalog= testDB//数据库名;user id= myuser//用户名;pwd= a";
SqlConnection con = new SqlConnection(constr);//开始连接数据库
// con.ConnectionString = constr;
string sql = "select count(*) from student";
SqlCommand com = new SqlCommand(sql, con);//执行数据库语句
try
{
con.Open();
MessageBox.Show("成功连接数据库");
int x = (int)com.ExecuteScalar();
MessageBox.Show(string.Format("成功读取{0},条记录", x));
}
catch (Exception)
{
throw;
}
finally {
con.Close();
MessageBox.Show("成功关闭数据库连接", "提示信息", MessageBoxButtons.YesNoCancel);
}
}
}
}
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace register
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void login_Click(object sender, EventArgs e)
{
string constr = "data source= Z0IFVEMLZUDERWD//数据源;initial catalog= testDB//数据库名;user id= myuser//用户名;pwd= a";
SqlConnection con = new SqlConnection(constr);//开始连接数据库
// con.ConnectionString = constr;
string sql = "select count(*) from student";
SqlCommand com = new SqlCommand(sql, con);//执行数据库语句
try
{
con.Open();
MessageBox.Show("成功连接数据库");
int x = (int)com.ExecuteScalar();
MessageBox.Show(string.Format("成功读取{0},条记录", x));
}
catch (Exception)
{
throw;
}
finally {
con.Close();
MessageBox.Show("成功关闭数据库连接", "提示信息", MessageBoxButtons.YesNoCancel);
}
}
}
}