110,499
社区成员
发帖
与我相关
我的任务
分享
namespace mdf
{
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.Parent.FullName;
AppDomain.CurrentDomain.SetData("DataDirectory", dataDir);
}
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_user(Name,Password) values('admin','999999')";
cmd.ExecuteNonQuery();
Console.WriteLine("插入成功!");
}
}
Console.ReadKey();
}
}
}
{
conn.Open();
using (SqlCommand cmd =conn.CreateCommand())
{
cmd.CommandText = "insert into T_user(Name,Password) values('jerry','888888')";
int i=0;
try
{
i = cmd.ExecuteNonQuery();
}
catch(Exception ex)
{
Console.Write(ex);
}
Console.WriteLine(i.ToString());
}
}