SqlConnection cn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
if(TruncateTable.Checked)
{
cn.Open();
SqlCommand cmd=new SqlCommand();
cmd.CommandText="truncate table [bsc];";
cmd.Connection=cn;
cmd.CommandType=CommandType.Text;
cmd.ExecuteNonQuery();
cn.Close();
}
cn.Open();
string insertSql=" insert into [bsc](msc,mscaddress,bscname,bsctype,area,criterion,bscaddress,rl)values(@msc,@mscaddress,@bscname,@bsctype,@area,@criterion,@bscaddress,@rl)";
SqlCommand cm1=new SqlCommand(insertSql,cn);
DataSet ds=(DataSet)Session["bsc"];
string st=string.Empty;
st=ds.Tables[0].Rows.Count.ToString();
cm1.Parameters.Add("@msc",SqlDbType.VarChar,32,"MSC");
cm1.Parameters.Add("@mscaddress",SqlDbType.VarChar,128,"MSC所在地");
cm1.Parameters.Add("@bscname",SqlDbType.VarChar,32,"BSCNAME");
cm1.Parameters.Add("@bsctype",SqlDbType.VarChar,32,"BSC类型");
cm1.Parameters.Add("@area",SqlDbType.VarChar,32,"地区");
cm1.Parameters.Add("@criterion",SqlDbType.VarChar,32,"规范命名");
cm1.Parameters.Add("@bscaddress",SqlDbType.VarChar,32,"BSC所在地");
cm1.Parameters.Add("@rl",SqlDbType.Int,4,"载频容量");
System.Data.SqlClient.SqlDataAdapter sda=new SqlDataAdapter();
sda.InsertCommand=cm1;
sda.Update(ds);
cn.Close();
---我将数据集合写入数据库,在try里面没抱错,怎么数据库就是没数据...
if(TruncateTable.Checked)
{
cn.Open();
SqlCommand cmd=new SqlCommand();
cmd.CommandText="truncate table [bsc];";
cmd.Connection=cn;
cmd.CommandType=CommandType.Text;
cmd.ExecuteNonQuery();
cn.Close();
}
cn.Open();
string insertSql=" insert into [bsc](msc,mscaddress,bscname,bsctype,area,criterion,bscaddress,rl)values(@msc,@mscaddress,@bscname,@bsctype,@area,@criterion,@bscaddress,@rl)";
SqlCommand cm1=new SqlCommand(insertSql,cn);
DataSet ds=(DataSet)Session["bsc"];
string st=string.Empty;
st=ds.Tables[0].Rows.Count.ToString();
cm1.Parameters.Add("@msc",SqlDbType.VarChar,32,"MSC");
cm1.Parameters.Add("@mscaddress",SqlDbType.VarChar,128,"MSC所在地");
cm1.Parameters.Add("@bscname",SqlDbType.VarChar,32,"BSCNAME");
cm1.Parameters.Add("@bsctype",SqlDbType.VarChar,32,"BSC类型");
cm1.Parameters.Add("@area",SqlDbType.VarChar,32,"地区");
cm1.Parameters.Add("@criterion",SqlDbType.VarChar,32,"规范命名");
cm1.Parameters.Add("@bscaddress",SqlDbType.VarChar,32,"BSC所在地");
cm1.Parameters.Add("@rl",SqlDbType.Int,4,"载频容量");
System.Data.SqlClient.SqlDataAdapter sda=new SqlDataAdapter();
sda.InsertCommand=cm1;
sda.Update(ds);
cn.Close();
---我将数据集合写入数据库,在try里面没抱错,怎么数据库就是没数据...
ds是有数据的。是从Excel里导入进去的。
http://blog.csdn.net/zhzuo/archive/2004/08/06/67016.aspx
http://blog.csdn.net/zhzuo/archive/2004/08/06/67037.aspx