记录插入SQL数据库

Question

查询到一个文件目录并插入到数据库中，怎么在数据库中插入不了，有劳大家了，谢谢

Answer 1

    protected void ReadQuotes()
        {            string nextLine, direc, input1; int i = 0; int p = 0; char input2; int k = 0;
          
            quotes = new List<string>();            StreamReader streamReader = new StreamReader(@"E:\wwwroot1\WindowsFormsApplication1\WindowsFormsApplication1\bin\Debug\config.txt");
           char str = '\\'; textBoxInput = new TextBox();           
            string directoryName = textBoxInput.Text;            
            direc = '@' + directoryName;
            // directoryName = Path.GetFullPath(foldPathname1);
            DateTime dt = Directory.GetLastWriteTime(direc);
            int result1 = 0; int result2 = 0;                      for (k = 0; k < direc.Length; k++)
            {
                result1 = direc[k].CompareTo(str);
                if (result1 == 0)                { input2 = direc[k]; i = k; }            }
            direc = directoryName.TrimStart(direc[i]);
            /*  while (directoryName[i] != '\0')
              {
                  if (directoryName[i] != '\'')                  { i++; }
                  else { input2 = directoryName[i]; p = i; i++; }              }
              direc = directoryName.TrimStart(directoryName[p]);*/            while ((nextLine = streamReader.ReadLine()) != null)
            {
                for (k = 0; k < nextLine.Length; k++)
                {                    result2 = nextLine[k].CompareTo(str);
                    if (result2 == 0)                    { input2 = nextLine[k]; p = k; }                }
                input1 = nextLine.TrimStart(nextLine[p]);                if (string.Compare(direc, input1) == 0)
                {
                    string s = direc.Substring(1, 2);
                    if ((judge(direc, 1) == "1") || (judge(direc, 1) == "2") || (judge(direc, 1) == "3") || (judge(direc, 1) == "4"))
                    {
                        switch (judge(s, 2))
                        {
                            case "BK":
                                database1(directoryName, dt);
                                break;
                            case "JL":
                                database1(directoryName, dt);
                                break;
                            case "KF":
                                database1(directoryName, dt);
                                break;
                            case "YB":
                                database1(directoryName, dt);
                                break;
                        }
                        switch (judge(s, 1))
                        {
                            case "S":
                                database1(directoryName, dt);
                                break;
                            case "T":
                                database1(directoryName, dt);
                                break;
                            case "F":
                                database1(directoryName, dt);
                                break;
                            case "J":
                                database1(directoryName, dt);
                                break;
                            case "L":
                                database1(directoryName, dt);
                                break;
                            case "B":
                                database1(directoryName, dt);
                                break;
                            case "Y":
                                database1(directoryName, dt);
                                break;
                            case "P":
                                database1(directoryName, dt);
                                break;
                            case "U":
                                database1(directoryName, dt);
                                break;
                            case "H":
                                database1(directoryName, dt);
                                break;
                            case "Q":
                                database1(directoryName, dt);
                                break;
                            case "C":
                                database1(directoryName, dt);
                                break;                        }
                  }                    if ((judge(direc, 1) == "S") || (judge(direc, 1) == "M") || (judge(direc, 1) == "J") || (judge(direc, 1) == "Y") || (judge(direc, 1) == "G") || (judge(direc, 1) == "T") || (judge(direc, 1) == "K") || (judge(direc, 1) == "W") || (judge(direc, 1) == "X") || (judge(direc, 1) == "L") || (judge(direc, 1) == "F") || (judge(direc, 1) == "Q"))
                    {
                        database1(directoryName, dt);                    }
                    if ((judge(direc, 2) == "ML") || (judge(direc, 1) == "PB") || (judge(direc, 2) == "TB") || (judge(direc, 2) == "GB") || (judge(direc, 2) == "LB") || (judge(direc, 2) == "SB") || (judge(direc, 1) == "WB") || (judge(direc, 2) == "XB") || (judge(direc, 2) == "JB") || (judge(direc, 2) == "BB") || (judge(direc, 2) == "YB") || (judge(direc, 2) == "ZB") || (judge(direc, 2) == "MB"))
                    {
                        database1(directoryName, dt);                    }
                    if ((judge(direc, 1) == "S") || (judge(direc, 1) == "T") || (judge(direc, 1) == "F"))
                    {
                        switch (judge(s, 2))
                        {
                            case "02":
                                database1(directoryName, dt);
                                break;
                            case "03":
                                database1(directoryName, dt);
                                break;
                            case "21":
                                database1(directoryName, dt);
                                break;
                            case "23":
                                database1(directoryName, dt);
                                break;
                            case "60":
                                database1(directoryName, dt);
                                break;
                            case "66":
                                database1(directoryName, dt);
                                break;
                            case "97":
                                database1(directoryName, dt);
                                break;
                            case "29":
                                database1(directoryName, dt);
                                break;                        }                    }
                    if ((judge(s, 2) == "SZ") || (judge(s, 2) == "TZ") || (judge(s, 2) == "QZ") || (judge(s, 2) == "FZ") || (judge(s, 3) == "HSZ") || (judge(s, 3) == "HTZ"))
                    {
                        database1(directoryName, dt);                    }                    if (judge(direc, 3) == "NJB")
                    {
                        database1(directoryName, dt);
                    }                }
              
             
            }            streamReader.Close();
                   }
帮我看看这个代码，数据库插不了记录，可能是哪里死循环，看不出来，有劳大家阿

Answer 2

没细看你的代码，就看到
textBoxInput = new TextBox();         
string directoryName = textBoxInput.Text;           
direc = '@' + directoryName; 
textBoxInput 你是动态创建的，它的Text肯定是空，不知道你这代码是啥意思

Answer 3

string 目录名=@'"+目录名+"'
insert into table (a) values ( cast '"+目录名+"' as varchar(50))那么多判断都成立了吗？一个个检查一下

Answer 4

没有错误提示，就是SQL数据库中没有记录