sqlparameter insert, update.txt

来自「数字图书馆网站」· 文本 代码 · 共 69 行

string insCmd= "Insert into Orders VALUES (@OrderID, @ProductID, @SupplierID, @Qty, @TotalRate, @OrderDate, @Status)";
				objDataAdapt.InsertCommand = objSqlConn.CreateCommand();
				objDataAdapt.InsertCommand.CommandText = insCmd;
            
				objParam = objDataAdapt.InsertCommand.Parameters.Add(new SqlParameter("@OrderID", System.Data.SqlDbType.VarChar,50));
				objParam.SourceColumn = "OrderID";
				objParam.SourceVersion = DataRowVersion.Current;

				objParam = objDataAdapt.InsertCommand.Parameters.Add(new SqlParameter("@ProductID", System.Data.SqlDbType.VarChar,50));
				objParam.SourceColumn = "ProductID";
				objParam.SourceVersion = DataRowVersion.Current;
				//
				objParam = objDataAdapt.InsertCommand.Parameters.Add(new SqlParameter("@SupplierID", System.Data.SqlDbType.VarChar,50));
				objParam.SourceColumn = "SupplierID";
				objParam.SourceVersion = DataRowVersion.Current;
            
				objParam = objDataAdapt.InsertCommand.Parameters.Add(new SqlParameter("@Qty", System.Data.SqlDbType.Int));
				objParam.SourceColumn = "Qty";
				objParam.SourceVersion = DataRowVersion.Current;

				objParam = objDataAdapt.InsertCommand.Parameters.Add(new SqlParameter("@TotalRate", System.Data.SqlDbType.Money));
				objParam.SourceColumn = "TotalRate";
				objParam.SourceVersion = DataRowVersion.Current;
            
				objParam = objDataAdapt.InsertCommand.Parameters.Add(new SqlParameter("@OrderDate", System.Data.SqlDbType.DateTime));
				objParam.SourceColumn = "OrderDate";
				objParam.SourceVersion = DataRowVersion.Current;

				objParam = objDataAdapt.InsertCommand.Parameters.Add(new SqlParameter("@Status", System.Data.SqlDbType.VarChar));
				objParam.SourceColumn = "Status";
				objParam.SourceVersion = DataRowVersion.Current;
			
				//Update command parameters
				string updCmd= "Update Orders set OrderID = @OrderID, ProductID = @ProductID, SupplierID = @SupplierID, Qty = @Qty, TotalRate = @TotalRate, OrderDate = @OrderDate, Status = @Status where OrderID = @ORG_OrderID";
				objDataAdapt.UpdateCommand = objSqlConn.CreateCommand();
				objDataAdapt.UpdateCommand.CommandText = updCmd;
            
				objParam = objDataAdapt.UpdateCommand.Parameters.Add(new SqlParameter("@OrderID", System.Data.SqlDbType.VarChar,50));
				objParam.SourceColumn = "OrderID";
				objParam.SourceVersion = DataRowVersion.Current;

				objParam = objDataAdapt.UpdateCommand.Parameters.Add(new SqlParameter("@ProductID", System.Data.SqlDbType.VarChar,50));
				objParam.SourceColumn = "ProductID";
				objParam.SourceVersion = DataRowVersion.Current;
				//
				objParam = objDataAdapt.UpdateCommand.Parameters.Add(new SqlParameter("@SupplierID", System.Data.SqlDbType.VarChar,50));
				objParam.SourceColumn = "SupplierID";
				objParam.SourceVersion = DataRowVersion.Current;
            
				objParam = objDataAdapt.UpdateCommand.Parameters.Add(new SqlParameter("@Qty", System.Data.SqlDbType.Int));
				objParam.SourceColumn = "Qty";
				objParam.SourceVersion = DataRowVersion.Current;

				objParam = objDataAdapt.UpdateCommand.Parameters.Add(new SqlParameter("@TotalRate", System.Data.SqlDbType.Money));
				objParam.SourceColumn = "TotalRate";
				objParam.SourceVersion = DataRowVersion.Current;
            
				objParam = objDataAdapt.UpdateCommand.Parameters.Add(new SqlParameter("@OrderDate", System.Data.SqlDbType.DateTime));
				objParam.SourceColumn = "OrderDate";
				objParam.SourceVersion = DataRowVersion.Current;

				objParam = objDataAdapt.UpdateCommand.Parameters.Add(new SqlParameter("@Status", System.Data.SqlDbType.VarChar));
				objParam.SourceColumn = "Status";
				objParam.SourceVersion = DataRowVersion.Current;
			
				objParam = objDataAdapt.UpdateCommand.Parameters.Add(new SqlParameter("@ORG_OrderID", System.Data.SqlDbType.VarChar,50));
				objParam.SourceColumn = "OrderID";
				objParam.SourceVersion = DataRowVersion.Original;