windows 服务中插入数据库

Question

   
   数据库的连接如下: 
//string con = "Data Source=127.0.0.1;database=djc;Persist Security Info=True;User ID=djc;Password=djc123456";
            string con = "Data Source=127.0.0.1;Initial Catalog=npdjc;User ID=djc;Password=djc123456";
            System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection();
            System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
            conn.ConnectionString = con;
但在启动服务后,插入数据库时就是会连不上数据库,不知道是什么原因,请问各位大侠,谢谢各位阿!!!!!!

Answer 1

 cmd.Connection= conn;
  cmd.CommandText= "select * from tablename";

Answer 2

  public void database1(string direct1, string name, string direct2, string direct3, string direct4, string direct5, string direct6, string direct7, string direct8, System.DateTime da, int flag)
        {
            //连接字符串
            //string con = "Data Source=127.0.0.1;database=djc;Persist Security Info=True;User ID=djc;Password=djc123456";
            string con = "Data Source=127.0.0.1;Initial Catalog=npdjc;User ID=djc;Password=djc123456";
            System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection();
            System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
            conn.ConnectionString = con;
            if (a.Length <= 4)
            {
                if (direct7 == "")
                {
                    try
                    {
                        if ((direct1 == "sml" || direct1 == "SML"))
                        {
                            //插入命令
                            cmd.CommandText = "insert into slj(文件夹名称,流水号,水轮机型号,主轴布置代码,转轮直径,时间) values('" + name + "','" + direct2 + "','" + direct3 + "','" + direct5 + "','" + direct6 + "','" + da + "')";
                            cmd.Connection = conn;
                            //打开连接与执行插入命令并断开连接
                            conn.Open();
                            cmd.ExecuteNonQuery();                           
                        }                    }
                    catch
                    {
                        EventLog.WriteEntry("输入重复！", EventLogEntryType.Error);
                      
                    }
                    finally
                    {
                        conn.Close();
                    }
                }
}