ASP.net添加数据的问题

Question

using System.Data.SqlClient;SqlConnection connection;
SqlConnection connection2;string fn = System.IO.Path.GetFileName(HIF.PostedFile.FileName);//获取文件名
                                string flvmappath = LocalPath + fn;//获取上传路径+文件名
                                
                                
                                string connectionString = ConfigurationManager.ConnectionStrings["UploadfilesConnectionString"].ConnectionString;//连接数据库的字符串
                                //进行第一张表的操作//获取fn给Flvoriginalname，获取Flvtype给FlvType，获取loaclpath给FlvLoaclPath
                                
                                using (connection = new SqlConnection(connectionString))
                                {
                                    SqlCommand cmd = new SqlCommand
                                    ("INSERT INTO dbo.FlvInformation (FlvOriginalName, FlvType, FlvLoaclPath) VALUES (@fn, @FlvType, @LoaclPath)",connection);
                                    connconnection.Open();
                                    cmd.CommandType = CommandType.StoredProcedure;
                                    cmd.Parameters.AddWithValue("@fn", fn);
                                    cmd.Parameters.AddWithValue("@Flvtype", Flvtype);
                                    cmd.Parameters.AddWithValue("@LoaclPath", LocalPath);
                                
                                }
                                //进行第二张表的操作//获取Flvinformation给OperationRecords表的OperationRecords
                                using (connection2 = new SqlConnection(connection2))
                                {
                                    connection2 = new SqlConnection(connectionString);
                                    SqlCommand cmd2 = new SqlCommand
                                    ("insert into dbo.OperationRecords (OperationRecords) VALUES (@FlvInformation)", connection2);
                                    connconnection2.Open();
                                    cmd2.CommandType = CommandType.StoredProcedure;
                                    cmd2.Parameters.AddWithValue("@Flvinformation", Flvinformation);
                                }编译通过，但是数据库里无数据？ 哪里出错了？

Answer 1

你只是打开了连接，并没有执行这条语句，怎么会有数据呢？
connconnection2.Open();
cmd2.ExecuteNonQuery();
connconnection2.Close();

Answer 2

前面的也一样
connconnection.Open();
                                 cmd.CommandType = CommandType.StoredProcedure;
                                    cmd.Parameters.AddWithValue("@fn", fn);
                                    cmd.Parameters.AddWithValue("@Flvtype", Flvtype);
                                    cmd.Parameters.AddWithValue("@LoaclPath", LocalPath);
cmd.ExecuteNonQuery();
connconnection.Close();-------------connconnection2.Open();
                                    cmd2.CommandType = CommandType.StoredProcedure;
                                    cmd2.Parameters.AddWithValue("@Flvinformation", Flvinformation);cmd2.ExecuteNonQuery();
connconnection2.Close();

Answer 3

OK，修改好了，把源码发上来方便像我一样不懂的新手！！ string fn = System.IO.Path.GetFileName(HIF.PostedFile.FileName);//获取文件名
                                string flvmappath = LocalPath + fn;//获取上传路径+文件名
                                
                                
                                string connectionString = ConfigurationManager.ConnectionStrings["UploadfilesConnectionString"].ConnectionString;//连接数据库的字符串
                                //进行第一张表的操作//获取fn给Flvoriginalname，获取Flvtype给FlvType，获取loaclpath给FlvLoaclPath
                                
                                using (connection = new SqlConnection(connectionString))
                                {
                                    connection = new SqlConnection(connectionString);
                                    SqlCommand cmd = new SqlCommand
                                    ("INSERT INTO dbo.FlvInformation (FlvOriginalName, FlvType, FlvLoaclPath) VALUES (@fn, @FlvType, @LoaclPath)",connection);
                                    connection.Open();
                                    cmd.Parameters.AddWithValue("@fn", fn);
                                    cmd.Parameters.AddWithValue("@Flvtype", Flvtype);
                                    cmd.Parameters.AddWithValue("@LoaclPath", LocalPath);
                                    cmd.ExecuteNonQuery();
                                    connection.Close();
                                }
                                //进行第二张表的操作//获取Flvinformation给OperationRecords表的OperationRecords
                                using (connection2 = new SqlConnection(connectionString))
                                {
                                    connection2 = new SqlConnection(connectionString);
                                    SqlCommand cmd2 = new SqlCommand
                                    ("insert into dbo.OperationRecords (OperationRecords) VALUES (@FlvInformation)", connection2);
                                    connection2.Open();
                                    cmd2.Parameters.AddWithValue("@Flvinformation", Flvinformation);
                                    cmd2.ExecuteNonQuery();
                                    connection2.Close();
                                }