如何创建数据库?
*
* 1.创建string str = 接收连接路径
*
* 2.创建连接数据库的对象(SqlConnection,传入连接路径)
* |--SqlConnection conn = new SqlConnection(str)
*
* 3.编写SQL语句(创建string sql="SQL语句")
*
* 4.创建执行对象(SqlCommand)
* |--SqlCommand cmd = new SqlCommand(sql语句,SqlConnection连接对象)
*
* 5.打开数据库连接对象.open
* |--conn.open();
*
* 6.执行对象ExecuteNonQuery()
* |--cmd.ExecuteNonQuery();
*
* 7.关闭数据库连接对象.close
* |--conn.close();
*
*/
namespace SQL数据库
{
class Program
{
static void Main(string[] args)
{
Console.WriteLine("请输入姓名:");
stringname = Console.ReadLine();
Console.WriteLine("请输入年龄:");
stringage = Console.ReadLine();
Console.WriteLine("请输入电话:");
stringphone = Console.ReadLine();
//1.连接字符串
string str = @"DataSource=e420;Initial Catalog=tt;Integrated Security=True";
//2.创建连接对象
SqlConnection conn = new SqlConnection(str);//()传入的是(连接路径)
//3.编写SQL语句
//string sql = "insert intostudent(student.name,student.age,student.phone)values('王五',33,'13343243432')";
string sql = string.Format("insert intostudent(student.name,student.age,student.phone)values('{0}',{1},'{2}')", name, age, phone);
//4.创建 执行语句对象
SqlCommand cmd = new SqlCommand(sql, conn);//传入的是(sql语句,连接对象)
//5.打开数据库连接
conn.Open();
//6.执行语句
cmd.ExecuteNonQuery();
//7.关闭数据库连接
conn.Close();
Console . ReadKey ();