public static readonly string conSting = ConfigurationManager.ConnectionString["BookShop"].ConnectionString;
public static void PrepareCommand(SqlCommand cmd,SqlConnection con,string commandTest,params object[] pareameterValue) {
if (con.State!=ConnectionState.Open)
{
con.Open();
}
cmd.Connection = con;
cmd.CommandText = commandTest;
cmd.CommandType = CommandType.StoredProcedure; SqlCommandBuilder.DeriveParameters(cmd);
cmd.Parameters.RemoveAt(0);
if (pareameterValue!=null)
{
for (int i = 0; i < cmd.Parameters.Count; i++)
{
cmd.Parameters[i].Value = pareameterValue[i];
}
}
}
}我想问下这里的这个cmd.Parameters.RemoveAt(0);
为什么要移除为零的索引三层DBhelp类
public static void PrepareCommand(SqlCommand cmd,SqlConnection con,string commandTest,params object[] pareameterValue) {
if (con.State!=ConnectionState.Open)
{
con.Open();
}
cmd.Connection = con;
cmd.CommandText = commandTest;
cmd.CommandType = CommandType.StoredProcedure; SqlCommandBuilder.DeriveParameters(cmd);
cmd.Parameters.RemoveAt(0);
if (pareameterValue!=null)
{
for (int i = 0; i < cmd.Parameters.Count; i++)
{
cmd.Parameters[i].Value = pareameterValue[i];
}
}
}
}我想问下这里的这个cmd.Parameters.RemoveAt(0);
为什么要移除为零的索引三层DBhelp类
cmd.Parameters.RemoveAt(0); 不过说实话,我不觉着代码写的有啥子意义,仅仅只因为不返回参数就搞了一个莫名其妙的操作,挺抓脑袋滴