using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.IO;namespace firstmdf
{
class Program
{
static void Main(string[] args)
{
string dataDir = AppDomain.CurrentDomain.BaseDirectory;
if (dataDir.EndsWith(@"\bin\Debug\") || dataDir.EndsWith(@"\bin\Release\"))
{
dataDir = System.IO.Directory.GetParent(dataDir).Parent.FullName;
AppDomain.CurrentDomain.SetData("DataDirectory", dataDir);
}
Console.WriteLine("请输入要插入的用户名:");
string username = Console.ReadLine();
Console.WriteLine("请输入要插入的密码:");
string password = Console.ReadLine();
using (SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDBFilename=
|DataDirectory|\Database1.mdf;Integrated Security=true;User Instance=true;"))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "insert into T_Users(UserName,Password)values('" + username + "','" + password + "')";
// cmd.CommandText = "Insert into T_Users(UserName,Password)values('username','password')";
cmd.ExecuteNonQuery();
Console.WriteLine("插入成功");
}
}
Console.WriteLine("打开数据库连接成功");
Console.ReadKey();
}
}
}
//执行后,插入的数据不能显示出来,各位高手帮下忙哈!
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.IO;namespace firstmdf
{
class Program
{
static void Main(string[] args)
{
string dataDir = AppDomain.CurrentDomain.BaseDirectory;
if (dataDir.EndsWith(@"\bin\Debug\") || dataDir.EndsWith(@"\bin\Release\"))
{
dataDir = System.IO.Directory.GetParent(dataDir).Parent.FullName;
AppDomain.CurrentDomain.SetData("DataDirectory", dataDir);
}
Console.WriteLine("请输入要插入的用户名:");
string username = Console.ReadLine();
Console.WriteLine("请输入要插入的密码:");
string password = Console.ReadLine();
using (SqlConnection conn = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDBFilename=
|DataDirectory|\Database1.mdf;Integrated Security=true;User Instance=true;"))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "insert into T_Users(UserName,Password)values('" + username + "','" + password + "')";
// cmd.CommandText = "Insert into T_Users(UserName,Password)values('username','password')";
cmd.ExecuteNonQuery();
Console.WriteLine("插入成功");
}
}
Console.WriteLine("打开数据库连接成功");
Console.ReadKey();
}
}
}
//执行后,插入的数据不能显示出来,各位高手帮下忙哈!
|DataDirectory|\Database1.mdf;Integrated Security=true;User Instance=true;"))数据库路径是否正确。先用一个固定的路径试试看。
dataDir = System.IO.Directory.GetParent(dataDir).Parent.Parent.FullName就行了