C# insert into插入的位置的问题

[zhentoufei]

我想把新的数据插入到数据显示的表的组后一行，但是为什么插入的时候总是在中间的某一航插入的啊？

public void tb_Traffic_InsertYear(int Year)
        {
            Getconn = new DatSrc_Con();
            conn = Getconn.GetCon();
            for (int month = 1; month < 13; month++)
            {
                string strCon = "insert into tb_Traffic values( " + Year.ToString() + " , " + month.ToString() + " ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0) order by Year";
                cmd = new SqlCommand(strCon, conn);
                cmd.ExecuteNonQuery();
            }
            conn.Dispose();
        }

[zhentoufei]

上面的是我的函数代码

[zhentoufei]

重新发一下，刚刚的额那个是有问题的，看下面的

public void tb_Traffic_InsertYear(int Year)
        {
            Getconn = new DatSrc_Con();
            conn = Getconn.GetCon();
            for (int month = 1; month < 13; month++)
            {
                string strCon = "insert into tb_Traffic values( " + Year.ToString() + " , " + month.ToString() + " ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)";
                cmd = new SqlCommand(strCon, conn);
                cmd.ExecuteNonQuery();
            }
            conn.Dispose();
        }

[tcmakebest]

楼主应该在显示的地方控制排序

[zhentoufei]

引用 4 楼 tcmakebest 的回复:

楼主应该在显示的地方控制排序

嗯，我突然想明白了，问了个很没含量的问题

[exception92]

楼上说的对额。 插入再排序 再显示。